How do I get Linq-to-SQL to refresh its local copy of a database record?

You can do it with the Refresh method on your data context, like so:

DataContext.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues,
                    DataContext.Orders);