如何使用FluentMap进行一对多映射？

dotnet add package Dapper
dotnet add package Dapper.FluentMap
dotnet add package Dapper.FluentMap.Dommel

CREATE TABLE Orders (
    OrderId INT PRIMARY KEY,
    OrderDate DATETIME
);

CREATE TABLE OrderItems (
    OrderItemId INT PRIMARY KEY,
    OrderId INT,
    ProductName NVARCHAR(100),
    Quantity INT,
    FOREIGN KEY (OrderId) REFERENCES Orders(OrderId)
);

public class Order
{
    public int OrderId { get; set; }
    public DateTime OrderDate { get; set; }
    public List<OrderItem> OrderItems { get; set; } = new List<OrderItem>();
}

public class OrderItem
{
    public int OrderItemId { get; set; }
    public int OrderId { get; set; }
    public string ProductName { get; set; }
    public int Quantity { get; set; }
}

using Dapper.FluentMap;
using Dapper.FluentMap.Dommel;
using Dapper.FluentMap.Mapping;

public class OrderMap : EntityMap<Order>
{
    public OrderMap()
    {
        Map(o => o.OrderId).ToColumn("OrderId");
        Map(o => o.OrderDate).ToColumn("OrderDate");
    }
}

public class OrderItemMap : EntityMap<OrderItem>
{
    public OrderItemMap()
    {
        Map(oi => oi.OrderItemId).ToColumn("OrderItemId");
        Map(oi => oi.OrderId).ToColumn("OrderId");
        Map(oi => oi.ProductName).ToColumn("ProductName");
        Map(oi => oi.Quantity).ToColumn("Quantity");
    }
}

public static class FluentMapperInitializer
{
    public static void Initialize()
    {
        FluentMapper.Initialize(config =>
        {
            config.AddMap(new OrderMap());
            config.AddMap(new OrderItemMap());
            config.ForDommel();
        });
    }
}

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using Dapper;

public class Program
{
    public static void Main()
    {
        FluentMapperInitializer.Initialize();

        using (var connection = new SqlConnection("YourConnectionString"))
        {
            var sql = @"
                SELECT * FROM Orders o
                LEFT JOIN OrderItems oi ON o.OrderId = oi.OrderId";

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

            var orders = connection.Query<Order, OrderItem, Order>(
                sql,
                (order, orderItem) =>
                {
                    if (!orderDictionary.TryGetValue(order.OrderId, out var currentOrder))
                    {
                        currentOrder = order;
                        orderDictionary.Add(currentOrder.OrderId, currentOrder);
                    }

                    currentOrder.OrderItems.Add(orderItem);
                    return currentOrder;
                },
                splitOn: "OrderItemId"
            ).Distinct().ToList();

            foreach (var order in orders)
            {
                Console.WriteLine($"Order ID: {order.OrderId}, Order Date: {order.OrderDate}");
                foreach (var item in order.OrderItems)
                {
                    Console.WriteLine($"  Order Item ID: {item.OrderItemId}, Product: {item.ProductName}, Quantity: {item.Quantity}");
                }
            }
        }
    }
}