Пример #1
0
 /// <summary>
 /// Adds a parameter to the select command.
 /// </summary>
 public void AddParameter(string name, object value)
 {
     _parameters.SetParameter(new ParameterDefinition()
     {
         Name   = name,
         Value  = value,
         DbType = DbTypeUtil.GetDbType(value)
     });
 }
Пример #2
0
        /// <summary>
        /// Adds parameters to the select command.
        /// </summary>
        public void AddParameter(IDictionary <string, object> parameters)
        {
            _parameters.Clear();

            if (parameters != null)
            {
                foreach (var kvp in parameters)
                {
                    _parameters.SetParameter(new ParameterDefinition()
                    {
                        Name   = kvp.Key,
                        Value  = kvp.Value,
                        DbType = DbTypeUtil.GetDbType(kvp.Value)
                    });
                }
            }
        }