我正在使用Entity Framework,并想知道以下代码是否有任何区别。第一和第二个代码似乎都获取了所有项目,然后通过Entidad.Nombre ==“Empresa”进行过滤,最后一个代码似乎只获取了Entidad.Nombre ==“Empresa”的项目。 我错了吗?哪个更好?
var listFields = from b in unitOfWork.PropiedadRepository.Get()
where b.Entidad.Nombre == "Empresa"
select b;
var listFields2 = unitOfWork.PropiedadRepository.Get().Where(x => x.Entidad.Nombre == "Empresa");
var listFields3 = unitOfWork.PropiedadRepository.Get(x => x.Entidad.Nombre == "Empresa");
这是通用存储库类。所有的存储库都继承自这个类。
public sealed class GenericRepository<TEntity> where TEntity : class
{
private readonly ConfigurationDbDataContext _context;
private readonly DbSet<TEntity> _dbSet;
public GenericRepository(ConfigurationDbDataContext context)
{
_context = context;
_dbSet = context.Set<TEntity>();
}
public IEnumerable<TEntity> Get(
Expression<Func<TEntity, bool>> filter = null,
Func<IQueryable<TEntity>, IOrderedQueryable<TEntity>> orderBy = null,
string includeProperties = "")
{
IQueryable<TEntity> query = _dbSet;
if (filter != null)
{
query = query.Where(filter);
}
query = includeProperties.Split(new[] {','}, StringSplitOptions.RemoveEmptyEntries).Aggregate(query, (current, includeProperty) => current.Include(includeProperty));
// ReSharper disable once ConvertIfStatementToReturnStatement
if (orderBy != null)
{
return orderBy(query).ToList();
}
else
{
return query.ToList();
}
}
public TEntity GetById(object id)
{
return _dbSet.Find(id);
}
public void Insert(TEntity entity)
{
_dbSet.Add(entity);
}
public void Delete(object id)
{
var entityToDelete = _dbSet.Find(id);
Delete(entityToDelete);
}
public void Delete(TEntity entityToDelete)
{
if (_context.Entry(entityToDelete).State == EntityState.Detached)
{
_dbSet.Attach(entityToDelete);
}
_dbSet.Remove(entityToDelete);
}
public void Update(TEntity entityToUpdate)
{
_dbSet.Attach(entityToUpdate);
_context.Entry(entityToUpdate).State = EntityState.Modified;
}
}