如何使用Dapper查询具有一对多关系的对象？

public class Order
{
    public int OrderId { get; set; }
    public string OrderNumber { get; set; }
    // 其他订单相关属性...
    public List<OrderItem> OrderItems { get; set; }
}

public class OrderItem
{
    public int OrderItemId { get; set; }
    public int OrderId { get; set; }
    public string ProductName { get; set; }
    // 其他订单项相关属性...
}

public List<Order> GetOrdersWithItems()
{
    using (var connection = new SqlConnection("YourConnectionString"))
    {
        string sql = @"
            SELECT o.OrderId, o.OrderNumber, oi.OrderItemId, oi.ProductName
            FROM Orders o
            JOIN OrderItems oi ON o.OrderId = oi.OrderId";

        var orders = new Dictionary<int, Order>();

        connection.Query<Order, OrderItem, Order>(sql, (order, orderItem) =>
        {
            Order existingOrder;
            if (!orders.TryGetValue(order.OrderId, out existingOrder))
            {
                existingOrder = order;
                existingOrder.OrderItems = new List<OrderItem>();
                orders.Add(existingOrder.OrderId, existingOrder);
            }

            existingOrder.OrderItems.Add(orderItem);
            return existingOrder;
        }, splitOn: "OrderItemId");

        return orders.Values.ToList();
    }
}