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