C# (CSharp) MySql.Data.MySqlClient MySqlParameterCollection.AddWithValue Examples

AddWithValue() public method

public AddWithValue ( string parameterName, object value ) : MySqlParameter
parameterName	string
value	object
return	MySqlParameter

Example #1

        /// <summary>
        /// Add range with value
        /// </summary>
        /// <param name="coll"></param>
        /// <param name="values"></param>
        public static void AddRangeWithValue(this MySqlParameterCollection coll, Dictionary <string, object> values)
        {
            coll.CheckNull(nameof(coll));
#if NETFRAMEWORK || NETSTANDARD2_0
            foreach (var pair in values)
            {
                var key   = pair.Key;
                var value = pair.Value;
#else
            foreach (var(key, value) in values)
            {
#endif
                coll.AddWithValue(key, value);
            }
        }
    }