In this episode we will continue our series on how to create a build script using the NAnt build tool.

In this episode we will be building off our existing script to add the ability to run sql scripts using the SqlCmd tool.

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 query an XML document by using the XLinq libraries. XLinq is the Linq implementation on top of an XML document.

We will learn how to us the inline query syntax as well as using SQL style syntax. By the end of the episode you should be able to retrieve...

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:

LINQ is an internal DSL provided by C# for accessing streams of data. We can leverage the same feature set added to the language to make LINQ to author our own internal DSLs. In this session Ian introduces you to the ideas behind Internal DSLs and shows how C# 3.5 helps you to write them.

...

An SQL injection demo that should make you check twice when setting SQL security

DataMgr is a Data Access Layer component set.

It simplifies CRUD interactions with the database (speeding up development time) and has a common API for any supported database (and makes adding a new database easy).

DataMgr is not an ORM, but you could build an ORM on top of ...

A SQL injection screencast. Provides a detailed step by step view of how hacker can exploit SQL Injection vulnerability

A quick preview at Adobe Developer Week presentation where we build an MVC-based ColdFusion+MySQL weblog in about nine minutes - without writing any SQ...