public bool Execute(System.Data.IDbConnection connection, System.Data.IDbTransaction transaction = null)
{
if (_processor == null)
{
_processor = new ScriptProcessing.SqlServerScriptProcessor();
}
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
IList <string> bits = _processor.ProcessScript(_script, Parameters);
foreach (string bit in bits)
{
System.Data.IDbCommand cmd = connection.CreateCommand();
if (transaction != null)
{
cmd.Transaction = transaction;
}
cmd.CommandText = bit;
cmd.ExecuteNonQuery();
}
return(true);
}
public bool Execute(System.Data.IDbConnection connection, System.Data.IDbTransaction transaction = null)
{
if (_processor == null) _processor = new ScriptProcessing.SqlServerScriptProcessor();
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
IList<string> bits = _processor.ProcessScript(_script, Parameters);
foreach (string bit in bits)
{
System.Data.IDbCommand cmd = connection.CreateCommand();
if(transaction!=null) cmd.Transaction = transaction;
cmd.CommandText = bit;
cmd.ExecuteNonQuery();
}
return true;
}
public ScriptRunner(string script = null, ScriptProcessing.IScriptProcessor processor = null)
{
Parameters = new System.Collections.Generic.Dictionary <string, string>();
_script = script;
this._processor = processor;
}
public ScriptRunner(string script = null, ScriptProcessing.IScriptProcessor processor = null)
{
Parameters = new System.Collections.Generic.Dictionary<string, string>();
_script = script;
this._processor = processor;
}
