Can I make my EF objects retrieve only specific columns in the sql executed? If I am executing the below code to retrieve objects, is there something I can do to only get certain columns if wanted?
public IEnumerable<T> GetBy(Expression<Func<T, bool>> exp)
{
return _ctx.CreateQuery<T>(typeof(T).Name).Where<T>(exp);
}
This would generate a select clause that contains all columns. But, if I have a column that contains a large amount of data that really slows down the query, how can I have my objects exclude that column from the sql generated?
If my table has Id(int), Status(int), Data(blob), how can I make my query be
select Id, Status from TableName
instead of
select Id, Status, Data from TableName
From the suggestion below, my method is
public IEnumerable<T> GetBy(Expression<Func<T, bool>> exp, Expression<Func<T, T>> columns)
{
return Table.Where<T>(exp).Select<T, T>(columns);
}
And I'm calling it like so
mgr.GetBy(f => f.Id < 10000, n => new {n.Id, n.Status});
However, I'm getting a compile error:
Cannot implicitly convert type 'AnonymousType#1' to 'Entities.BatchRequest'