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 views1 answer
Button action asp net
C#
0 vote221 views1 answer
Unity gameobject visible to specific camera
C#Unity
0 vote192 views1 answer
C# webrtc dll
C#
3 votes218 views1 answer
Unity detect any key
C#Unity
0 vote138 views1 answer
Carousel in asp.net
C#
20 votes190 views3 answers
Player movement unity 3d script
C#Unity
8 votes187 views2 answers
Float to int c#
C#
3 votes208 views1 answer
Change the text of inputfield unity
C#Unity
6 votes170 views2 answers
Scaffold db ef core
C#
11 votes206 views2 answers
Unity 2d raycast mouse
C#Unity