101 LinQ Samples

https://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b

SQL 2 LINQ

Many programmers are familiar with SQL and will require help in the transition to LINQ. Sometimes complicated queries need to be written and Linqer can help by converting SQL scripts to LINQ.

Downloads 

http://www.sqltolinq.com/downloads

http://www.linqpad.net/Download.aspx

https://www.nuget.org/packages/CentralLinqMvc/

Guidelines

https://weblogs.asp.net/hajan/linqer-a-nice-tool-for-sql-to-linq-transition

http://www.c-sharpcorner.com/UploadFile/97fc7a/generate-linq-sql-queries-with-linqpad/

https://blogs.msdn.microsoft.com/vbteam/2007/11/19/converting-sql-to-linq-part-1-the-basics-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2007/11/28/converting-sql-to-linq-part-2-from-and-select-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2007/12/04/converting-sql-to-linq-part-3-distinct-where-order-by-and-operators-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2007/12/12/converting-sql-to-linq-part-4-functions-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2007/12/18/converting-sql-to-linq-part-5-group-by-and-having-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2007/12/31/converting-sql-to-linq-part-6-joins-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2008/01/08/converting-sql-to-linq-part-7-union-top-subqueries-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2008/01/31/converting-sql-to-linq-part-8-leftright-outer-join-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2008/02/12/converting-sql-to-linq-part-9-full-outer-join-bill-horst/

https://blogs.msdn.microsoft.com/vbteam/2008/05/07/converting-sql-to-linq-part-10-like-bill-horst/

1: http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx

2: http://weblogs.asp.net/scottgu/archive/2007/05/29/linq-to-sql-part-2-defining-our-data-model-classes.aspx

3: http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx

4: http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx

5: http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx

6: http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

7: http://weblogs.asp.net/scottgu/archive/2007/08/23/linq-to-sql-part-7-updating-our-database-using-stored-procedures.aspx

8: http://weblogs.asp.net/scottgu/archive/2007/08/27/linq-to-sql-part-8-executing-custom-sql-expressions.aspx

• Part 1: Introduction to LINQ to SQL
• Part 2: Defining our Data Model Classes
• Part 3: Querying our Database
• Part 4: Updating our Database
• Part 5: Binding UI using the ASP:LinqDataSource Control
• Part 6: Retrieving Data Using Stored Procedures
• Part 7: Updating our Database using Stored Procedures

http://www.linqpad.net/

http://www.thinqlinq.com/default/LINQ-Tools.aspx

http://www.hanselman.com/blog/ScottHanselmans2014UltimateDeveloperAndPowerUsersToolListForWindows.aspx