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

1 vote174 views1 answer
Fade text unity
C#
6 votes183 views1 answer
How to generate entities from an existing database in entityframework core
C#
11 votes170 views2 answers
Dota2
C#
0 vote166 views2 answers
How to use file watcher in c#
C#
0 vote171 views1 answer
Subquery in LInQ EF Core C#
C#
0 vote186 views1 answer
C# create instance from type
C#
0 vote183 views1 answer
C# regex replace all line breaks
C#
19 votes175 views2 answers
Unity change text
C#Unity
0 vote195 views1 answer
Unity2d switch camera
C#Unity
2 votes201 views1 answer
Unity 2d how to set an object or the mouse position
C#Unity