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);
}
