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 vote239 views1 answer
Tsql list tables
C#
13 votes308 views3 answers
C# get last item in list
C#
0 vote301 views1 answer
How to get the askii code of a char in c#
C#
0 vote278 views1 answer
Detect location from ip address .net core
C#
0 vote307 views1 answer
Unity3d gameobject follow path
C#
0 vote233 views1 answer
C# constant list
C#
174 votes479 views6 answers
C# foreach
C#
0 vote287 views1 answer
Moq set delay to return
C#
3 votes280 views2 answers
Unity Make a 2D object look at the mouse position
C#
3 votes223 views1 answer
Aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
C#