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

3 votes289 views1 answer
Unity pause animator
C#
0 vote224 views1 answer
C# reopen form if open
C#
15 votes240 views4 answers
How to remove white spaces from string in c#
C#
2 votes237 views1 answer
Unity check for internet connection
C#
0 vote241 views1 answer
Force overwrite c#
C#
-1 vote232 views2 answers
Git find commits by message
C#
2 votes277 views1 answer
New Color from hex in unity
C#Unity
1 vote233 views1 answer
How to maximize but show taskbar c#
C#
10 votes269 views4 answers
C# shuffle list
C#
0 vote196 views1 answer
Selenium c# add chrome options
C#