c# - Can I avoid a nested SQL query for a simple Linq to Entities projection? -

c# - Can I avoid a nested SQL query for a simple Linq to Entities projection? -

given simple linq ef (ef5) statement:

mydbset.select(x => x.column1)

the next sql produced:

select [c].[column1] [column1] (select [mydbset].[column1] [column1], [mydbset].[column2] [column2], ... [mydbset].[columnn] [columnn] [dbo].[mydbset] [mydbset]) [c]

that nested query returns columns unnecessary. innocuous, think i'm having issues how scales considerably more complex queries. so: there way ef generate sql without nested query? linq statements generated look trees, i'd avoid having utilize pass-through sql.

as chris hermut mentioned, lazy load query:

iqueryable<columntype> query = context.mydbset.select(x => x.column1); ienumerable<columntype> result = query.tolist();

c# sql-server linq entity-framework