Learning about LINQ [closed]

Question

LINQ to entities:

• Video walkthroughs
• Channel 9 video
• Entity framework FAQ
• Entity framework performance

I've got a lot more I tagged on Delicious.com.

Mention LINQ to Entities since ADO.NET Entity Framework will be an important .NET module.

A few LINQ Tips:

• Apply filters before a join to improve query performance
• Filter LINQ queries using object reference comparison
• Apply aggregates to empty collections in LINQ to SQL queries
• Delay loading a property in LINQ to SQL
• Use table-valued functions with eager loading turned on
• Put joins in the correct order in a LINQ to Objects query
• Compose a LINQ query inside a loop

http://www.aspnetpro.com/articles/2009/04/asp200904zh_f/asp200904zh_f.asp

Get the book Linq in Action it is an easy read for a coding book and really teaches you how to use Linq and the new features of .NET 3.5 some of the cool parts they put in for the language.