/// <summary> /// Executes a non-query with a single parameter. /// </summary> /// <param name="command">Non-query command.</param> /// <param name="parameters">Parameters to be added.</param> /// <param name="types">Database data type of parameters.</param> /// <param name="values">Values for parameters.</param> public static void ExecuteWithParameter(MySqlCommand command, MysqlParameter parameter) { AddParameter(command, parameter); command.ExecuteNonQuery(); }
/// <summary> /// Adds a single parameters to a command. /// </summary> /// <param name="command">Command to be parametrised.</param> /// <param name="parameters">Parameters to be added.</param> /// <param name="types">Database data type of parameters</param> /// <param name="values">Values to be stored in parametrised command.</param> public static void AddParameter(MySqlCommand command, MysqlParameter parameters) { var tempParameter = command.Parameters.Add(parameters.name, parameters.type); tempParameter.Value = parameters.value; }