CODEWITHSUNDEEP
c#linqentity-framework
ADIMO
ADIMO

Reputation: 1117

Improve query generated from entity framework

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?

Upvotes: 3

Views: 304

Answers (3)

jmoreno
jmoreno

Reputation: 13561

You use a tool like Linq because you don't want to write SQL, before abandoning that you should at least compare the query plan of your proposed SQL vs that generated by the tool. I don't have access to SQL Studio at the moment, but I would be a bit surprised if the query plans aren't identical...

EDIT: having had a chance to check out the query plans, they are in fact identical.

Upvotes: 2

BlueRaja - Danny Pflughoeft
BlueRaja - Danny Pflughoeft

Reputation: 85976

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.

Upvotes: 5

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364259

Short answer: No you cannot modify that query.

Long answer: If you want to reimplement Linq provider and query generator then perhaps there is a way but I doubt you want to do that. You can also implement custom EF provider wrapper which will take query passed from EF and reformat it but that will be hard as well - and slow. Are you going to write custom interpreter for SQL queries?

Upvotes: 1

Related Questions