/// <summary> /// Executes all of the statements that have been added. This is non-transactional. Execution will continue even if /// some statements fail. If you need atomicity you should ensure there is an ambient transaction. /// </summary> /// <returns>The total number of rows modified by all statements.</returns> public int Execute() { if (commands.Count == 0) { return(0); } using (var conn = db.GetOpenConnection()) using (var set = new PublicSqlCommandSet(conn)) { commands.ForEach(set.Append); return(set.ExecuteNonQuery()); } }
/// <summary> /// Returns a raw and open SqlConnection for manual use. /// </summary> public static SqlConnection GetOpenConnection() { return(db.GetOpenConnection()); }