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

9 votes307 views2 answers
Get last character of string c#
C#
1 vote368 views1 answer
How to get executable path in wpf
C#
0 vote322 views1 answer
C# MemoryStream - Timeouts are not supported on this stream
C#
0 vote395 views1 answer
Difference between awake and start unity
C#Unity
1 vote307 views1 answer
C# request run as administrator
C#
0 vote313 views1 answer
C# webrtc dll
C#
1 vote301 views1 answer
How do i destroy a prefab without the error?
C#
1 vote318 views1 answer
Unity c#loading a scene after a few seconds
C#
38 votes450 views2 answers
Get mouse position unity
C#Unity
0 vote325 views1 answer
Dotween dovalue
C#