基础多结果示例

Created: November-22, 2018

要在单个查询中获取多个网格，请使用 QueryMultiple 方法。然后，这允许你通过针对返回的 GridReader 的连续调用顺序检索每个网格。

var sql = @"select * from Customers where CustomerId = @id
            select * from Orders where CustomerId = @id
            select * from Returns where CustomerId = @id";

using (var multi = connection.QueryMultiple(sql, new {id=selectedId}))
{
   var customer = multi.Read<Customer>().Single();
   var orders = multi.Read<Order>().ToList();
   var returns = multi.Read<Return>().ToList();
}