WCF and SQL Server: changes in DB are displayed only after app restarts

I'm de开发者_C百科veloping a client-server app using WCF and Linq2Sql. My server-side program exposes to the clent an interface that provides methods of reading from and writing to my SQL Server DB. But when the client writes some date into DB, perhabs waites some time, and then tries to read that data from DB, it seems like no data has been written to DB, but if I restart my server-side app or perform DB detaching and reataching or restarting of sqlserver-service, then my client-side program can get that data from server-side program. Does anyone have any idea what's wrong with my app (server?) and how to fix this?

UPDATE: I'm using Linq2Sql (calling CataContext.SubmitChanges()).

UPDATE 2: I've discovered, than if I add some new rows into my table, all is correct, but when I'm updating some pieces of row (some properties of objects) and then save changes, the changes become displayed only after reconnection to DB. It appears not to have flushed data immediatly after updating some properties and invocation of DataContext.SubmitChanges().

I don't have an answer, but some ideas for how to further track down the issue. How do you write to the DB? Do you use transactions, that maybe remain open? Can you query the updates in the database when they don't show up in your WCF response? Does your update maintain locks and somehow not release them? Did you eliminate caching as the cause?

Try remote-debugging to find out what happens on the server. A WCF trace might be helpful, too.