Sorry, i could not find anything useful on how to specify the query- space:
How do i do that exactly? On 22 Sep., 15:33, Fabio Maulo <[email protected]> wrote: > for SQL and/or H-SQL queries you should specify the query-space > sync.<synchronize > table="YourTable"/> > > 2009/9/22 merrycoder <[email protected]> > > > > > > > Hi there, > > > I have an issue with the following sql query: > > > // query the user's with static value 'foo' as Name: > > > IList<User> list = nhibernateSession.CreateSQLQuery("select 'foo' as > > {us.Name} from User us").AddEntity("us", typeof(User)).List<User>(); > > > foreach (User u in list) > > Debug.WriteLine(u.Name); // Output is 'foo'. Correct! > > > // Overwrite the Name in cache > > foreach (User u in list) > > u.Name = "bar"; > > > // Rerun the same query > > list = nhibernateSession.CreateSQLQuery(sql).AddEntity("us", typeof > > (User)).List<User>(); > > > foreach (User u in list) > > Debug.WriteLine(u.Name); // Output is 'bar'; Wrong IMHO! > > > I would expect the Name to be 'foo' as it is overwritten in the query. > > Any ideas on how to handle this without clearing the cache? > > > Thanks > > > Stefan Landgraf > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
