Esempio n. 1
0
    void AddParamaters(SqlCommand command, IDictionary<string, object> parameters)
    {
        if (parameters != null)
        {
            foreach (KeyValuePair<string, object> parameter in parameters)
            {
                var objects = parameter.Value as IEnumerable<IDictionary<string, object>>;
                if (objects != null)
                {
                    command.AddObjectsParamaters(objects, parameter.Key);
                    continue;
                }

                var values = parameter.Value as IEnumerable<object>;
                if (values != null)
                {
                    command.AddArrayParameters(values, parameter.Key);
                    continue;
                }

                command.Parameters.AddWithValue(parameter.Key, parameter.Value ?? DBNull.Value);
            }
        }
    }