c# - 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... :)}