Shawn Wildermuth aka ADO guy
has a great book on ADO.Net called Pragmatic ADO.Net
. It's a definite must read for anyone involved in ADO.Net programming, i have been working with ADO.Net for over a year and yet the book taught me so much, a definite buy. Also i recently used the ADO.Net powertoys
to generate my typed datasets. That works great too. Basically the problem is that the methods that the normal typed dataset generator generates are not virtual so if you override the typed dataset then it only hides the base class methods. The ADO power tools has a Typed Dataset generator that defines the methods as virtual and offers other customization abilities. Other than that it has a Utility library of DB functions and a stored procedure generator.