A few questions: * If you set a breakpoint on the ExecuteQuery() line, do you hit this breakpoint when fetching the "cached" data? * Do you have any 2nd level NHibernate cache set up? * How is the data changed normally (i.e. not manually with SQL mgm studio) in background? Is it changed with ActiveRecord/NHibernate? raw ADO.NET? another process?
On Nov 2, 6:18 pm, Paweł <[email protected]> wrote: > I use the following piece of code to fetch data from database. This > code is called from javascript by proxy (AjaxAction). > > The problem is that the page once loaded doesn't show updated/deleted > records (after refresh of course), even they have been changed in > background (using ie. sql managment studio). It seems like data is > cached somewhere. What can I do in order to get data refreshed > everytime I call the following code? > > string sql = @" > SELECT > address.CityId.Name, address.StreetId.Name, > address.StreetNumber, place.Numer, > place.Opis, parking.Opis, place.Id, category.Name , > place.UzytkownikId.Login, place.ParkingId.Id > FROM > PParking parking JOIN parking.MiejscaPostojowes place JOIN > parking.AddressId address > JOIN place.CategoryId category > WHERE > place.UzytkownikId.Id = :userId > GROUP BY > address.CityId.Name, address.StreetId.Name, > address.StreetNumber, place.Numer, > place.Opis, parking.Opis, place.Id, > category.Name,place.UzytkownikId.Login, place.ParkingId.Id > "; > > SimpleQuery query = new SimpleQuery(typeof(PMiejsce), typeof > (object), sql); > > DateTime currentTime = DateTime.Now; > query.SetParameter("userId", userId); > > return (object[])ExecuteQuery(query); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
