I have VS automatically generate classes for my tables in my database. One of these classes is a Order class. The Order class has CustomerID, ContactID, OrderNoteID, OrderDateID, etc. THe problem I am having is when I try and add a new order it is trying to add a new Customer, and new Contact, and new Address all into their respective tables. This is because it has EntityRef(Of Customer), EntityRef(Of Contact), etc.

But this is obviously absurd. Just because my Orders table has a foreign key to the Customer table does not mean that I want it to add a new customer each time I add an order.

Does anyone have any experience with this stuff who could help?

THanks.