public void Deploy(string connectionString, DbDeploymentMode deploymentMode) { SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder(connectionString); string originalInitialCatalog = connectionStringBuilder.InitialCatalog; connectionStringBuilder.InitialCatalog = "master"; DbUtil.Execute(Platform, connectionStringBuilder.ToString(), delegate(IDbConnection connection) { if(deploymentMode == DbDeploymentMode.Redeploy) { using(IDbCommand dbCommand = connection.CreateCommand()) { dbCommand.CommandText = string.Format("if exists(select * from sys.databases where name = '{0}') drop database [{0}]", originalInitialCatalog); dbCommand.ExecuteNonQuery(); } // using } // if using(IDbCommand dbCommand = connection.CreateCommand()) { dbCommand.CommandText = string.Format("if not exists(select * from sys.databases where name = '{0}') create database [{0}]", originalInitialCatalog); dbCommand.ExecuteNonQuery(); } // using }); }
public void Deploy(string connectionString, DbDeploymentMode deploymentMode) { var connectionStringBuilder = new System.Data.SQLite.SQLiteConnectionStringBuilder(connectionString); if(deploymentMode == DbDeploymentMode.Redeploy && File.Exists(connectionStringBuilder.DataSource)) File.Delete(connectionStringBuilder.DataSource); SQLiteConnection.CreateFile(connectionStringBuilder.DataSource); }
public void Deploy(string connectionString, DbDeploymentMode deploymentMode) { /*Catalog catalog = (Catalog)new CatalogClass(); try { string adoxConnectionString = connectionString + "Jet OLEDB;Engine Type=5"; Console.WriteLine(adoxConnectionString); catalog.Create(adoxConnectionString); } // try finally { Marshal.ReleaseComObject(catalog); }*/ }
public void Deploy(string connectionString, DbDeploymentMode deploymentMode) { // // If we're redeploying, delete original database. This is a hack to extract // datasource from SQL CE connection string usinq SqlConnectionStringBuilder, // which is used for full-blown SQL Server. if(deploymentMode == DbDeploymentMode.Redeploy) { var builder = new SqlConnectionStringBuilder(connectionString); var databasePath = builder.DataSource; File.Delete(databasePath); } // if using(var sqlCeEngine = new SqlCeEngine(connectionString)) sqlCeEngine.CreateDatabase(); }
public void Deploy(string connectionString, DbDeploymentMode deploymentMode) { FbConnection.CreateDatabase(connectionString); }