Update SQL record without retrieving from the database

Question

I'm using LINQ to SQL. I have an object with an ID property and I want to update it on the database. The object is outside the context. I don't want to get the object again from the DB and then go over all the properties one by one and update them. Can I do that? How?

Answer 1

Use Table.Attach Method.