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

0 vote329 views1 answer
C# httpclient post no content
C#
2 votes320 views1 answer
C# list.foreach
C#
3 votes352 views1 answer
Change the text of inputfield unity
C#
5 votes344 views1 answer
Dns ttl meaning
C#
1 vote333 views1 answer
Gucci gang lyrics
C#
0 vote368 views1 answer
Get sprite name from gameobject
C#
0 vote274 views1 answer
Visibility bound to radio button wpf
C#
0 vote326 views1 answer
C# latex
C#
0 vote326 views1 answer
Celsius to Fahrenheit c#
C#
1 vote407 views1 answer
Oculus Unity add haptics
C#Unity