How do I insert an new object to my database? right now objects are like this:
class order{ int idList<product>}
class order{ int idList<product>}
class orderproduct{int orderidint productId}
class orderproduct{int orderidint productId}
class Product{ int idList<order>}
class Product{ int idList<order>}
so I want to add an order object with an list of products(that contain the id) but I get erros. when I just use 1 of the same product: Cannot insert explicit value for identity column in table 'Products' when IDENTITY_INSERT is set to OFF.
when my list contains the same product twice: 'The instance of entity type 'Product' cannot be tracked because another instance with the same key value for {'Id'} is already being tracked.
Not really sure how to fix it.... Can also use dapper if that's easier