LINQ for SQL Developers and DBA’s

Posted by AtulThakor on SQL Blogcasts See other posts from SQL Blogcasts or by AtulThakor
Published on Tue, 08 Mar 2011 23:51:00 GMT Indexed on 2011/03/09 8:13 UTC
Read the original article Hit count: 697

Filed under:

Firstly I’d just like to thank the guys who organise the SQL Server User Group (Martin/Tony/Chris) and for giving me the opportunity to speak at the recent event.

Sorry about the slides taking so long but here they are along with some extra information.

Firstly the demo’s were all done using LINQPad 4.0 which can be downloaded here:

http://www.linqpad.net/

There are 2 versions 3.5/4.0

With 3.5 you should be able to replicate the problem I showed where a query using a parameter which is X characters long would create a different execution plan to a query which uses a parameter which is Y characters long, otherwise I would just use 4.0

The sample database used is AdventureWorksLT2008 which can be downloaded from here:

http://msftdbprodsamples.codeplex.com/releases/view/37109

The scripts have been named so that you can select the appropriate way to run them i.e.: C# expression / C#statement, each script can be run individually be highlighting the query and clicking the play symbol or hitting F5.

Scripts and Slides:

http://sqlblogcasts.com/blogs/atulthakor/An%20Introduction%20to%20LINQ.zip

Please don't hesitate in sending any questions via email/twitter, I’ll try my best to answer your questions!

Thanks,

Atul

© SQL Blogcasts or respective owner

Related posts about LINQ