Patterns of Creating the Data Access Layer

If you've decided not to use any ORM, then you'd need to decide about the pattern you'd like to use for creating your data access layer.

This is an old topic so I'm going to summarize them here:

• Repository Pattern
• Active Record
• Data Mapper
• Identity Map
• Table Data Gateway
• Row Data Gateway

Resources:

• http://msdn.microsoft.com/en-us/magazine/dd569757.aspx
• Patterns of Enterprise Applications Development by Martin Fowler