Dapper - Parameter Dynamic
Many
var parameters = new List<DynamicParameters>();
for (var i = 0; i < 3; i++)
var p = new DynamicParameters();
p.Add("@Kind", InvoiceKind.WebInvoice, DbType.Int32, ParameterDirection.Input);
p.Add("@RowCount", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
parameters.Add(p);
}
{
connection.Execute(sql,
parameters,
commandType: CommandType.StoredProcedure
);