Cool Video Tutorial Introduction to Building a DAL using CodeSmith
I've heard lots of people rave about CodeSmith in the past.
Rob posted a cool article + 15 minute video showing off how to use it to build a strongly typed DAL layer project (including unit tests and help documentation) from a database in under 15 minutes.
You can watch the online video tutorial and read about it here.
Hope this helps,
Scott