Implementing an ADO.NET layer

Question

Are there any tutorials or how-to's that explain how to implement an ADO.NET layer?

That would include implementing a Connection class, etcetera.

I need to do this because I am querying an old proprietary system and I want to wrap the old APIs properly.

Answer 1

See "Building a Custom Data Provider for Use with the .NET Data Access Framework" at http://msdn.microsoft.com/en-us/magazine/cc301611.aspx

Also, Googling for "Custom ADO.NET Data Provider" should give you many possible answers.

Answer 2

I asked a question similar to this a while back. You may want to read through the answers there. The person who actually answered the question posted a link to a code project article that did a great job of explaining ado when working with MSAcess.

http://stackoverflow.com/questions/167746/where-can-i-find-an-open-source-c-project-that-uses-ado-net