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

7 votes132 views2 answers
Unity float from another script
C#Unity
0 vote64 views1 answer
All functions unity
C#
0 vote97 views1 answer
C# listview as listbox
C#
0 vote88 views1 answer
Tempdata serializer cannot erorr
C#
1 vote89 views1 answer
Primitive types c#
C#
29 votes95 views3 answers
Delay in unity
C#
8 votes97 views1 answer
Unity mouse lock
C#
0 vote86 views1 answer
C# func vs action
C#
0 vote93 views1 answer
Loop menustrip buttons
C#
23 votes99 views4 answers
C# Base64 Encode
C#