in

SQL Server Blogs

Voices from the UK SQL Server Community

Atul Thakor

March 2011 - Posts

  • LINQ for SQL Developers and DBA’s

    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

    Posted Mar 08 2011, 11:51 PM by AtulThakor with no comments
    Filed under:
Powered by Community Server (Commercial Edition), by Telligent Systems