views:

361

answers:

1

I'm using the current Linq provider for NHibernate (version 2.1).

I have two entities: VideoGame and GameDeveloper, with a many-to-one relationship between them. I'm trying to perform a query of this sort, which counts the number of video games each game developer has:

from v in session.Linq<VideoGame>()
group by v.Developer into developerGroup
select new {developerGroup.Key.Name, Count = developerGroup.Count()}

Enumerating this query causes an exception - "could not resolve property Key of Entities.VideoGame". Now, if I group by v.Developer.Id it works, but I can't select the Name column and show it in the results. I could group by v.Developer.Name, but it doesn't seem right, as two developers might have the same name.

I know the current Linq provider is not being developed any more, but would appreciate any advice on the situation.

+1  A: 
Jonas Elfström
Also doesn't work.
Doron Yaacoby
Be aware that the brute force above gets all videogames from the database.
Jonas Elfström
at least working for now +1
Orkun Balkancı