c# - EF Code一对多

我该如何让一个类具有一个由另一个模型组成的集合，并在获取原始模型时将其填充。我有一个愿望清单，该愿望清单中有0或许多产品。如果要执行db.Wishlist.find（id），我的数据注释或流利的API需要说些什么才能使其填充。这是我目前在愿望清单模型中所拥有的

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Models
{
    [Table("Wishlist")]
    public class Wishlist
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [ScaffoldColumn(false)]
        public int ID { get; set; }

        [StringLength(100)]
        public string Name { get; set; }

        public int ProductID { get; set; }

        public virtual ICollection<Product> Product { get; set; }

        public int CustomerID { get; set; }

        [Required]
        public Customer Customer { get; set; }

        public virtual List<Product> Products { get; set; }

        [DisplayFormat(DataFormatString = "{0:f}")]
        public DateTime CreateDate { get; set; }


        [DisplayFormat(DataFormatString = "{0:f}")]
        public DateTime LastModifiedDate { get; set; }


    }
}

将产品作为集合或列表进行填充所需的条件。实现此目标的正确方法是什么？我知道一定要去其中的一组产品，只是不确定需要什么和什么。

更新：添加了我的产品型号的显示。

namespace Models
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("Product")]
    public partial class Product
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public Product()
        {
            OrderLines = new HashSet<OrderLine>();
            SKU_Table = new HashSet<Sku>();
            XREF_CatalogProduct = new HashSet<XREF_CatalogProduct>();
            ProductImages = new List<ProductImage>();
        }

        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }

        [NotMapped]
        public string FormattedPrice { get { return this.Price.ToString("C"); } }

        [Required]
        [MaxLength]
        public string PageURL { get; set; }

        [Required]
        [StringLength(250)]
        public string Name { get; set; }

        [Required]
        public string Code { get; set; }

        public string Description { get; set; }

        public int CategoryID { get; set; }

        [Column(TypeName = "money")]
        [DisplayFormat(DataFormatString = "${0:#,0}", ApplyFormatInEditMode = true)]
        public decimal Price { get; set; }

        public DateTime? DateCreated { get; set; }

        public DateTime? DateModified { get; set; }

        [Required]
        public bool Featured { get; set; }

        public virtual string ImagePath { get; set; }

        public virtual Category Category { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<OrderLine> OrderLines { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<Sku> SKU_Table { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<XREF_CatalogProduct> XREF_CatalogProduct { get; set; }

        public virtual ICollection<ProductImage> ProductImages { get; set; }
    }
}

最佳答案

您必须与M: M建立Wishlist : Product关系。如果使用Junction table，则代码首先会为您创建一个DataAnnotation。

使用DataAnnotation：

[Table("Wishlist")]
public class Wishlist
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [ScaffoldColumn(false)]
    public int ID { get; set; }

    [StringLength(100)]
    public string Name { get; set; }

    public int CustomerID { get; set; }

    [Required]
    public Customer Customer { get; set; }

    [DisplayFormat(DataFormatString = "{0:f}")]
    public DateTime CreateDate { get; set; }


    [DisplayFormat(DataFormatString = "{0:f}")]
    public DateTime LastModifiedDate { get; set; }

    public virtual ICollection<Product> Products { get; set; }

}

和

    [Table("Product")]
    public partial class Product
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public Product()
        {
            OrderLines = new HashSet<OrderLine>();
            SKU_Table = new HashSet<Sku>();
            XREF_CatalogProduct = new HashSet<XREF_CatalogProduct>();
            ProductImages = new List<ProductImage>();
            this.Wishlists = new HashSet<Wishlist>();

        }

        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; }

        [NotMapped]
        public string FormattedPrice { get { return this.Price.ToString("C"); } }

        [Required]
        [MaxLength]
        public string PageURL { get; set; }

        [Required]
        [StringLength(250)]
        public string Name { get; set; }

        [Required]
        public string Code { get; set; }

        public string Description { get; set; }

        public int CategoryID { get; set; }

        [Column(TypeName = "money")]
        [DisplayFormat(DataFormatString = "${0:#,0}", ApplyFormatInEditMode = true)]
        public decimal Price { get; set; }

        public DateTime? DateCreated { get; set; }

        public DateTime? DateModified { get; set; }

        [Required]
        public bool Featured { get; set; }

        public virtual string ImagePath { get; set; }

        public virtual Category Category { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<OrderLine> OrderLines { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<Sku> SKU_Table { get; set; }

        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<XREF_CatalogProduct> XREF_CatalogProduct { get; set; }

        public virtual ICollection<ProductImage> ProductImages { get; set; }

        public virtual ICollection<Wishlist> Wishlists { get; set; }


    }

EF查询：根据wishlist检索product Id

var prod_id=1; // your product id

var query= from wishlist in db.Wishlists
           where wishlist.Products.Any(c=>c.Product_ID== prod_id)
           select wishlist;

使用Fluent Api：

 protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {

        modelBuilder.Entity<Wishlist>()
                    .HasMany<Product>(s => s.Products)
                    .WithMany(c => c.Wishlists)
                    .Map(cs =>
                            {
                                cs.MapLeftKey("WishlistRefId");
                                cs.MapRightKey("ProductRefId");
                                cs.ToTable("WishlistProduct");
                            });

    }

EF查询：根据wishlist检索product Id

var prod_id=1; // your product id

var query= from wishlist in db.Wishlists
           where wishlist.Products.Any(c=>c.ProductRefId == prod_id)
           select wishlist;