Linq 2 Sql DataContext Update Issue During Fetch/Edit/Update Workflow?

I would use a DataContext that is created each time you create an instance of a repository and not create a DataContext for every method call like in the example.

It's been a while, but I believe that L2S does offer a "disconnected" data mode where you can query the context for data but the entities returned are automatically detached from the context. This then enables you to edit and then attach them back to your repository in a new data context. Of course, you'll lose all your change tracking so your update will update all the fields rather than just the ones that have changed.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.