private IDataParameter AddParameter(IDataProcedure proc, string name, SqlDbType dbType, int size)
{
var p = new SqlParameter(name, dbType, size);
proc.Parameters.Add(p);
return(p);
}
public static IDataProcedure AddParameter(this IDataProcedure proc, string name, object value,
DbType?type = null, int size = 0)
{
var param = (IDbDataParameter)proc.CreateParameter();
param.ParameterName = name;
param.DbType = DeriveParameterType(name, value, type, out var prmSize);
param.Size = size > 0 ? size : prmSize;
param.Value = value;
proc.Parameters.Add(param);
return(proc);
}
