Data Access Patterns

Data Access Patterns guide you in reading and writing information through clear interfaces, hiding database details so storage can change without breaking the rest of the code.

• Repository Pattern: Library Catalogue

  Explains the Repository Pattern in C# using a library catalogue analogy, showing how it simplifies and centralises data access.

• Unit of Work Pattern: Supermarket Checkout

  Explains the Unit of Work Pattern in C# using the supermarket checkout analogy to show how changes are grouped and saved together.

• Data Mapper: Delivery Service Analogy

  The Data Mapper pattern helps you move data between your application’s objects and the database, keeping both sides clean, independent, and maintainable.

• CQRS: Sending vs. Tracking Parcels at the Post Office

  Explains CQRS using the post office analogy: sending parcels changes the system, tracking them only reads information. Shows when and how to use CQRS in C# with clear sections.