MSDN has an article .NET Data Access Architecture Guide that discusses the ins and outs of data access in .NET.
John.