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

30 votes189 views4 answers
Convert string to date in c#
C#
0 vote165 views1 answer
Open and close autocad api
C#
11 votes176 views3 answers
Enum get all values C#
C#
0 vote204 views2 answers
Unity list get item at index
C#Unity
0 vote175 views1 answer
Settings save c# visual studio doesn't work
C#
0 vote171 views1 answer
Wpf rounded image
C#
1 vote178 views1 answer
Unity getcomponent not working on ui
C#
9 votes172 views2 answers
Unity find gameobject with layer
C#
1 vote177 views1 answer
C# string capital first letter extension method
C#
0 vote150 views1 answer
Dotnet DB context register
C#