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 vote316 views1 answer
C# how to debig
C#
3 votes326 views1 answer
Unity how to rotate something to point to something else
C#Unity
1 vote259 views1 answer
Check if network is available c#
C#
0 vote319 views3 answers
Useinmemorydatabase not found c#
C#
4 votes276 views1 answer
C# convert Unix time in seconds to datetime
C#
-1 vote307 views1 answer
Unity check if colliders are touching
C#
1 vote332 views1 answer
Int to ascii c#
C#
1 vote276 views1 answer
C# method returns multiple values
C#
3 votes273 views1 answer
Asp.net list all files in folder
C#
0 vote315 views1 answer
What error code i should return in asp.net core whether user name or password are incorrect
C#