Your current FlushMode affects this behavior as well. FlushMode.Auto should cause the update to happen before the select.
/Oskar 2010/3/24 Robert Rudduck <[email protected]>: > Depending on how abstracted your NH usage is, you could call flush after the > update, which would force the update to fire. Then the selects afterward > would return the right results. > > - Robert > > On Wed, Mar 24, 2010 at 10:29 AM, Sal <[email protected]> wrote: >> >> Yes, indeed. >> >> On Mar 24, 11:27 am, Oskar Berggren <[email protected]> wrote: >> > More specifically, to you mean "rebind" after the entity have been >> > updated? >> > >> > /Oskar >> > >> > 2010/3/24 Sal <[email protected]>: >> > >> > > It needs to select to bind the entities to the view. >> > >> > > On Mar 24, 11:07 am, Oskar Berggren <[email protected]> wrote: >> > >> You speak of updating and saving an entity. Why is there a select >> > >> there at all? I think you need to explain more about how your code >> > >> works. >> > >> > >> /Oskar >> > >> > >> 2010/3/24 Sal <[email protected]>: >> > >> > >> > I have a weird issue in a WebForms app that is using session per >> > >> > request. On a certain screen we update some fields, update the >> > >> > entity >> > >> > and then save it. The problem occurs if we set an entity to not >> > >> > active. The select queries exclude entities that are not active. >> > >> > So, >> > >> > looking at NH profiler, the select statements are executed first, >> > >> > and >> > >> > then the update is executed at the end. So, the select is still >> > >> > pulling back the inactive entity because the update hasn't executed >> > >> > yet. Does this make any sense? The order of the SQL statements is >> > >> > what >> > >> > is causing the issue. More likely I am not doing something >> > >> > correctly >> > >> > with NH. ;) >> > >> > >> > Any ideas? >> > >> > >> > -- >> > >> > You received this message because you are subscribed to the Google >> > >> > Groups "nhusers" group. >> > >> > To post to this group, send email to [email protected]. >> > >> > To unsubscribe from this group, send email to >> > >> > [email protected]. >> > >> > For more options, visit this group >> > >> > athttp://groups.google.com/group/nhusers?hl=en. >> > >> > > -- >> > > You received this message because you are subscribed to the Google >> > > Groups "nhusers" group. >> > > To post to this group, send email to [email protected]. >> > > To unsubscribe from this group, send email to >> > > [email protected]. >> > > For more options, visit this group >> > > athttp://groups.google.com/group/nhusers?hl=en. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/nhusers?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
