First part of the session covers the new language features (1-2 code samples each). This part covers “easy” new features: automatic properties, collection initializers, anonymous types. It also covers more advanced new features: extensions methods, lambdas. Then I explain why it’s important to understand these new ones before we get into LINQ. The second part covers LINQ, using several code samples for the following: LINQ to SQL, using either SQLMetal, LINQ to SQL files, creating contexts manually. Discussion topics include: generated SQL queries, what happens when you don’t specify JOIN in the query, etc. Even if you prefer to write stored procs, LINQ to SQL still provides some benefits for calling SPROCS. I also cover LINQ to DataSets, LINQ To XML, LINQ to Objects. I cover general LINQ query structure, and query functions such as CONTAINS, ANY, SKIP/TAKE, lambdas to create calculated expressions, etc. I also focus on IEnumerable, and how to pump LINQ results into custom lists. I also present an extension method, ToADOTable, to pump the results of a LINQ result into a datatable (since Microsoft dropped that in Beta 2). Bottom line, attendees will walk away with a large amount of small and reusable code samples.