I am attempting to create a very simple database that uses a Junction Table. (see diagram)
Basically, what I would like to achieve is to assign one product to multiple categories; When I run the code bellow, (in C#) I receive a constraint error;
I am wondering what specifically is wrong with the diagram, and how I can change the DB to allow a product in multiple categories?
Thanks for your time
var adapterManager = new TableAdapterManager
ProductCategoryTableAdapter = new ProductCategoryTableAdapter(),
CategoryTableAdapter = new CategoryTableAdapter(),
ProductTableAdapter = new ProductTableAdapter()