LINQ to SQL cheat sheet

14 responses to LINQ to SQL cheat sheet

1. 

   Information is only used to show your comment. See my Privacy Policy.

2. 

   Arvind Singh25/12/2011

   Thanks, its really shortest way to implement query using LINQ.

3. 

   ARLibertarian06/03/2010

   Thanks a LOT. I’m doing a project and having to learn this stuff on the fly. This helps!

4. 

   SoCalSam18/11/2009

   Thanks Damien. I’m just starting a project that I wanted to use LINQ with, and this will help me a lot!

5. 

   sshow03/09/2009

   You just managed to teach me LINQ to SQL in one A4 page. Thanks alot!

6. 

   KALYAN27/08/2009

   Thanks for the cheat sheet. It is just the one I was looking for.

7. 

   Milan Negovan23/08/2009

   Damien,

   Thank you for the cheat sheet! I made a similar one for LINQ Standard Query Operators

   Hope this helps anyone, Milan

8. 

   William Wegerson14/08/2009

   Excellent and thanks! But one word though:

   landscape

   The boxes are cramped horizontally, maybe Landscape would allow for formatted code(?). Yes I know, everyone is a critic.

9. 

   Damien Guard14/08/2009

   Thanks Jim, I’ll update the sheet over the weekend with your changes.

   I have written a fair amount of code in VB.Net but I have to admit it was all prior to .NET 3.5.

10. 

    Jim Wooley14/08/2009

    On your VB sheet, you should consider using the VB’s additional support of query operators Distinct, Skip, Take, Aggregate, Sum, Count, Etc. For example the Paging and Ordering example could be re-written in VB as:

    Dim page3 = From c In db.Customers _
    Order By c.ContactName, c.City Descending _
    Distinct _
    Skip 10 _
    Take 5
    

    Also, notice the Select is optional in VB if you project the entire object. When using a simple projection, you don’t need the object initializer syntax either. If you just wanted to project the ContactName and City in the above example, you could do the following:

    Dim page3 = From c In db.Customers _
    Order By c.ContactName, c.City Descending _
    Select Name = c.ContactName, c.City _
    Distinct _
    Skip 10 _
    Take 5
    

    VB takes away a number of the method syntax hurdles that C# requires.

11. 

    Peter Bromberg13/08/2009

    Nice job, Damien! Your efforts are appreciated!

12. 

    KristoferA13/08/2009

    Very neat. I think you should put a link to the cheat sheet as a pegged topic in the msdn linq forums…

13. 

    Damien Guard13/08/2009

    @Harry I just enabled it for Google Reader, which one are you using?

    @Everyone Else: Thanks for the compliments guys. I’ve never been so retweeted.

14. 

    Joel13/08/2009

    Thanks for the sheet, I can see this being very helpful. It’s also quite nice that you split the C# & VB into separate pages.

15. 

    Jeff Handley13/08/2009

    This is excellent, thanks!