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

5 votes118 views2 answers
Unity hide in inspector
C#
0 vote142 views1 answer
Unity break if statement
C#Unity
1 vote158 views1 answer
Unity particle system playing at the wrong location
C#Unity
-1 vote149 views1 answer
Load Level Action for unity
C#Unity
0 vote118 views1 answer
Is odd c# stackoverflow
C#
0 vote126 views1 answer
Solid principles c#
C#
8 votes115 views2 answers
Unity rotate towards
C#
3 votes133 views1 answer
C# loop back
C#
0 vote158 views1 answer
Convert bool to uint in solidity
C#
3 votes119 views3 answers
C# int to byte Array
C#