Heh, damn! behind the scenes, it is doing Count(id) which seems to cause issues.
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, Jul 27, 2009 at 10:28 PM, Fernando Zago <[email protected]> wrote: > Can someone help me with it ? > > i have an class (City) that uses a System.Guid (GUID.COMB) identifyer. > and when i'm trying to count that rows, that exception was thrown > > Server: Msg 409, Level 16, State 2, Line 4 > The count aggregate operation cannot take a uniqueidentifier data type as > an argument. > > User has a list of cities. > > public class User > { > public virtual IList<City> Cities { } > } > > > var query = from u in session.Linq<User> where u.Cities.Count > 1 select u; > > I'm Using NHibernate.Linq + NHibernate 2.1.0.4000 > > --- > Vision without action is a waking dream. Action without vision is a > nightmare. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
