public virtual void InsertList <T>(string cmdInsert
, System.Collections.Generic.IEnumerable <T> listToInsert
, callbackAddDataClosure_t <T> addDataCallback)
{
using (System.Data.Common.DbCommand cmd = this.CreateCommand(cmdInsert))
{
InsertList <T>(cmd, listToInsert, addDataCallback);
}
} // End Sub InsertList
} // End Sub InsertList
public virtual void InsertList <T>(System.Data.IDbCommand cmdInsert
, System.Collections.Generic.IEnumerable <T> listToInsert
, callbackAddDataClosure_t <T> addDataCallback)
{
using (System.Data.Common.DbConnection conn = this.Connection)
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
cmdInsert.Connection = conn;
using (System.Data.Common.DbTransaction transact = conn.BeginTransaction())
{
cmdInsert.Transaction = transact;
try
{
foreach (T thisItem in listToInsert)
{
addDataCallback(thisItem);
if (cmdInsert.ExecuteNonQuery() != 1)
{
//'handled as needed,
//' but this snippet will throw an exception to force a rollback
throw new System.InvalidProgramException();
} // End if (cmdInsert.ExecuteNonQuery() != 1)
} // Next thisObject
transact.Commit();
} // End Try
catch (System.Exception)
{
transact.Rollback();
throw;
} // End Catch
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
} // End Finally
} // End Using transact
} // End Using conn
} // End Sub InsertList