private bool ExecuteUpdateScript(Guid dbSectionId, DbScript updateScript)
{
var commands = GetCommands(updateScript.Sql);
var updateVersionCommand = GetUpdateVersionCommand(dbSectionId, updateScript.Version);
commands.Add(updateVersionCommand);
return ExecuteScriptInTransaction(_connectionString, commands);
}
public bool TryCreateSection(Guid dbSectionId, DbScript createScript)
{
var commands = GetCommands(createScript.Sql);
var setVersionCommand = GetSetVersionCommand(dbSectionId, createScript.Version);
commands.Add(setVersionCommand);
return ExecuteScriptInTransaction(_connectionString, commands);
}
public bool TryUpdateSection(Guid dbSectionId, DbScript[] updateScripts)
{
bool? successUpdate = null;
foreach (var updateScript in updateScripts)
{
successUpdate = ExecuteUpdateScript(dbSectionId, updateScript);
if (!successUpdate.Value) break;
}
return (successUpdate ?? true);
}
public bool TryCreateDbSchema(DbScript createScript)
{
var commands = GetCommands(createScript.Sql);
var insertVersionCommand = string.Format(InsertDbVersionCommandFormat, _dbName, createScript.Version);
commands.Add(insertVersionCommand);
return ExecuteScriptInTransaction(_connectionString, commands);
}
public bool TryCreateDatabase(DbScript createScript)
{
var dbCreated = CreateEmptyDataBase();
if (dbCreated)
{
if (WaitForDatabaseOpen(WaitForDatabaseOpenTimeOut))
{
return TryCreateDbSchema(createScript);
}
return false;
}
return false;
}
private bool ExecuteUpdateScript(DbScript updateScript, string dbName, string connectionString)
{
var commands = GetCommands(updateScript.Sql);
var updateVersionCommand = GetUpdateVersionCommand(updateScript.Version, dbName);
commands.Add(updateVersionCommand);
return ExecuteScriptInTransaction(connectionString, commands);
}
public bool TryUpdate(DbScript[] updateScripts)
{
bool? successUpdate = null;
foreach (var updateScript in updateScripts)
{
successUpdate = ExecuteUpdateScript(updateScript, _dbName, _connectionString);
if (!successUpdate.Value) break;
}
return (successUpdate ?? true);
}