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); }