public IStoredProcBuilder ReturnValue <T>(out IOutParam <T> retParam, ParamExtra extra)
{
retParam = AddOutputParamInner(_retParamName, default(T), ParameterDirection.ReturnValue, extra.Size, extra.Precision, extra.Scale);
return(this);
}
public IStoredProcBuilder AddParam <T>(string name, T val, out IOutParam <T> outParam, ParamExtra extra)
{
outParam = AddOutputParamInner(name, val, ParameterDirection.InputOutput, extra.Size, extra.Precision, extra.Scale);
return(this);
}
private DbParameter AddParamInner <T>(string name, T val, ParameterDirection direction, ParamExtra extra)
{
if (name is null)
{
throw new ArgumentNullException(nameof(name));
}
DbParameter param = _cmd.CreateParameter();
param.ParameterName = name;
param.Value = (object)val ?? DBNull.Value;
param.Direction = direction;
param.DbType = DbTypeConverter.ConvertToDbType <T>();
if (extra != null)
{
param.Precision = extra.Precision;
param.Scale = extra.Scale;
param.Size = extra.Size;
}
_cmd.Parameters.Add(param);
return(param);
}
public IStoredProcBuilder AddParam <T>(string name, out IOutParam <T> outParam, ParamExtra extra)
{
outParam = AddOutputParamInner(name, default(T), ParameterDirection.Output, extra);
return(this);
}
private OutputParam <T> AddOutputParamInner <T>(string name, T val, ParameterDirection direction, ParamExtra extra)
{
DbParameter param = AddParamInner(name, val, direction, extra);
return(new OutputParam <T>(param));
}
