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 vote109 views1 answer
C# execute run control panel
C#
0 vote125 views1 answer
Wpf binding ancestor codebehind
C#
1 vote110 views1 answer
Ensuresuccessstatuscode exception
C#
14 votes118 views5 answers
React add class conditionally
C#
0 vote97 views1 answer
Flutter failed asertion
C#
0 vote136 views1 answer
Unity matchinfo
C#Unity
0 vote110 views1 answer
Compact in laravrl
C#
43 votes119 views3 answers
.net loop through dictionary
C#
0 vote138 views1 answer
How to full screen login form using C# MVC
C#
0 vote129 views2 answers
C# copy directory
C#