Linq submitchanges not updating
Regenerating our Data Context So, if you are changing the underlying table, updating the Data Context in your system is also required.
In Visual Studio 2008 there are only two ways to update a Data Context.
If we inserted a new person then this also wouldn’t stop our application from working, unless the new column was set to be NOT NULL, however we wouldn’t be able to fill in that information.
Changing column data types Changing the types in our database could cause our application to stop functioning.
The Data Context still has a full recording of all changes.
You can therefore try to correct the problem and call Submit Changes again, as in the code example that follows.
Regardless of how many changes you make to your objects, changes are made only to in-memory replicas.
You have made no changes to the actual data in the database.