Database

using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Configuration; 

        private static Database CreateDatabaseFromConnectionString(string connString)
        {
            System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder(connString);


            DatabaseSettings settings = new DatabaseSettings();
            DatabaseTypeData type = new DatabaseTypeData("Sql Server", "Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null");
            settings.DatabaseTypes.Add(type);


            ConnectionStringData connectionString = new ConnectionStringData("DBConnection");


            connectionString.Parameters.Add(new ParameterData("server", builder.DataSource));
            connectionString.Parameters.Add(new ParameterData("database", builder.InitialCatalog));
            connectionString.Parameters.Add(new ParameterData("integrated security", "false"));
            connectionString.Parameters.Add(new ParameterData("user id", builder.UserID));
            connectionString.Parameters.Add(new ParameterData("password", builder.Password));

            settings.ConnectionStrings.Add(connectionString);

            Microsoft.Practices.EnterpriseLibrary.Data.Configuration.InstanceData instance = new Microsoft.Practices.EnterpriseLibrary.Data.Configuration.InstanceData("DBConnection", "Sql Server", "DBConnection");
            settings.Instances.Add(instance);

            Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationDictionary configurations = new Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationDictionary();
            configurations.Add("dataConfiguration", settings);

            Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationContext context = Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationManager.CreateContext(configurations);
            Database database = new DatabaseProviderFactory(context).CreateDatabase("DBConnection");
            return database;

        }