EntitiyFrameworkCore.GenericDesignPattern.Base 1.0.0

Using

1. Create your own DbContext,

   public class AppTestContext : DbContext {
       public AppTestContext()
       {
           ChangeTracker.LazyLoadingEnabled = false;
           ChangeTracker.AutoDetectChangesEnabled = false;
           ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
       }
       protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
       {
           if (!optionsBuilder.IsConfigured)
               optionsBuilder.UseSqlServer("connectionString");
       }
   
   public DbSet<Video> Videos { get; set; } }
   

2. Add Service,

   builder.Services.AddDbContext<AppTestContext>();
   

3. Then implement package to your repostiroyDal class and interfaces,

   public interface IVideoDal : IEfRepositoryBase<Video>
   {
   }
   

   and,

    public class VideoDal : EfRepositoryBase<Video, AppTestContext>, IVideoDal
    {
    }
   

The package include these methods,

• IEfRepositoryBase,

   TEntity GetById(Expression<Func<TEntity, bool>> filter);
   ICollection<TEntity> GetAll(Expression<Func<TEntity, bool>> filter = null);
   ICollection<TEntity> GetAllLazy(Expression<Func<TEntity, bool>> filter = null, int pageSize = 10, int pageNumber = 1);
   (bool, TEntity) Add(TEntity entity);
   bool Delete(TEntity entity);
   (bool, TEntity) Update(TEntity entity);
  
   Task<TEntity> GetByIdAsync(Expression<Func<TEntity, bool>> filter);
   Task<ICollection<TEntity>> GetAllAsync(Expression<Func<TEntity, bool>> filter = null);
   Task<ICollection<TEntity>> GetAllLazyAsync(Expression<Func<TEntity, bool>> filter = null, int pageSize = 10, int pageNumber = 1);
   Task<(bool, TEntity)> AddAsync(TEntity entity);
   Task<bool> DeleteAsync(TEntity entity);
   Task<(bool, TEntity)> UpdateAsync(TEntity entity);