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 vote205 views1 answer
Spreate by captial char in c#
C#
15 votes179 views2 answers
C# double value with 2 decimal places
C#
0 vote186 views1 answer
How to fix on Input.GetMouseButtonDown(0) conting as ui
C#
0 vote187 views1 answer
Parsing object from text file c#
C#
18 votes171 views4 answers
C# bytes to string
C#
6 votes261 views1 answer
Unity access child
C#Unity
3 votes180 views1 answer
Linq include
C#
4 votes233 views1 answer
Unity get velocity of gameobject
C#Unity
1 vote184 views1 answer
Public vs internal c#
C#
0 vote233 views1 answer
Return stream from file c#
C#