Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

ADO.NET Data Explorer

I love Visual Studio. The more I use each successive version, the more I dread having to write code in previous versions. I love the fact that I can create a strongly typed DataSet and add one to a Windows Form along with TableAdapters, bound controls, and a navigation control that supports submitting changes back to the database—all without being forced to write a single line of code. Visual Studio generates code that you’d probably prefer not to write by hand.

With that said, at times you might still want more control over the code in your application. The more code you write, the more you find yourself following certain patterns—the way you create Connection objects, the way you retrieve data from DataReader objects, and ...