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

2 votes170 views1 answer
C# aspnet how to run a migration
C#
4 votes173 views2 answers
Vector3 to quaternion C#
C#
0 vote251 views1 answer
Fade image out unity
C#Unity
2 votes169 views2 answers
Commenting on C#
C#
0 vote163 views4 answers
Kube dashboard expose access port
C#
0 vote211 views1 answer
Mvc c# return renderPartial
C#
0 vote217 views1 answer
C# add multiple items to list
C#
0 vote162 views2 answers
C# datagridview set column header alignment
C#
0 vote165 views1 answer
Pass datatable to stored procedure c# dapper
C#
0 vote220 views1 answer
Unity deactive all object in list
C#Unity