MySql.Data.MySqlClient.MySqlParameterCollection.Add C# (CSharp) Method

Add() public method

Adds the specified MySqlParameter object to the MySqlParameterCollection.
public Add ( MySqlParameter value ) : MySqlParameter
value MySqlParameter The to add to the collection.
return MySqlParameter
    public MySqlParameter Add(MySqlParameter value)
    {
      return InternalAdd(value, -1);
    }

Same methods

MySqlParameterCollection::Add ( string parameterName, MySqlDbType dbType ) : MySqlParameter
MySqlParameterCollection::Add ( string parameterName, MySqlDbType dbType, int size ) : MySqlParameter
MySqlParameterCollection::Add ( string parameterName, MySqlDbType dbType, int size, string sourceColumn ) : MySqlParameter
MySqlParameterCollection::Add ( string parameterName, object value ) : MySqlParameter
MySqlParameterCollection::Add ( object value ) : int

Usage Example

Example #1
0
        public static string KeyToWhere(IDataStoreKey key, MySqlParameterCollection parameters)
        {
            string where = null;

              if (key is CounterDataStoreKey)
              {
            where = "T1.COUNTER = ?CTR";
            var par = new MySqlParameter();
            par.ParameterName = "?CTR";
            par.Value = ((CounterDataStoreKey)key).Counter;

            parameters.Add(par);
              }
              else
              if (key is GDID)
              {
            where = "T1.GDID = ?CTR";
            var par = new MySqlParameter();
            par.ParameterName = "?CTR";
            par.Value = key;

            parameters.Add(par);
              }
              else
            if (key is NameValueDataStoreKey)
            {
              var dict = key as NameValueDataStoreKey;
              var s = new StringBuilder();
              var idx = 0;

              foreach (var e in dict)
              {
                s.AppendFormat(" (T1.`{0}` = ?P{1}) AND", e.Key, idx);
                var par = new MySqlParameter();
                par.ParameterName = "?P" + idx.ToString();
                par.Value = e.Value;
                parameters.Add(par);

                idx++;
              }

              if (s.Length > 0) s.Remove(s.Length - 3, 3);//cut "AND"

              where = s.ToString();
            }
            else
              throw new MySQLDataAccessException(StringConsts.INVALID_KEY_TYPE_ERROR);

              return where;
        }
All Usage Examples Of MySql.Data.MySqlClient.MySqlParameterCollection::Add