Linq to Sql - Sql Generation

Question

Recently a colleague of mine stated that the SQL generated from LINQ vary depending on the table statistics.

I know that the SQL generated gets optimized depending on the SQL Server versions (Sql 2000 vs SQl 2008) leveraging new operators like ROW_NUMBER if supported.

Could anyone confirm this or how to validate this?

Mitch Wheat · Accepted Answer · 2011-02-10 03:46:19Z

3

"Recently a colleague of mine stated that the SQL generated from LINQ vary depending on the table statistics." - That's not true. It would require round trips to the DB to create the SQL.

Query plans are constructed by SQL Server using statistics, after the query is submitted to SQL Server.

SQL emitted by LINQ is based on rules.

answered Feb 10, 2011 at 3:46

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Donald Byrd · Accepted Answer · 2011-02-10 03:44:42Z

0

I doubt that. The query plan generated by SQL Server would vary, but I really doubt the SQL syntax is.

answered Feb 10, 2011 at 3:44

Donald Byrd

7,8284 gold badges35 silver badges50 bronze badges

Comments

rboarman · Accepted Answer · 2011-02-10 03:50:35Z

0

Actually, Linq to SQL will call a stored proc in which you can use ROW_NUMBER but only for certain operations like Skip and Take.

Here's a post from the master:

http://weblogs.asp.net/scottgu/archive/2006/01/07/434787.aspx

and

http://weblogs.asp.net/scottgu/archive/2006/01/01/434314.aspx

answered Feb 10, 2011 at 3:50

rboarman

8,2239 gold badges61 silver badges92 bronze badges

Collectives™ on Stack Overflow

Linq to Sql - Sql Generation

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related