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 vote301 views1 answer
C# reflection create generic type
C#
0 vote322 views2 answers
Append multi lines to file linux
C#
42 votes304 views6 answers
List C#
C#
2 votes316 views2 answers
Unity don't destroy on load
C#
2 votes301 views2 answers
Remove items from list c# condition
C#
0 vote326 views1 answer
C# expression func automatically select return type
C#
2 votes301 views2 answers
How to destroy parent gameobject unity
C#
2 votes350 views1 answer
C# delete files older than x months
C#
18 votes293 views1 answer
How to remove a component from an object in unity
C#
0 vote287 views1 answer
Unity draw ray from one object to another
C#