public bool DatabaseExists()
{
using (TranslationStorage context = new TranslationStorage(getConnectionString()))
{
return context.DatabaseExists();
}
}
public bool DatabaseExists()
{
using (TranslationStorage context = new TranslationStorage(getConnectionString()))
{
return(context.DatabaseExists());
}
}
public void CreateDatabase()
{
using (TranslationStorage context = new TranslationStorage(getConnectionString()))
{
if (!context.DatabaseExists())
context.CreateDatabase();
}
using (var connection = new SqlConnection(GetConnectionSetting().ProviderConnectionString))
{
connection.Open();
var transaction = connection.BeginTransaction();
ExecuteSQLFile(transaction, "ResourceManager.Storage.Sql.StoredProcedures1.sql");
transaction.Commit();
}
}
public void CreateDatabase()
{
using (TranslationStorage context = new TranslationStorage(getConnectionString()))
{
if (!context.DatabaseExists())
{
context.CreateDatabase();
}
}
using (var connection = new SqlConnection(GetConnectionSetting().ProviderConnectionString))
{
connection.Open();
var transaction = connection.BeginTransaction();
// If DataBase exists, context.CreateDatabase() does not create tables.
ExecuteSQLFile(transaction, "ResourceManager.Storage.Sql.Tables1.sql");
ExecuteSQLFile(transaction, "ResourceManager.Storage.Sql.StoredProcedures1.sql");
transaction.Commit();
}
}
