What is GenericRepository

GenericRepository is a data access library using repository pattern with Entity Framework Core.

Some of the features of GenericRepository are:

• Build-in paging with filter and sorting feature
• Eager loading support
• Unit of Work to support transaction control
• Support different Entity key types

NuGet

Install-Package GenericRepository.EntityFrameworkCore

Getting started with GenericRepository

• Implement IEntityContext in the application DbContext class
• Add application DbContext in Startup:

   services.AddDataAccess<YourDbContext>(options => options.UseInMemoryDatabase(Configuration.GetConnectionString("DefaultConnection")));

• Annotate key property in entity classes with [Key] attribute or use fluent api to define key column

   public class Department
   {
        [key]
        public virtual int Id {get; set;}
        public virtual string Name {get;set;}
        public virtual User Staff{get;set;}
   }

• GenericService provides convenient ways to filter, sort, include navigation properties:

  IGenericService<YourDbContext> _genericeService;
  public HomeControl(IGenericService<YourDbContext> genericService)
   {
       _genericService=genericService;
   }
    ```
    ```xml
   var result=_genericService.Query<Department>(x=>x.Name="name1");
   if(result!=null)
   {
        result.Name="namechange1";
       _genericService.Update<Department>(result);
   }

• Multiple CRUD in one transaction

   using(var uow=_genericService.CreateUnitOfWork())
   {
      var result=_genericService.Query<Department>(x=>x.Name="name1");
      if(result!=null)
      {
        result.Name="name1change1";
       _genericService.Update(uow,result);
      }
      var result2=_genericService.Query<Department>(x=>x.Name="name2");
      if(result2!=null)
      {
        result2.Name="namechange2";
       _genericService.Update(uow,result2);
      }
      uow.SaveChanges();
   }

• Alternative is to use Unit of Work:

   using (var uow = _uowProvider.CreateUnitOfWork())
   {
       var repository = uow.GetRepository<Department>();

       foreach (var item in departments)
       {
           repository.Add(item);
       }

       await uow.SaveChangesAsync();
   }

• Filtering, sorting, paging and eager loading:

   var result=_genericService.QueryPage<Log>(startRow,pageSize,
               x=>(sessionId==null || x.SessionId==sessionId) 
               && (logLevel==null || x.LogLevel==logLevel),
               x=>x.OrderByDescending(y=>y.CreatedDate),
               x=>x.Include(y=>y.Staff));
   return result;

Or

   Func<IQueryable<Department>, IOrderedQueryable<Department>> orderBy=x=>x.OrderBy(y=>y.Name);
   Func<IQueryable<Department>, IQueryable<Department>> include=x=>x.Include(y=>y.Staff);
   var filter = PredicateBuilder.New<Department>(x => true);           
   if (!string.IsNullOrEmpty(name))               
      filter = filter.And(x => x.Name == name);
   var repository = uow.GetRepository<Department>();
   return repository.QueryPage(startRow, pageSize, filter, orderBy,include);           

License

All source code is licensed under MIT license - http://www.opensource.org/licenses/mit-license.php