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 vote162 views1 answer
Fade image out unity
C#Unity
0 vote111 views1 answer
Datareader get field names
C#
0 vote101 views1 answer
Como guardar archivo en un botón asp.net
C#
1 vote100 views1 answer
Blank background for button wpf
C#
0 vote124 views1 answer
Detect mouse in bottom of screen + unity
C#Unity
0 vote133 views1 answer
Top down movement unity
C#Unity
1 vote59 views3 answers
C# to binary
C#
5 votes58 views1 answer
Know to which direction Vector.MoveTowards is moving unity 2D
C#
0 vote135 views1 answer
Log4net.config configuration
C#
0 vote105 views1 answer
C# binding add combobox with enum values
C#