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 vote96 views1 answer
Generate a dropdown list from array data using razor .net mvc
C#
0 vote104 views1 answer
Load information with txt file to uwp c#
C#
0 vote117 views1 answer
C# return list in descending order
C#
2 votes172 views1 answer
Unity gameobject.find not working
C#Unity
57 votes166 views10 answers
Bootstrap 4
C#
0 vote111 views1 answer
Access label from another class c#
C#
1 vote104 views2 answers
C# long to int
C#
14 votes105 views2 answers
Play animation through script unity
C#
2 votes144 views1 answer
Scene switch unity
C#Unity
3 votes111 views1 answer
Difference between public and serializefield unity
C#