Datacontext submitchanges not updating database

25 Jan

After upgrading to Visual Studio 2008 RTM, you will have trouble updating Linq to SQL Classes which are read from one data context and then updated into another data context.

I am playing around with LINQ to SQL in conjunction with business objects.

You can use your own custom logic to override these actions, but the order of submission is orchestrated by a service of the Data Context known as the At this point, any errors detected by the database cause the submission process to stop, and an exception is raised.Here is a small block of c# code samples to create new ‘User’ linq to sql class(Representing ‘Users’ Table in Database) and add it to ‘Users Data Context’ class(Represents the database) and commit the changes to original database by ‘Submit Changes'(without this, no changes will be reflected to database): For your information, the above code example is for . If you are using an earlier version, you will have to use ‘Add‘ method instead of ‘Insert On Submit‘ . Deleting data/row from database using linq is as simple as inserting data and this is also sql syntax free operation 🙂 .First, we will have to retrieve the ‘user’ object we want to delete, and then add this deletion operation in the queue by ‘Delete On Submit’ method.I am assuming, you already know how to create dbml/linq to sql classes: Being Lin Q as a ORM, it’s quite easy and sql syntax free way to insert data using Lin Q.We just need to create a new object of corresponding database table type, then add it to the Data Context object and then commit the changes. If you want to insert more than one row, then you will have to create a ‘List’ array object containing all the ‘User’ objects and then use ‘Insert All On Submit‘ method, it will work fine.