有没有人有一个非常完整的EF 6.1示例通用存储库？

我有自己的存储库,如下所示.但是,这并未考虑一些新功能,例如范围功能.有没有人有一个包含所有内容的存储库.我在网上搜索过这个,但是我找不到最新的东西.这就是我所拥有的.我希望有更多的东西,并提供许多方法的IQueryable:

namespace Services.Repositories
{
    /// 

    /// The EF-dependent, generic repository for data access
    /// 
    /// Type of entity for this Repository.
    public class GenericRepository : IRepository where T : class
    {
        public GenericRepository(DbContext dbContext)
        {
            if (dbContext == null) 
                throw new ArgumentNullException("An instance of DbContext is required to use this repository", "context");
            DbContext = dbContext;
            DbSet = DbContext.Set();
        }

        protected DbContext DbContext { get; set; }

        protected DbSet DbSet { get; set; }

        public virtual IQueryable Find(Expression> predicate)
        {
            return DbSet.Where(predicate);
        }

        public virtual IQueryable GetAll()
        {
            return DbSet;
        }

        public virtual T GetById(int id)
        {
            //return DbSet.FirstOrDefault(PredicateBuilder.GetByIdPredicate(id));
            return DbSet.Find(id);
        }

        public virtual void Add(T entity)
        {
            DbEntityEntry dbEntityEntry = DbContext.Entry(entity);
            if (dbEntityEntry.State != EntityState.Detached)
            {
                dbEntityEntry.State = EntityState.Added;
            }
            else
            {
                DbSet.Add(entity);
            }
        }

        public virtual void Update(T entity)
        {
            DbEntityEntry dbEntityEntry = DbContext.Entry(entity);
            if (dbEntityEntry.State == EntityState.Detached)
            {
                DbSet.Attach(entity);
            }  
            dbEntityEntry.State = EntityState.Modified;
        }

        public virtual void Delete(T entity)
        {
            DbEntityEntry dbEntityEntry = DbContext.Entry(entity);
            if (dbEntityEntry.State != EntityState.Deleted)
            {
                dbEntityEntry.State = EntityState.Deleted;
            }
            else
            {
                DbSet.Attach(entity);
                DbSet.Remove(entity);
            }
        }

        public virtual void Delete(int id)
        {
            var entity = GetById(id);
            if (entity == null) return; // not found; assume already deleted.
            Delete(entity);
        }
    }
}

Colin.. 14

您可以添加以下新功能:

public virtual void AddRange(IEnumerable entities)
{
    DbContext.Set().AddRange(entities);
}

public virtual void RemoveRange(IEnumerable entities)
{
    DbContext.Set().RemoveRange(entities);
}

danludwig.. 10

您不需要通用存储库.DbContext已经是一个通用的存储库.试试这个:

public class EntityDbContext : DbContext, IWriteEntities
{
    public IQueryable EagerLoad(IQueryable query,
        Expression> expression)
    {
        // Include will eager load data into the query
        if (query != null && expression != null)
            query = query.Include(expression);
        return query;
    }

    public IQueryable Query()
    {
        // AsNoTracking returns entities that are not attached to the DbContext
        return Set().AsNoTracking();
    }

    public TEntity Get(object firstKeyValue, params object[] otherKeyValues)
    {
        if (firstKeyValue == null) throw new ArgumentNullException("firstKeyValue");
        var keyValues = new List