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 vote133 views1 answer
C# get list item in random order
C#
1 vote163 views1 answer
Month number to text in c#
C#
0 vote145 views1 answer
Jarray to list c#
C#
2 votes134 views1 answer
Unity 2d how to set an object or the mouse position
C#
0 vote135 views1 answer
Get length of enum values
C#
-1 vote139 views1 answer
C# windows forms function after load
C#
0 vote123 views1 answer
Visual studio console writeline shortcut
C#
1 vote111 views1 answer
Set textbox colour to transparent c#
C#
25 votes127 views2 answers
Time delay C# unity
C#
0 vote117 views1 answer
Linq get a dictionary key and value c#
C#