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

27 votes139 views4 answers
How to get a length of a string in c#
C#
10 votes185 views4 answers
Unity array c#
C#Unity
0 vote148 views2 answers
__dopostback
C#
1 vote200 views1 answer
Unity3d change player position
C#Unity
0 vote188 views1 answer
Get the current directory in unity
C#Unity
0 vote130 views1 answer
Generate a dropdown list from array data using razor .net mvc
C#
2 votes169 views2 answers
Linq select
C#
0 vote134 views1 answer
Asp.net web hooks
C#
35 votes142 views4 answers
Get list length c#
C#
0 vote142 views2 answers
C# get pixel color from image
C#