Context submitchanges not updating
NET Framework 3.5 release, and which enables you to easily model relational databases using . You can use LINQ expressions to query the database with them, as well as update/insert/delete data.
Turns out the LINQ2SQL class was missing the primary key (even though the SQL table had one set).
Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL.
LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .
However, this does not roll back the changes in memory or tracked by the Data Context; those changes will need to be rolled back manually.
You can start with a new instance of the Data Context if the changes in memory are to be discarded.