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 vote208 views1 answer
Weakreference tryget c#
C#
0 vote231 views1 answer
C# datagridview cell click event
C#
0 vote210 views1 answer
Notification platform not available c#
C#
3 votes271 views2 answers
Unity mouse click m
C#Unity
0 vote243 views3 answers
Www.elking.net
C#
2 votes234 views1 answer
Set player position unity
C#
0 vote223 views1 answer
C# reflection get property value array
C#
0 vote275 views1 answer
Implementing Banner Ads Unity
C#
0 vote221 views1 answer
C# async rethrow exception
C#
-1 vote213 views1 answer
Dotnet
C#