public int ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = MyDatabase.CreateCommand(); using (DbConnection conn = MyDatabase.CreateConnection()) { conn.ConnectionString = MyDatabase.GetConnection(); PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(val); } }
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = Provider.CreateCommand(); using (DbConnection conn = Provider.CreateConnection()) { conn.ConnectionString = connectionString; PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(val); } }
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = Provider.CreateCommand(); using (DbConnection conn = Provider.CreateConnection()) { try { conn.ConnectionString = connectionString; PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); //DbHelper.Conn = conn; return(val); } catch { throw; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } }
public static int ExecuteNonQuery(DatabaseEnum database, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = Provider.CreateCommand(); using (DbConnection conn = Provider.CreateConnection()) { conn.ConnectionString = ConnectionStringFactory.CreateConnectionString(database); return(ExecuteNonQuery(conn, cmdType, cmdText, commandParameters)); } }