Edward Hieatt and Rob Mee defined the repository pattern as this: Mediates between the domain and data mapping layers using a collection-like interface for accessing domain objects. In essence, it's an abstraction that separates the domain from the persistence mechanism to reduce complexity and make changes in one

Have you ever wondered how a data mapper works? In this post, I'll build a simple mapper to illustrate how it works internally. Fetching rows To start with, if you look at the IDataReader interface, you'll see that it implements an interface called IDataRecord. That interface

ADO.NET is .NETs library for accessing databases. This article will go through the abstraction layer upon which all different DB engine providers are based on. By learning this abstraction, you can access any database using .NET. There are two levels of abstraction in ADO.NET. The interfaces and the