QueryMultiple

描述

QueryMultiple是一個(gè)可以從IDbConnection類型的任意對(duì)象調(diào)用的擴(kuò)展方法，它可以在相同的命令和映射結(jié)果中執(zhí)行多個(gè)查詢。

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();
    }
}

參數(shù)

下表顯示了QueryMultiple方法的不同參數(shù)。