Breaking News: Grepper is joining You.com. Read the official announcement!

querymultiple dapper c#

Selfish Skylark answered on July 13, 2020 Popularity 8/10 Helpfulness 7/10

answer querymultiple dapper c#

querymultiple dapper c#

Comment

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();
    }
}

Popularity 8/10 Helpfulness 7/10 Language csharp

Source: dapper-tutorial.net

Tags: c# dapper

Link to this answer
Share Copy Link