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

2 votes227 views2 answers
Transform widget in flutter
C#
1 vote262 views1 answer
Get string name of dropdown in unity
C#Unity
3 votes257 views1 answer
Mouse button hold unity
C#Unity
4 votes244 views3 answers
Public gameobject
C#
2 votes223 views1 answer
Unity can't select move tool
C#Unity
1 vote169 views3 answers
C# to binary
C#
1 vote212 views1 answer
Make mesh follow wheel collider unity
C#
11 votes220 views3 answers
C# exit console
C#
0 vote225 views1 answer
How to make soft body OBJECT in unity
C#
0 vote259 views1 answer
Remove compoennt unity
C#Unity