Learn SQL to LINQ (Visual Representation) - CodeProject

Introduction to the article

A lot of developers moving towards the new LINQ to SQL find it difficult to write SQL queries in C# to query data using LINQ. LINQ is a query language which is integrated in C# to query data from ObjectCollects, SQL, XML etc. Before you start reading this article, it is good to have look at the features supported by LINQ:

• Implicitly typed local variables
• Extension Methods
• Anonymous types
• Lambda Expressions
• Object and collection initialization

Here in this article, I am going to discuss the basic SQL queries and the LINQ queries similar to SQL queries, with visual representations of the LINQ queries. Before I start discussing, here is the structure of the table I am using for this article:

Learn SQL to LINQ (Visual Representation) - CodeProject

Related articles

• Programming Microsoft LINQ in Microsoft .NET Framework 4 (Microsoft Press) (i-programmer.info)
• Language Integrated Query By Nyros Developer (slideshare.net)
• Using LINQ to query Sharepoint lists (baptiste-wicht.com)