In LinqToSql how do you enable change tracking on an entity's custom property?

Question

For other reasons, i've had to create my own property in an Entity in the ORM, which has is a type of another entity (had issues with associations so did it this way instead).

The problem is that whenever I make a change to that property, it isn't being flagged as a change so I cannot call SubmitChanges on it.

So basically my question is, is there a way of forcing a property to be tracked for changes for when I call SubmitChanges?

thanks.

Answer 1

Does your custom property have a corresponding field in the database?

I would try adding your field to the database first. Delete the entity from the Linq2SQL designer, save the designer file, drag the table back to the designer from the Database Explorer, and save again. This will recreate the entity with your desired property, and insure that all of the hooks are in place for SubmitChanges().