Rocks Thoughts

LINQ TO SQL Tutorials, Articles and Opinions

Andy suggested that I put together a list of LINQ TO SQL articles and opinions in one place for everyone to find. I'm positive I haven't found them all but here is a list that I compiled. If you have any other articles, let me know and I'll add them to the list.

Tools for LINQ TO SQL

• LINQPAD
• LINQ Kit

Jim Wooley's ThinqLinq (A whole blog dedicated to LINQ - Sweet!)

•  http://www.thinqlinq.com/
• www.LinqInAction.net (This is the support site for LINQ IN ACTION)

• 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
• Part 8: Executing Custom SQL Expressions
• Part 9: LINQ to SQL (Part 9 - Using a Custom LINQ Expression with the control)

• Part 1, Introduction
• Part 2, Layered Architectures
• Part 3, DAOs and Repositories
• Part 4, Dynamic Queries
• Part 5, Architecture

• Lots o posts on LINQ TO SQL

• MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 1
• MHO: LINQ to SQL and Entity Framework: Panacea or evil incarnate? Part 2

• LINQ TO SQL Caching Gotcha
• LINQ TO SQL Sync / Refresh Tables in Designer?
• LINQ TO SQL Dynamic Queries
• LINQ TO SQL Dynamic Queries #2 (Or statements)
• Uploading an image or file using LINQ TO SQL (System.Linq.Data.Binary)
• LINQ TO SQL V 1.0 Hickups
• LINQ TO SQL CanBeNull being ignored

• LINQ Again!
• What's wrong with LINQ TO SQL

Hilton Giesenow

• Why use LINQ TO SQL - Performance Considerations
• Why use LINQ TO SQL - Security
• Hilton has a very good list of links as well

Mitsu's Blog

• How to implement a many to many relationship with LINQ TO SQL

Beth Massi's Blog (Beth has a lot of good content)

• One-To-Many (Master-Detail) Forms with LINQ to SQL
• Support for SQL Server 2008 types coming to LINQ to SQL
• Creating lookup lists with LINQ to SQL

MSDN Code Gallery for LINQ TO SQL (Thanks to Beth Massi for the url)

• Code Gallery

Jon Krugers Blog

• LINQ to SQL in disconnected/N-Tier scenerios : Saving an Object

Oakleaf Systems (Thanks to Roger Jennings)

• Lots of LINQ Links

Rob Conery

• Linq Gymnastics: Creating a Predictive Query with LINQ
• Creating IN queries with LINQ TO SQL

Pampa Notes on Software Trends

• Does LINQ TO SQL replace the whole DAL?
• Unplugged LINQ TO SQL Generator
• First thoughts on designing linq enable application framework

Jeffrey Zhao

• LINQ TO SQL Extension: Batch Deletion with Lambda Expression

posted @ Saturday, February 23, 2008 8:42 AM