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