[2008] LINQ question

[Psychlotron]

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.

[Jenner]

Let's see your code as to how you're trying to add a new order. Also, you may want to change the post title to "LINQ to SQL question", because the whole side of LINQ that talks directly to SQL databases is separate and in it's own little world from the rest of LINQ.