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 vote225 views2 answers
Relative path c#
C#
0 vote234 views1 answer
Check if object has parent unity
C#Unity
34 votes298 views2 answers
Open scene unity
C#Unity
1 vote225 views1 answer
Entity framework update child records
C#
7 votes238 views2 answers
How to instantiate as child unity
C#
0 vote199 views7 answers
Python to php converter online
C#
3 votes213 views3 answers
C# int to byte Array
C#
0 vote234 views1 answer
Unity repeat coroutine
C#Unity
6 votes228 views2 answers
How to disable and enable rigidbody unity
C#Unity
0 vote204 views1 answer
How to write an if statement with two checkboxes in c#
C#