Repository pattern reduce the controller code complexity. We
write the most of all business logic in
Repository with the help of entity frameworks classes.
Repository work like a mediator that means its work between
business logic and data access layers.
Steps of Implementing repository pattern in MVC 5
namespace PCX.Core.Repositories
{
/// <typeparam
name="C"></typeparam>
/// <typeparam
name="T"></typeparam>
public abstract class GenericRepository<C, T> :IGenericRepository<T> where T : class where C : DbContext, new()
{
private C _entities = new C();
public C Context
{
get { return _entities; }
set { _entities = value; }
}
public virtual IQueryable<T> GetAll()
{
IQueryable<T> query = _entities.Set<T>();
return query;
}
public IQueryable<T> FindBy(System.Linq.Expressions.Expression<Func<T, bool>> predicate)
{
IQueryable<T> query = _entities.Set<T>().Where(predicate);
return query;
}
public virtual void Add(T entity)
{
_entities.Set<T>().Add(entity);
}
public virtual void Delete(T entity)
{
_entities.Set<T>().Remove(entity);
}
public virtual void Edit(T entity)
{
_entities.Entry(entity).State =
System.Data.Entity.EntityState.Modified;
}
public virtual void Save()
{
_entities.SaveChanges();
}
}
}
namespace PCX.Core.Repositories
{
public interface IGenericRepository<T> where T : class
{
IQueryable<T> GetAll();
IQueryable<T> FindBy(Expression<Func<T, bool>> predicate);
void Add(T entity);
void Delete(T entity);
void Edit(T entity);
void Save();
}
}
namespace PCX.Core.Repositories
{
public interface IEmployeeRepository
{
List<Employee> List(string emailId);
}
}
namespace PCX.Core.Repositories
{
/// <summary>
/// Employee repository class handle all methods related to
Tenant entity.
/// </summary>
public class EmployeeRepository : GenericRepository<PCXEntities, Employee>, IEmployeeRepository
{
/// <summary>
/// Check that employee exists in database or not , If
employee exists in database then return entity.
public List<Employee> List(string emailId)
{
return Context.Employees.Where(em => em.EmailID ==
emailId).ToList();
}
}
}
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|
