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 vote355 views1 answer
C# hex to console color
C#
0 vote379 views1 answer
C# PrincipalContext The network path was not found
C#
4 votes351 views2 answers
C# Escape sequence
C#
1 vote357 views1 answer
Unity how to move an object to another object
C#
0 vote370 views1 answer
How to save datagridview data to database in c# windows application
C#
4 votes336 views1 answer
Create list with values C#
C#
2 votes363 views2 answers
C# declare empty string array
C#
0 vote361 views1 answer
How to pass optional guid parameters in c#
C#
1 vote358 views6 answers
Laravel collect
C#
0 vote344 views1 answer
C# list any retun indec
C#