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 vote338 views2 answers
Check if multiple variables are null c#
C#
-1 vote276 views1 answer
Window.location c#
C#
4 votes342 views1 answer
C# loop datatable rows
C#
2 votes397 views1 answer
Unity c# set object tag
C#Unity
0 vote323 views1 answer
How to stop timer in c# windows application
C#
0 vote388 views1 answer
C# out argument
C#
1 vote353 views1 answer
O(n*m)
C#
1 vote338 views2 answers
C# singleton
C#
1 vote354 views1 answer
Unity image
C#
0 vote418 views1 answer
Request ID: XPBBR4XG1UWuX6fWF08_-jzYkrommVJjO7Os50CTYuZmiw7kMsFUkw==
C#