what about
from f in context.Session.Linq<Floor>()
select new
{
Id = f.Id,
Name = f.Name,
BuildingId = f.Building.Id,
BuildingName = f.Building.Name
}
The properties having the same name might be tripping it up.
On Aug 7, 8:42 am, Tuna Toksoz <[email protected]> wrote:
> It should work, i wonder if it directly corresponds to this
> from f in context.Session.Linq<Floor>()
> select new {f.Id,f.Name,f.Building.Id,f.Building.Name}
>
> Tuna Toksöz
> Eternal sunshine of the open source mind.
>
> http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike
>
> On Fri, Aug 7, 2009 at 6:19 PM, abm <[email protected]> wrote:
>
> > My model has a relationship between building and floor entities. Using
> > AR LINQ should I be able to run the following query:
>
> > Dim query = From f In context.Session.Linq(Of Floor)()
> > Select f.Id, f.Name, f.Building.Id, f.Building.Name
>
> > Dim results = query.ToList()
>
> > It doesn't seem to work as f.Building.Id and f.Building.Name require a
> > sql join from floor to building table. However, linq queries against a
> > single entity work great!
>
> > Better layout at:
> >http://stackoverflow.com/questions/1212564/linq-to-nhibernate-query-w...
>
> > -Abm
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
