Open Microsoft.practices.EnterpriseLibrary database with just a connection string

Question

I am using the Microsoft.Practices.EnterpriseLibrary Database tools and I'm having trouble creating a new database using just the connection string information.

Ideally I would like to do the following:

Database dbEngine = DatabaseFactory.CreateDatabase(
    "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;");

Is it possible to create a database using just the connection string?

If so, how can it be achieved?

Answer 1

Er... That's because CreateDatabase expects the name of a connection string (as specified in your app's config file), not the connection string itself.

Answer 2

I discovered that you can use the following command ...

SqlDatabase dbEngine = new SqlDatabase(connectionString);

not quite as versatile as the Database object but it works for my purpose.

Thanks everyone!

Answer 3

I am building a connection string on the fly dynamically with the following where ConnectionString is in my .config

     Database configdb = DatabaseFactory.CreateDatabase("ConnectionString");

                DbConnectionStringBuilder sb = configdb.DbProviderFactory.CreateConnectionStringBuilder();

                // Set the Connection String fields.

                sb["Data Source"] = targetServer; 
                sb["Initial Catalog"] = targetDb; 
                sb["User ID"] = username;
                sb["Password"] = password;
                sb["Connect Timeout"] = dbTimeout;

                GenericDatabase newDb = new GenericDatabase(sb.ToString(), configdb.DbProviderFactory);
Database db = newDb;

Answer 4

You can also do

Database mydb = new EnterpriseLibrary.Data.Sql.SqlDatabase("connection string here");

and you'll retain the versatility of the Database object, but create it with a connection string.