What connection strings does the DbConnection class support?

[Christopher Stratmann]

I have an application that uses the Enterprise Application Block 3.1. Yes I know there is an Enterprise Application Block 4.0 and 5.0 that is now available. I cannot use these applications blocks because they require the 3.5 .NET Framework. Anyway, I know that the Enterprise Application Block 3.1 uses the DbConnection class and I am curious as to which databases this supports? I could not find this anywhere in MSDN. I think some database connections require custom classes that derive from the DbConnection class but I am after a list of databases that the Enterprise Application Block 3.1 will automatically handle without the implementation of custom classes?

Chris

[PIEBALDconsult]

Ummm... any class that derives from DbConnection? That's the point of interfaces and abstract classes. By using System.Data.IDbConnection and System.Data.IDbCommand my primary database class supports:

    public enum SupportedDatabase
    {
        Access
    ,
        Cache
    ,
        Excel
    ,
        FireBird
    ,
        Ingres
    ,
        MySql
    ,
        ODBC
    ,
        Oracle
    ,
        SqlServer
    ,
        OleSqlServer
    }

And I'll add more as I find them.

[Christopher Stratmann]

Thanks for the response. I am so glad someone else is using this besides me. I do have another question. With the databases that you mention, none of them require attaching addition dlls? For example, MySql doesn't require you to install some sort of .NET Component Installation and then attach those .NET DLLs to your solution so a user can then use MySql? Or is that automatically included within the enterprise library like SqlServer? What about Cache?

Chris

[PIEBALDconsult]

Unless it uses the OleDb provider, each database needs its own provider -- but the "install" is just a copy of the DLL:

Ca.Ingres.Client.dll
FirebirdSql.Data.FirebirdClient.dll
InterSystems.Data.CacheClient.dll
MySql.Data.dll
Oracle.DataAccess.dll