Querymultiple dapper c#

string sql = "SELECT * FROM Invoice WHERE InvoiceID = @InvoiceID; SELECT * FROM InvoiceItem WHERE InvoiceID = @InvoiceID;";

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    using (var multi = connection.QueryMultiple(sql, new {InvoiceID = 1}))
    {
        var invoice = multi.Read<Invoice>().First();
        var invoiceItems = multi.Read<InvoiceItem>().ToList();
    }
}

Source: dapper-tutorial.net

Similar codes

1 vote319 views1 answer
C# lose 0 when converting
C#
0 vote312 views1 answer
Ssml
C#
0 vote310 views1 answer
How to detect ajax request in asp.net core
C#
1 vote267 views1 answer
How to go from one form to another in c# windows application
C#
1 vote311 views1 answer
Gcd of number
C#
0 vote305 views2 answers
Combobox in datagrid wpf
C#
0 vote323 views1 answer
C# MD5.Create returning nul
C#
0 vote315 views1 answer
Create iis website programmatically c#
C#
0 vote309 views1 answer
User control equivalent event for form.shown c#
C#
0 vote299 views1 answer
ASP.Net MVC 5 datalist event trap to perform action
C#