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

6 votes163 views1 answer
Unity call function on animation onstateexit
C#
0 vote146 views1 answer
Fill dataset with list c#
C#
1 vote147 views1 answer
C# get all inherited classes of a class
C#
0 vote157 views1 answer
Constructor in protobuf-net
C#
0 vote148 views1 answer
C# with keyword
C#
148 votes363 views10 answers
Grepper
C#
0 vote154 views1 answer
C# form formborderstyle none move
C#
0 vote150 views1 answer
How to store more precise data then float c#
C#
0 vote168 views1 answer
Convert word files to plain text c#
C#
0 vote136 views1 answer
Mongodb driver c# nuget
C#