LINQ

LINQ TO SQL Tutorials, Articles and Opinions

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)

Scott Guthries LINQ TO SQL Tutorial

• 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)

Ian Cooper's Architecting LINQ TO SQL Applications

• Part 1, Introduction

• Part 2, Layered Architectures

• Part 3, DAOs and Repositories

• Part 4, Dynamic Queries

• Part 5, Architecture

David Hayden's Plethora of LINQ TO SQL Posts (Too many to list here)

• Lots o posts on LINQ TO SQL

Bob Beauchemin

• 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

Chris Rock (That would be me)

• 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

Andy Warren

• 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

Book

• • LINQ in Action

• Pro LINQ: Language Integrated Query in C# 2008

• Linq Pocket Reference", by Joseph Albahari, O'Reilly, 2008, (ISBN-13: 978-0-59-651924-7).

101 LINQ Samples from MSDN Visual C# Developer Center

• • Converting SQL to LINQ Part 1 to 10 from The Visual Basic Team by Bill Horst

  • LINQ Cookbook Recipe 1 to 11 from The Visual Basic Team by Doug Rothaus

Hooked on LINQ