使用实体框架检索逗号分隔的外键表数据

// 创建实体类
public class Order
{
    public int Id { get; set; }
    public string ProductIds { get; set; } // 逗号分隔的外键字段
    // 其他属性...
}

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

// 配置映射关系
public class OrderConfiguration : IEntityTypeConfiguration<Order>
{
    public void Configure(EntityTypeBuilder<Order> builder)
    {
        builder.ToTable("Orders");
        builder.HasKey(o => o.Id);
        // 其他配置...

        // 配置逗号分隔的外键字段的映射关系
        builder.HasMany(o => o.Products)
            .WithMany()
            .HasForeignKey(o => o.ProductIds);
    }
}

// 查询数据
public List<Product> GetProductsByOrderId(int orderId)
{
    using (var context = new YourDbContext())
    {
        var order = context.Orders
            .Include(o => o.Products)
            .FirstOrDefault(o => o.Id == orderId);

        if (order != null)
        {
            var productIds = order.ProductIds.Split(',');
            var products = context.Products
                .Where(p => productIds.Contains(p.Id.ToString()))
                .ToList();

            return products;
        }

        return null;
    }
}