Improve query generated from entity framework

Question

I have a query linq like this:

var query = from c in Context.Customers select c;
var result = query.ToList();

Linq query generate this tsql code:

exec sp_executesql N'SELECT 
[Project1].[Id] AS [Id], 
[Project1].[Name] AS [Name], 
[Project1].[Email] AS [Email]
FROM ( SELECT 
    [Extent1].[Id] AS [Id],
    [Extent1].[Name] AS [Name], 
    [Extent1].[Email] AS [Email]
    FROM [dbo].[Customers] AS [Extent1] ) AS [Project1]

Is there a way for not generate subquery?

Answer 1

Do you have any evidence that that query is causing performance problems? I imagine the query-optimizer would easily recognize that.

If you're certain after profiling that the query is a performance problem (doubtful) - and only then - you could simply turn the query into a stored procedure, and call that instead.