Iam uisng nhibernate(ICriteria) to retrieve data from repository table.
But when im changing the data in the table it is giving me sometimes the old data or the newly changed data.
I bet somehow it is still hitting the cache, but i have set lazy = false for that table in the mapping file and also commented out the second level cache properties.

Urgent Help needed.

Is it possible that the objects are still in the session (aka 1st level cache) ? It so try the clear the session first.