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