Follow me to learn what is repository pattern

Recommended for you: Get network issues from WhatsUp Gold. Not end users.


Creating a generic repository pattern in an mvc application with entity framework is the first topic that we are about to cover in our journey of learning my mvc template.

this article will focus on repository pattern and shows how to design repository interface when there could be a possibility of creating more than one repository class. To overcome this possibility and overhead, we make a generic repository class for all other repositories.

  1. What is repository pattern?
  2. Why should we use it?
  3. What is the difference between repository and generic repository?

A repository basically works as a mediator between our business logic layer and our data access layer of the application.

Road Map

Part1:Follow me to learn how to use mvc template

Part2:Follow me to learn what is repository pattern



Expose the data access mechanism directly to business logic layer.

To overcome these kinds of issues, and to write an Interface driven and test driven code to access data, we use Repository Pattern. The repository makes queries to the data source for the data, and then maps the data from the data source to a business domain object, finally and persists the changes in the business entity to the data source. The separation between the data and business tiers has three benefits:

If you call the Entity Framework class object in the controller class for accessing the entity classes, now we can say that system is somewhat a tightly coupled system. To overcome this situation, as we discussed, we’ll implement Repository Pattern.


According interface hide implementation details

Repository Interface

Now,let us to see our repository interface:

public interface IRepository<T> where T : class, new()
        T Update(T entity, Expression<Func<T, bool>> filter, bool IsCommit = true);

        T Insert(T entity, bool IsCommit = true);

        void Delete(T entity, bool IsCommit = true);

        void Delete(Expression<Func<T, bool>> filter);

        IQueryable<T> Query(Expression<Func<T, bool>> filter);

        IList<T> QueryByPage<TKey>(Expression<Func<T, bool>> filter, 
            Expression<Func<T, TKey>> orderBy,int orderType, int pageSize, int pageIndex, out int recordsCount);

        IList<T> QueryByPage(Expression<Func<T, bool>> filter, 
            string orderBy, int pageSize, int pageIndex, out int recordsCount);

        T GetSingleOrDefault(Expression<Func<T, bool>> filter);

        IList<T> FindAll();

After when you look at the above interface,you may have a question:what is IsCommt?
I will tell you in the next article.


Why the repository interface is a generic interface?



      refer to

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Rudolf at November 15, 2013 - 4:12 AM