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

2 votes348 views2 answers
How to convert a 2d coordinate to an index
C#
0 vote312 views1 answer
Function on program stops unity
C#
3 votes315 views2 answers
C# array index tostring
C#
0 vote342 views1 answer
System.InvalidOperationException: The AuthorizationPolicy named: 'View All Roles' was not found.
C#
0 vote331 views1 answer
How to map datatable to list in c#
C#
1 vote378 views1 answer
Slider.onchanged in unity
C#
9 votes346 views2 answers
Exit button unity code
C#Unity
6 votes345 views2 answers
Play sound unity
C#Unity
2 votes317 views1 answer
Windows form rounded corners
C#
7 votes336 views3 answers
C# run as administrator
C#