n this episode, you will learn about the reasons why you might use an Object/Relational Mapper (ORM). You will also hear why NHibernate is a particularly good ORM, when it is appropriate to use NHibernate and when it is NOT appropriate to use NHibernate. Finally, you will hear why you might choose NH...

In this episode we will how to use Linq2Sqls Delayed Execution process to modify or append query syntax to our statements.

This can be used to remove duplication withen your query logic.

In this episode we will walk you though the the various ways to perform subselects with Linq2Sql.

We will also take a look at the SQL that is generated. We will be doing all of our coding in this episode in LinqPad

In this episode we will learn how to use the DataContext object that is part of Linq2Sql to build/rebuild our data base for testing.

We will walk though the creation of the database, the creation of data and learn how to wire this process up to our Tests.

In this episode we take a look at how to create various types of Linq2Sql statements. All the statements created in this episode are done using the really sweat LinqPad tool.

The types of statements that are reviewed here are:

In this episode we do an introductory of Linq2Sql. This is meant to be a beginners guide.

The items that are covered are: