Hi!

I have entity where are described calcualted formulas. The formula works fine on first time quering like from materialBalance mb;

If I change the data, sql profiler shows that sql is executed and data retrieaved, but formula property values won't be updated.

When I do session.Flush() and execute hql
Formula values will be updated. Also I noticed that by changing simple property value in database and requering will not update values.

But the sql server will execute the sql but values are not updated???

Is this a bug?

Hi,

I know this topic is old, but I have exactly the same issue, did you find a way to fix it?

Thanks