This articles was originally at wiki.asp.net but has now been given a new home on CodeProject. Editing rights for this article has been set at Bronze or above, so please go in and edit and update this article to keep it fresh and relevant.
There's a lot of great information on the net about accessing data in common data access patterns with ASP.NET 2.0.
From ScottGu's blog: Scott Mitchell recently finished writing his multi-part Working with Data in ASP.NET 2.0 tutorial series for the www.asp.net site. This tutorial series contains more than 75 data tutorials (and over 750 pages of content!). There are VB and C# versions available for all of the tutorials, and the articles can optionally be downloaded in PDF format. If you haven't read the tutorials yet, I'd highly recommend you check them out here.
Data Access Guides
- Data Access Application Block - patterns & practices group
The Data Access Application Block is a component of Enterprise Library which reduces the amount of custom code that you need to create, test, and maintain when building data access layers in .NET applications.
And more to come! Also, check out the SQL Server Videos at http://www.asp.net/learn/sql-videos/.