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 vote185 views1 answer
How to resize a panel unity
C#
0 vote164 views1 answer
C# test if char is alpha
C#
0 vote154 views1 answer
UPA Error
C#
0 vote144 views1 answer
Antlr c# errors
C#
1 vote163 views1 answer
C# method returns multiple values
C#
10 votes164 views2 answers
Forech unity
C#
1 vote171 views1 answer
How to open new form on button click in c# xamarin
C#
0 vote237 views1 answer
Unity random.insideunitcircle
C#Unity
2 votes161 views1 answer
Linq query select top 1 c#
C#
0 vote150 views1 answer
How to download things c#
C#