I was wondering how Linq to Sql determines which tables to write to when given primary/foreign Key relationships. I can (hopefully) better explain using an example. I have the following tables:
Therefore I have a Customer Entity, a CustomerStatus entity, a CustomerType Entity and a List of CustomerAddresses. In my code, I load up the Customer Entity and the List of CustomerAddresses because that's all I need. For some reason Linq to Sql is trying to insert a new Customer Status record. I have no idea why its doing this.
Can anyone please explain to me how linq to sql determines which table(s) will be written to based on the entities above?
View Complete Post