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 vote124 views1 answer
.net disable show exception
C#
1 vote171 views1 answer
Unity agent bake not derecting mesh
C#Unity
0 vote103 views1 answer
Unity get max occurrence in list
C#
1 vote118 views1 answer
Unserialized field unity
C#
13 votes115 views4 answers
C# how to sort a list
C#
2 votes113 views2 answers
How to destroy parent gameobject unity
C#
20 votes117 views3 answers
C# foreach enum
C#
0 vote78 views1 answer
Canceltion token c#
C#
2 votes122 views2 answers
Default route in asp.net core
C#
0 vote145 views1 answer
Unity respawn c#
C#Unity