public IDbTransaction BeginTransaction() #endif { if (state != ConnectionState.Open) { throw new InvalidOperationException("Invalid operation: The connection is closed"); } SqliteTransaction t = new SqliteTransaction(); #if NET_2_0 t.SetConnection(this); #else t.Connection = this; #endif SqliteCommand cmd = (SqliteCommand)this.CreateCommand(); cmd.CommandText = "BEGIN"; cmd.ExecuteNonQuery(); return(t); }
public IDbTransaction BeginTransaction () { if (state != ConnectionState.Open) throw new InvalidOperationException("Invalid operation: The connection is close"); SqliteTransaction t = new SqliteTransaction(); t.Connection = this; SqliteCommand cmd = this.CreateCommand(); cmd.CommandText = "BEGIN"; cmd.ExecuteNonQuery(); return t; }
public IDbTransaction BeginTransaction() #endif { if (state != ConnectionState.Open) throw new InvalidOperationException("Invalid operation: The connection is closed"); SqliteTransaction t = new SqliteTransaction(); #if NET_2_0 t.SetConnection (this); #else t.Connection = this; #endif SqliteCommand cmd = (SqliteCommand)this.CreateCommand(); cmd.CommandText = "BEGIN"; cmd.ExecuteNonQuery(); return t; }
private void ExecuteNonQuery(string sql, SqliteConnection conn, SqliteTransaction tran) { string[] sqlArray = SplitSqlString(sql); foreach (string sqlString in sqlArray) { SqliteCommand cmd = new SqliteCommand(sqlString, conn, tran); cmd.CommandTimeout = 1200; cmd.ExecuteNonQuery(); } }