Example #1
0
        public override void AddInputParameter(string parameterName, object parameterValue, SqlCollectionType collectionType = SqlCollectionType.None, DbType type = DbType.AnsiString)
        {
            SqlParameter parameter = new SqlParameter();

            parameter.ParameterName = FormatForSql(parameterName);
            parameter.Value         = parameterValue;
            if (collectionType != SqlCollectionType.None)
            {
                parameter.TypeName  = collectionType.ToString();
                parameter.SqlDbType = SqlDbType.Structured;
            }
            Cmd.Parameters.Add(parameter);
        }