A Super Get Method in a Generic repository implementation, using Entity Framework. Source(s): http://blog.falafel.com/Blogs/AdamAnderson/adam-anderson/2014/02/28/the-four-deadly-sins-of-linq-data-access-part-2-too-many-columns http://www.asp.net/mvc/tutorials/getting-started-with-ef-5-using-mvc-4/implementing-the-repository-and-unit-of-work-patt…

GenericRepository<TEntity>

 
          ...
           // _repository is a GenericRepository<Villa>.
           
            var villas = _repository
               .Get(
                   q => q.Select(s => new VillaDto { 
                       Id = s.PodId, 
                       Name = s.Name, 
                       Price=s.Price, 
                       Location = s.Location }),
                   f => f.Location == "Punta Cana",
                   o => o.OrderBy(i => i.Price)
               );
       ...
       
       
        public IEnumerable<TResult> SuperGet<TResult>(
            Func<IQueryable<TEntity>, IQueryable<TResult>> transform,
            Expression<Func<TEntity, bool>> filter = null,
            Func<IQueryable<TResult>, IOrderedQueryable<TResult>> orderBy = null)
        {
            // _dbSet is DbSet<TEntity> property of a DbContext
            var query = (filter == null) ? _dbSet : _dbSet.Where(filter);

            var notSortedResults = transform(query);

            return orderBy == null ? (IEnumerable<TResult>) notSortedResults : orderBy(notSortedResults).ToList();
        }

A que te refieres cuando dices que tus condiciones son opcionales?

Puedes proveer un ejemplo concreto?