One of the talks I gave at the 2006 ASP.NET Connections conference in Las Vegas covered using TableAdapters and strongly-typed DataSets.  TableAdapters offer a great way to create a data-tier that work with stored procedures or inline SQL without writing much (if any) code.  They can be used to insert, update or delete data as well as select data into strongly-typed DataSets.

The talk was recorded and divided into 4 video segments that can be viewed on the Interface Technical Training blog site for those that are interested.