Linq To SQL caching VS multi-user application.

Question

We develop Win32 application that access to SQL 2005 database through Linq to SQL. The issue is when 2 users access to same record (View and Edit)… User 1 update record (DataContext.SubmitChanges()), User 2 will continue to see old information until he restart application. So, we would like to update context of user 2… The solution that appears right now is to call DataContext.Refresh to sync object with SQL table… We wondering if other solution exist ?

Thank you

Answer 1

I've noticed that Refresh can be really nasty depending on the data you've already grabbed from an entity, another solution is to reset the context you are using to a new instance.

context = new MyDataContext(ConnectionString);

This, at least in the scenarios where I am using it is less overhead and less DB calls.

Answer 2

Have you looked at the ObjectTrackingEnabled property of the datacontext. Try setting it to false? Ref: http://www.rocksthoughts.com/blog/archive/2008/01/14/linq-to-sql-caching-gotcha.aspx