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 vote303 views1 answer
How to make an object appear and disappear in unity
C#
0 vote283 views1 answer
Startup c# class winform
C#
0 vote328 views1 answer
Unity banner ad C#
C#Unity
12 votes284 views2 answers
How to make an object move in unity
C#
1 vote309 views1 answer
Unity image
C#
0 vote342 views1 answer
Razor confirm password validation
C#
2 votes294 views1 answer
Where C#
C#
37 votes280 views5 answers
How to generate random number in unity
C#
0 vote346 views1 answer
C# half hour dropdown list
C#
0 vote319 views1 answer
Unity get default font
C#