When learning LINQ-to-SQL, it’s not immediately obvious how to do an update. Querying is easy, and there are methods for inserting and deleting. Updating usually occurs by modifying an object already known to the DataContext and then calling SubmitChanges on the context.
var product = (from p in dataContext.Products
[...]
Lesen Sie den vollständigen Eintrag unter http://richardbushnell.net/index.php/2008/02/18/how-to-update-data-with-linq-to-sql/