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 vote161 views2 answers
ASP.NET Core set update clear cache from IMemoryCache (set by Set method of CacheExtensions class)
C#
6 votes148 views1 answer
C# save bytes array to file
C#
0 vote143 views1 answer
Unity disable the display of the camera frustrum
C#
1 vote139 views1 answer
C# convert seconds to hours minutes seconds
C#
0 vote154 views1 answer
Convert int to short c#
C#
1 vote154 views1 answer
How to use double in c#
C#
0 vote165 views2 answers
Wpf toolbar disable overflow
C#
0 vote155 views1 answer
Unity NetworkBehaviour the type or namespace could not be found
C#
0 vote169 views2 answers
C# string to uri
C#
0 vote146 views1 answer
Collection to datatable c#
C#