Hello all,

I'm working on an application with (nhibernate v2.0.1.4000). Everything is going fine. I was able to
add a <version> property to my mapping file. So from now on I'm able to detect (external) changes to one of my
records.

But I still have a question about 'show the most recent data'.
Suppose I have two applications (A and B) using the same table.

- Application A and B are running.

- Application A is doing some modifications to the table X.

- When Application B queries the rows on the same table X it will put the data in it's cache... So from that point in time... Application B always
works on this cached version. When application A continues making changes to the content of table X these changes are not visible to Application B.

What is the best way to solve this issue? Do I need to use another caching-strategy? How do you solve issues like this?
For the moment I solve this issue by closing the session: Session.Close(). On the next query nHibernate will go fetch the most recent data from the database.
But I think this is not the correct way?

Hi,

Have you ever found a solution to this ? I am experiencing the same issue as to where a service (multiple actually) is running in the back and doing stuff on objects in the database. The Gui AND web application that use the same database don't see these changes unless i'm refreshing/evicting objects out of the cache all the time which is not the idea :s