You are implementing an application that uses LINQ to SQL. You load an Order entity by querying the Orders property of a strongly typed DataContext. After you modify the Order entity, you need to retrieve an instance with properties reset to the values in the database.

What should you do?

Call the Refresh method of the DataContext and then query the Orders property to refresh the ObjectContext with data from the database. This updates objects in the object context with data from the data source.

Retrieving the entity by querying the GetTable method on the DataContext returns the cached value. It does not update from the data source.