Btukfyl

I'm trying to create an 'Order' object that has a Collection of 'OrderItem's that hold a 'Hamper' object. Basically, whenever I try to save the 'Order' object to my database, i keep getting this error that I can't insert explict values into the table for my hampers, except i'm not altering the Hamper data, i'm simply using those objects within another object.
My hamper model has :

[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]

Before the primary key object. I have no idea what to do to be perfectly honest and nothing i've found online has seemed to help. Whether i'm explicity adding the 'OrderItem' object one by one or the whole collection within the 'Order' object, I still can't get away from this error. I have linked the HamperID within the 'OrderItem' as a foriegn key, and i haven't had this issue when saving objects within other objects, it's just this example.
Anyway, here's the error. I wouldn't expect including the models would be much help, but the specific error is a follows:

Inner Exception 1:

SqlException: Cannot insert explicit value for identity column in table 

'TblHamper' when IDENTITY_INSERT is set to OFF.

And here is the 'OrderItem' model that is causing the error whenever I try to save:

    [Key]

    public int Id { get; set; }

    public Hamper Hamper { get; set; }

    public int Quantity { get; set; }

    [ForeignKey("HamperID")]

    public int HamperID { get; set; }

For EF Core to decide whether to update or create, it is controlled by Tracking. For your scenario, it seems you initialize a new Hamper when create a new Order with a new OrderItem.

Try options below:

• 
  

  Reset Hamper with Hamper in database.

  
  
  

          Hamper hamper = new Hamper { Id = 1, Name = "H1" };
  
          Hamper dbHamper = _context.Hamper.FirstOrDefault(h => h.Id == hamper.Id);
  
          OrderItem orderItem = new OrderItem { Title = "T1", HamperId = dbHamper.Id, Hamper = dbHamper };
  
          Order order = new Order { OrderNo = "O1", OrderItem = orderItem };
  
          await _context.Order.AddAsync(order);
  
          await _context.SaveChangesAsync();
  
  

  
  


• 
  

  Attach to start Tracking

  
  
  

              Hamper hamper = new Hamper { Id = 1, Name = "H1" };
  
          _context.Attach(hamper);
  
          OrderItem orderItem = new OrderItem { Title = "T1", HamperId = hamper.Id, Hamper = hamper };
  
          Order order = new Order { OrderNo = "O1", OrderItem = orderItem };
  
          await _context.Order.AddAsync(order);
  
          await _context.SaveChangesAsync();
  
  

  
  


• 
  

  Or, you could pass the HamperId without Hamper

  
  
  

              Hamper hamper = new Hamper { Id = 1, Name = "H1" };
  
          OrderItem orderItem = new OrderItem { Title = "T1", HamperId = hamper.Id };
  
          Order order = new Order { OrderNo = "O1", OrderItem = orderItem };
  
          await _context.Order.AddAsync(order);
  
          await _context.SaveChangesAsync();