Repository Pattern vs DAL

by

You’re definitely not the one who confuses things. 🙂

I think the answer to the question depends on how much of a purist you want to be.

If you want a strict DDD point of view, that will take you down one path. If you look at the repository as a pattern that has helped us standardize the interface of the layer that separates between the services and the database it will take you down another.

The repository from my perspective is just a clearly specified layer of access to data.Or in other words a standardized way to implement your Data Access Layer. There are some differences between different repository implementations, but the concept is the same.

Some people will put more DDD constraints on the repository while others will use the repository as a convenient mediator between the database and the service layer. A repository like a DAL isolates the service layer from data access specifics.

One implementation issue that seems to make them different, is that a repository is often created with methods that take a specification. The repository will return data that satisfies that specification. Most traditional DALs that I have seen, will have a larger set of methods where the method will take any number of parameters. While this may sound like a small difference, it is a big issue when you enter the realms of Linq and Expressions.
Our default repository interface looks like this:

public interface IRepository : IDisposable
{
    T[] GetAll<T>();
    T[] GetAll<T>(Expression<Func<T, bool>> filter);
    T GetSingle<T>(Expression<Func<T, bool>> filter);
    T GetSingle<T>(Expression<Func<T, bool>> filter, List<Expression<Func<T, object>>> subSelectors);
    void Delete<T>(T entity);
    void Add<T>(T entity);
    int SaveChanges();
    DbTransaction BeginTransaction();
}

Is this a DAL or a repository? In this case I guess its both.

Kim

More Related Contents:

  1. What are the main disadvantages of Java Server Faces 2.0?
  2. How do you redirect to a page using the POST verb?
  3. How to set a Default Route (To an Area) in MVC
  4. Mocking Asp.net-mvc Controller Context
  5. ASP.NET MVC 4 Web API Authentication with Membership Provider
  6. localhost refused to connect Error in visual studio
  7. ApiController returns 404 when ID contains period
  8. ASP.NET MVC and Ajax, concurrent requests?
  9. Automapper missing type map configuration or unsupported mapping – Error
  10. Difference Between $.getJSON() and $.ajax() in jQuery
  11. Fill drop down list on selection of another drop down list [closed]
  12. How do I set the request timeout for one controller action in an asp.net mvc application
  13. Best place to set CurrentCulture for multilingual ASP.NET MVC web applications
  14. ExpireTimeSpan ignored after regenerateIdentity / validateInterval duration in MVC Identity (2.0.1)
  15. ASP.NET MVC – Mixing Custom and Default Model Binding
  16. ASP.NET MVC and IIS 5
  17. ASP.NET MVC – Authenticate users against Active Directory, but require username and password to be inputted
  18. MVC5 Claims version of the Authorize attribute
  19. How can I fix assembly version conflicts with JSON.NET after updating NuGet package references in a new ASP.NET MVC 5 project?
  20. How can a formcollection be enumerated in ASP.NET MVC?
  21. IIS Redirect non-www to www AND http to https
  22. MVC controller gives me a 403 forbidden error with the default route when it’s called DocumentationController
  23. HTTP Error 500.19 and error code : 0x80070021
  24. Add a trailing slash at the end of each url?
  25. ASP.NET MVC: How to automatically disable [RequireHttps] on localhost?
  26. Implementing “Remember Me” Feature in ASP.NET MVC
  27. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  28. Razor Nested WebGrid
  29. Best practice for ASP.NET MVC resource files
  30. Include all files in a folder in a single bundle

Leave a Comment