Here is the scenario:
I have a winforms application using NHibernate. On startup, I populate the DataGridView with the results of the NHibernate query. This part is working fine. If I update an entry in this list and clear the session, the update takes in the database. After closing the form after updating, I call the method to retrieve the list of objects, to populate the DataGridView again, to get the changes, as well as to get any other changes that might have happened to someone else. The problem is that the updated record, NHibernate does not reflect the changes in the list that it gives me. When I insert or delete a record, everything works fine. Just when I update, I get this behavior. I narrowed it down to NHibernate with my caching mechanism. I cannot figure out how to extract NHibernate from the database, and not use the cache after the update. I posted on the NHibernate forums, but the suggestions they gave me didn't work. I said this and no one answered. I am not going to state that I tried if I do not do it right. If you respond with what I tried for sure, I will indicate it in the comments of your answer.
This is the code I use to retrieve the list:
public IList<WorkOrder> FindBy(string fromDate, string toDate) { IQuery query = _currentSession.CreateQuery("from WorkOrder wo where wo.Date >= ? and wo.Date <= ?"); query.SetParameter(0, fromDate); query.SetParameter(1, toDate); return query.List<WorkOrder>(); }
A session is passed to the class when it is built. I can also publish the mapping file, but I'm not sure if something is wrong with it, as everything else works. Has anyone seen this before? This is the first project I used NHibernate, thanks for the help.
source share