You are implementing ASP.NET Web service methods named GetEmployees and UpdateEmployees. GetEmployees uses LINQ to SQL to return an employees result set. UpdateEmployees updates the database with changes made to the employees result set.

In UpdateEmployees, you create a DataContext. You must add code to associate the modified result set with this DataContext instance and submit changes to the database. Your solution should use a minimum of developer effort.

What should you do?

The Attach method is provided to enable you to put entities into a new data context after they have been detached. Call this method before calling SubmitChanges.

Although executing the same query used to create the result set and then programmatically reconciling the result sets before calling SubmitChanges might work, it takes a considerable amount of effort.

Adding all results programmatically using InsertOnSubmit and calling SubmitChanges inserts redundant rows. This is not the intended result.