* the ExecuteQuery() line hit just once, when the page is loaded at the very first time...later on, whenever I click Refresh button that line doesnt get hit......the same stary when i click the link that leads to that page...Im wondering where it takes data from to display on the page?
* where can I check whether that 2nd level NHibernate cache is set up ? * usually the data is changed with ActiveRecord, I used DeletAll(where condition) method to delete a record...I did that but it still was on the page while it got removed from database table On 2 Lis, 23:41, Mauricio Scheffer <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
