/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters) { conn.CheckNull(nameof(conn)); conn.ExecuteNonQuery(cmdText, parameters, CommandType.Text, null); }
private void saveLoadout(string[] loadout_data) { Func<string, string> qP = quoteParam; var player_uid = qP(loadout_data[0]); var loadout = qP(loadout_data[1]); log(tS(loadout_data)); var cmd = new MySqlConnection(conStr).CreateCommand(); cmd.CommandText = String.Format(@"INSERT INTO player(uid,loadout) VALUES ({0},{1}) ON DUPLICATE KEY UPDATE loadout={1}", player_uid, loadout); log(cmd.CommandText); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); conn.ExecuteNonQuery(cmdText, null, commandType, transaction); }