How to create a DbDataAdapter given a DbCommand or DbConnection?

Viewed 17598

I want to create a data access layer that works with any data provider.

I know it's possible to create a DbCommand using the factory method available on the connection.

objDbCon.CreateCommand();  

However, I could not find anything to create a DbDataAdapter. Is this is a bug in ADO.NET or what?

7 Answers
Related