Linq submitchanges not updating
Developers using Visual Studio can use the Object Relational Designer to develop stored procedures for the same purpose. try catch (Exception e) ' Query the database for the row to be updated.
When we defined our data model, the LINQ to SQL designer also created a custom Data Context class that provides the main conduit by which we'll query our database and apply updates/changes.That are then held as a unit of work, then once you've finished your changes you simply commit them to the database as a single action or roll all of the changes back, maintaining the integrity of your database. 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.The Data Context is an object representation of the database.It is responsible for all the operations performed on the database.