This is a complete example of creating Data Access Layer(DAL) using the traditional yet powerful "Object to Relational mapping model" or "Custom Entity Classes" that support Paging too..

SubSonic uses a few audit fields by default - you don’t need to write any code. However, the field names that are used are coded into the source code. You can modify the source code and generate a new assembly, but if you’re like me and would rather not edit the source code (so you don’t need to upd...

One of the new features is the addition of the SqlQuery class and it’s ability to perform aggregate queries (along with many other features). Shows example of SQL syntax versus SubSonic's SqlQuery aggregate coding to perform SQL queries.

A quick guide on using POCO with Linq To Sql and how to integrate it with your business layer without having to move everything into one namespace or inherit from any specific classes.

Mindscape released a new version of LightSpeed, their OR mapper. There are quite a lot of new features like more mapping options and a cool debugger visualizer that shows the queries being executed to get the data from the DB.

Build a complete Stored Procedure based Data Access Layer using Code Generation - Part 2

Build a complete Stored Procedure based Data Access Layer using Code Generation Part 1

A short overview showing how the Query object in LightSpeed lets you apply aspects such as Ordering and Paging easily and using a Fluent interface style when working with the domain modeling framework and O/R Mapper, LightSpeed.

This Screencast shows one how to generate business entities, stored procedures, and repository factory classes to create a data access layer for your web and winform applications.

The article includes a code sample at the end on how to design a very simple yet elegant data layer (or data tier) in ASP.NET. Make sure you check out the IBusinessEntity interface.

Rob walks us though setting up a call to SubSonic's command line utility to auto-generate the DAL during project build.