public void Execute(SqlConnection connection, IScriptExecuteCallback callback)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
if (callback == null)
{
throw new ArgumentNullException("callback");
}
int index = 0;
ScriptStep stepToRun;
callback.ExecutionStarting(this);
while (index < Count)
{
stepToRun = this[index];
if (!callback.Progress(stepToRun, index + 1, Count))
{
break;
}
stepToRun.Execute(connection, callback);
index++;
}
}
public void Execute(SqlConnection connection, IScriptExecuteCallback callback)
{
if (runState != ScriptRunState.None)
{
throw new InvalidOperationException("Already Run");
}
SqlCommand command = connection.CreateCommand();
command.CommandText = commandText;
command.CommandType = CommandType.Text;
command.CommandTimeout = 0;
runState = ScriptRunState.Running;
try
{
ExecuteCommand(command);
runState = ScriptRunState.Succeeded;
}
catch (SqlException ex)
{
exception = ex;
callback.Error(this, ex);
runState = ScriptRunState.Failed;
}
}
public WorkerThreadArguments(bool scriptOnly, IScriptExecuteCallback callback, string server, string userId, string password, string database, bool dropAllConstraints, string collation, FullTextLanguage language, bool setSingleUser)
{
this.scriptOnly = scriptOnly;
this.callback = callback;
this.server = server;
this.userId = userId;
this.password = password;
this.database = database;
this.dropAllConstraints = dropAllConstraints;
this.collation = collation;
this.language = language;
this.setSingleUser = setSingleUser;
}
public void Execute(SqlConnection connection, IScriptExecuteCallback callback)
{
if (connection == null) throw new ArgumentNullException("connection");
if (callback== null) throw new ArgumentNullException("callback");
int index=0;
ScriptStep stepToRun;
callback.ExecutionStarting(this);
while (index < Count)
{
stepToRun = this[index];
if (!callback.Progress(stepToRun, index + 1, Count)) break;
stepToRun.Execute(connection, callback);
index++;
}
}
public ScriptStepCollection GenerateScript(IScriptExecuteCallback callback, string server, string userId, string password, string database, bool dropAllConstraints, string collation, FullTextLanguage language, bool setSingleUser)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = Utils.ConnectionString(server, userId, password, 2, database);
try
{
connection.Open();
ScriptStepCollection script = LoadScript(new Version(connection.ServerVersion), database, dropAllConstraints, collation, language, setSingleUser);
//now get the last script entry and replace it with
//a special component that will return out
ScriptStepGenerateScript generator = new ScriptStepGenerateScript(script[script.Count - 1]);
script[script.Count - 1] = generator;
script.Execute(connection, callback);
return generator.Script;
}
finally
{
connection.Dispose();
}
}
public void Execute(SqlConnection connection, IScriptExecuteCallback callback)
{
if (runState != ScriptRunState.None)
throw new InvalidOperationException("Already Run");
SqlCommand command = connection.CreateCommand();
command.CommandText = commandText;
command.CommandType = CommandType.Text;
command.CommandTimeout = 0;
runState = ScriptRunState.Running;
try
{
ExecuteCommand(command);
runState = ScriptRunState.Succeeded;
}
catch(SqlException ex)
{
exception = ex;
callback.Error(this, ex);
runState = ScriptRunState.Failed;
}
}
public ScriptStepCollection GenerateScript(IScriptExecuteCallback callback, string server, string userId, string password, string database, bool dropAllConstraints, string collation, FullTextLanguage language, bool setSingleUser)
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = Utils.ConnectionString(server, userId, password);
try
{
connection.Open();
ScriptStepCollection script = LoadScript(new Version(connection.ServerVersion), database, dropAllConstraints, collation, language, setSingleUser);
//now get the last script entry and replace it with
//a special component that will return out
ScriptStepGenerateScript generator = new ScriptStepGenerateScript(script[script.Count - 1]);
script[script.Count - 1] = generator;
script.Execute(connection, callback);
return(generator.Script);
}
finally
{
connection.Dispose();
}
}
public WorkerThreadArguments(bool scriptOnly, IScriptExecuteCallback callback, string server, string userId, string password, string database, bool dropAllConstraints, string collation, FullTextLanguage language, bool setSingleUser)
{
this.scriptOnly = scriptOnly;
this.callback = callback;
this.server = server;
this.userId = userId;
this.password = password;
this.database = database;
this.dropAllConstraints = dropAllConstraints;
this.collation = collation;
this.language = language;
this.setSingleUser =setSingleUser;
}
