Dapper - Parameter Dynamic

    Many

    1. var parameters = new List<DynamicParameters>();
    2. for (var i = 0; i < 3; i++)
    3. var p = new DynamicParameters();
    4. p.Add("@Kind", InvoiceKind.WebInvoice, DbType.Int32, ParameterDirection.Input);
    5. p.Add("@RowCount", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
    6. parameters.Add(p);
    7. }
    8. {
    9. connection.Execute(sql,
    10. parameters,
    11. commandType: CommandType.StoredProcedure
    12. );