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

2 votes160 views1 answer
Parse strings into words C#
C#
15 votes185 views10 answers
Hello world
C#
1 vote204 views2 answers
C# listview add item
C#
11 votes196 views3 answers
How to remove all whitespace from a string in c#
C#
11 votes181 views2 answers
C# messagebox result
C#
1 vote178 views1 answer
How get piece of text in laravel in persian text
C#
0 vote190 views1 answer
True false when key pressed in c sharp unity
C#
0 vote192 views1 answer
Jobject alternative in system.text.json
C#
0 vote233 views1 answer
Turn list of string to csv c#
C#
23 votes235 views2 answers
Unity no serializefield
C#Unity