How to explain this SQL CE behaviour - not updating
===

I have WinForm application am building and am using SQL Compact Edition 3.5.

Whenever I run the WinForm application and I have a query editor open in Visual Studio afterwards, any update query I run does not reflect in the application. If I run `Select` query to view the updated records, I could see from the query result that the data has changed but does not reflect in the application.

If I close the application and run it again the updates reflects in the application.

Is this normal? What is the best explanation for this?