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, ParameterCollection 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 (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } } }
public static int ExecuteNonQuery(MyDBType mydbtype, DbTransaction trans, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { string connstr = string.Empty; switch (mydbtype) { case MyDBType.Access: connstr = DBConfig.CmsAccessConString; break; case MyDBType.Sql: connstr = DBConfig.CmsSqlConString; break; case MyDBType.Oracle: connstr = DBConfig.CmsOracleConString; break; } if (null == trans) { DbConnection conn = Provider.CreateConnection(); trans = conn.BeginTransaction(); } return(ExecuteNonQuery(trans, cmdType, cmdText, commandParameters)); }
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)); } }
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); } }
internal void CreateConn() { Conn = Provider.CreateConnection(connstr); }