public OutputParameter(sql_parameter_name name)
{
param = new SqlParameter(name, type)
{
Direction = ParameterDirection.InputOutput, Value = null
};
}
void Add <K>(sql_parameter_name name, K?value)
where K : struct
{
if (value != null)
{
Add(name, value.Value);
}
}
protected void Add <K>(sql_parameter_name name, K value)
{
SqlParameter p = new SqlParameter(name, value);
SqlDbType type;
if (!clr_to_sql_types.TryGetValue(typeof(K), out type))
{
type = SqlDbType.Variant;
}
p.SqlDbType = type;
parameters.Add(name, p);
}
protected void Add(sql_parameter_name name, non_empty_string value) => Add(name, value.ToString());
protected void Add(sql_parameter_name name, string value) => parameters.Add(name, new SqlParameter(name, SqlDbType.NVarChar)
{
Value = value
});
protected void Add(sql_parameter_name name, base64 value) => Add(name, value.ToString());
