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 vote278 views2 answers
2d list c#
C#
0 vote307 views1 answer
C# int array add number
C#
0 vote276 views2 answers
Decode token to get claims value
C#
14 votes269 views2 answers
How to make multiplayer game in unity
C#
2 votes210 views1 answer
Cursor visible unity
C#
1 vote267 views1 answer
Vb.net open file with default program
C#
0 vote254 views1 answer
Startup c# class winform
C#
0 vote274 views1 answer
Asp net mvc 5 return view from another controller
C#
0 vote264 views1 answer
How to pass function as paraemter of another function pythpn
C#
0 vote263 views1 answer
How to do minus with button c#
C#