LINQ To SQL Tutorials:

• LINQPad - Dynamically Query SQL Server Databases in LINQ
• LINQ To SQL Debugger Visualizer Revisited - Same Concerns Better UI
• DataContext.Log - Logging LINQ To SQL Output to Console or Debugger Output Window
• LINQ To SQL Debugger Visualizer in Visual Studio 2008 Has Limited Value - LINQ To SQL Tutorials
• LINQ To SQL As Replacement To Data Access Guidance Package
• LINQ Data Access Layer - Creating Insert Update Delete Stored Procedures
• Creating Data Access Layer Using LINQ To SQL - Stored Procedures Support
• LinqDataSource - High Performance Queries Using DataLoadOptions - Avoiding Database Roundtrips
• LINQ to SQL - Performance Tradeoffs: Less Database Roundtrips but Duplicated Data in Each Row??
• LINQ To SQL - Lazy Loading Properties and Specifying PreFetch When Needed - Sweet Query and Performance Control
• LINQ To SQL Video - Getting From Expression Trees to SQL

via: http://www.linqpad.net/

LINQPad lets you interactively query SQL databases in a modern query language: LINQ.  Kiss goodbye to SQL Management Studio!

LINQPad supports everything in C# 3.0 and Framework 3.5:

• LINQ to SQL
• LINQ to Objects
• LINQ to XML

LINQPad is also a terrific tool for learning LINQ: it comes preloaded with 200 examples from the recently released C# 3.0 in a Nutshell.  There’s no better way to experience the coolness of LINQ and functional programming.

LINQPad is free and needs no installation: just download and run.  The executable is only 1MB and is self-updating.

LINQ is one of the greatest feature in C#3.0, LINQ to SQL is an O/RM (object relational mapping) implementation that included, we can do CRUD on the database using LINQ. LINQ to SQL also supports transactions, views, and stored procedures.

Now seemed the only issue for me is if LINQ for SQL performance is good enough.

There are already some talks on LINQ to SQL performance:

Database Performance, Correctness, Compostion, Compromise, and Linq too (http://blogs.msdn.com/ricom/archive/2007/08/31/database-performance-correctness-compostion-compromise-and-linq-too.aspx)

LINQ to SQL Compiled Queries(http://devauthority.com/blogs/jwooley/archive/2007/09/05/75645.aspx)

Compiled Queries in LINQ to SQL - performance considerations and entity caching (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1438097&SiteID=1)

Improving Performance With LINQ(http://www.singingeels.com/Articles/Improving_Performance_With_LINQ.aspx)

LINQ To SQL and Visual Studio 2008 Performance Update(http://www.davidhayden.com/blog/dave/archive/2007/09/28/LINQToSQLVisualStudio2008PerformanceUpdate.aspx)