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.