I'm facing some problem when trying to get some refreshed data that was changed out of the current session.

Let me try to explain it better.

I have a WinForm app designed at MVC pattern and keep only one nhibernate session opened per instance of app, through Singleton.

At View, I have a main form, from where I call other ones. Then imagine a simple form, with only a DataGridView showing a list of a very simple object, that is a DTO representing a very simple table from the database with two columns (ID and Description). The DataGridView is populated in the Form_Load Event.

When I open the app the first time and call that form, everything is ok, I can see all the data just fine.

But if I change some data of this table in another instance of the app, or even if I do an UPDATE directly in the database console, I can't see the data refreshed in the first instance.

The most curious is that when I do an INSERT at the table in different instances of the app, then I can see the new record at both instances, the problem occur only when some record is updated.


Have anyone ever faced the same situation??? How could I fix it???



P.S: Sorry about my poor english, I'm not a native speaker.