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

0 vote144 views1 answer
Csc is not recognized
C#
0 vote151 views2 answers
Asp net identity login failed for user
C#
0 vote141 views1 answer
Get selected item datagrid wpf
C#
0 vote168 views1 answer
Cosmos db get all items in container
C#
0 vote127 views1 answer
How to print a matrix in c#
C#
0 vote163 views1 answer
Save string unity
C#Unity
2 votes151 views1 answer
How to restart flutter app programmatically
C#
1 vote150 views1 answer
C# sort array string by length
C#
1 vote128 views1 answer
Dynamics 365 update record c#
C#
0 vote134 views1 answer
Enemy turret one direction ahooting script unity 2d
C#