如何在查询一对多数据时将通用存储库与petapoco结合使用

// 定义数据模型
public class Order
{
    public int Id { get; set; }
    public string OrderNumber { get; set; }
    // 其他属性...
    public List<OrderItem> OrderItems { get; set; }
}

public class OrderItem
{
    public int Id { get; set; }
    public int OrderId { get; set; }
    public string ProductName { get; set; }
    // 其他属性...
}

// 定义通用存储库接口
public interface IRepository<T>
{
    T GetById(int id);
    List<T> GetAll();
    void Insert(T entity);
    void Update(T entity);
    void Delete(T entity);
}

// 实现通用存储库接口
public class Repository<T> : IRepository<T>
{
    private readonly Database _database;

    public Repository(Database database)
    {
        _database = database;
    }

    public T GetById(int id)
    {
        return _database.SingleOrDefault<T>(id);
    }

    public List<T> GetAll()
    {
        return _database.Fetch<T>();
    }

    public void Insert(T entity)
    {
        _database.Insert(entity);
    }

    public void Update(T entity)
    {
        _database.Update(entity);
    }

    public void Delete(T entity)
    {
        _database.Delete(entity);
    }
}

// 查询一对多数据
public class OrderService
{
    private readonly IRepository<Order> _orderRepository;
    private readonly IRepository<OrderItem> _orderItemRepository;

    public OrderService(IRepository<Order> orderRepository, IRepository<OrderItem> orderItemRepository)
    {
        _orderRepository = orderRepository;
        _orderItemRepository = orderItemRepository;
    }

    public Order GetOrderWithItems(int orderId)
    {
        var order = _orderRepository.GetById(orderId);
        if (order != null)
        {
            order.OrderItems = _orderItemRepository.GetAll().Where(x => x.OrderId == orderId).ToList();
        }
        return order;
    }
}

// 使用示例
var database = new Database("connectionString"); // 创建Petapoco的Database实例
var orderRepository = new Repository<Order>(database); // 创建订单的通用存储库实例
var orderItemRepository = new Repository<OrderItem>(database); // 创建订单项的通用存储库实例
var orderService = new OrderService(orderRepository, orderItemRepository); // 创建订单服务实例

var order = orderService.GetOrderWithItems(1); // 查询订单及其订单项