How to create a DbDataAdapter given a DbCommand or DbConnection?

Question

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?

Answer 1

As of .NET 4.5, when writing provider independent code, you can now use the DbProviderFactories.GetFactory overload that accepts a DbConnection to obtain the correct provider factory from which you can then create a data adapter.

Example:

DbDataAdapter CreateDataAdapter(DbConnection connection) {     return DbProviderFactories.GetFactory(connection).CreateDataAdapter(); } 

_{It seems someone on the ADO.NET team read Ian Boyd comment on his answer... :)}

Answer 2

DbProviderFactory.CreateDataAdapter *

Also you can get all registered DbProviders via DbProviderFactories class.

*I think this is a wrong place for this method.