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 votes131 views1 answer
Set object to random color unity
C#
2 votes168 views1 answer
Find closest gameobject unity
C#Unity
0 vote143 views1 answer
Gegenstände bewegen c#
C#
-1 vote117 views1 answer
Copy file
C#
0 vote130 views1 answer
C# how to ignore case
C#
0 vote121 views1 answer
C# xamaring form change text on label
C#
15 votes132 views10 answers
Hello world
C#
0 vote115 views1 answer
Math.pow in C# using loop
C#
0 vote141 views1 answer
C# file watcher specific file
C#
0 vote139 views1 answer
Linq convert list to another list
C#