HOW TO CREATE MANY TO MANY RELATIONSHIP UISNG CODE FIRST APPROACH IN MVC

Question

User569149469 posted

hi,

I have two classes like this deal and product want to create a  many to many relatioship followed this approach but getting error any help is appreciated

 public class Deal 
    {
        public int id { set; get; }

        public string Deal_Sku { get; set; }

        public string Deal_Name { get; set; }

        public decimal cost { get; set; }

        public  IList<DealProduct> DealProducts{ get;set;}
    }

 public class Product
    {
        public int ID { get; set; }
        public string Prod_SKU { get; set; }
        public string Prod_Name { get; set; }
        public double Price { get; set; }
        public  IList<DealProduct> DealProducts { get; set; }

    }
 public class DealProduct
    {
        public int DealId;
        public int ProductId;
        public Decimal Cost;
        public bool Free;
    }

I am trying to create codefirst like this but getting error
  public  DbSet<Product> Products { get; set; }
       
        public  DbSet<CartItem> CartItems { get; set; }

        public  DbSet<Deal> Deals { get; set; }

        public  DbSet<DealProduct> DealProducts { get; set; }
       
        

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Conventions.Remove<PluralizingEntitySetNameConvention>();
            //modelBuilder.Entity<DealProduct>()
            //     .HasKey(c => new { c.DealId, c.ProductId });
            //modelBuilder.Entity<Deal>()
            //    .HasMany(d => d.DealProducts)
            //    .WithRequired()
            //    .HasForeignKey(c => c.DealId);

            //modelBuilder.Entity<Product>()
            //    .HasMany(p => p.DealProducts)
            //    .WithRequired()
            //    .HasForeignKey(d => d.DealId);
                        
        }