What? This is the sql I am trying to replicate: select * from SSObject inner join OtherObject on SSObject.OtherObjectId = OtherObject.RowId where OtherObject.TargetId= 98
Thanks, Rick On Apr 1, 11:44 am, Paco Wensveen <[email protected]> wrote: > By creating a reference in from one to another in the SSObject or OtherObject? > > > > On Thu, Apr 1, 2010 at 7:23 PM, rboarman <[email protected]> wrote: > > Hello, > > > It’s unclear from this site and from Google searches whether > > nHibernate’s implementation of Linq supports joins or not. > > > In my case, I want to do a VERY simple join. > > > var q = from sso in session.Linq<SSObject>() > > join ot in session.Linq<OtherObject>() on sso.OtherObjectId > > equals ot.RowId > > where ot.TargetId == someId > > select sso; > > > This gives me an error of “Cannot resolve method Join.” > > > I have tried a couple different version of the dll. Right now I am > > using 1.1.0.1001. > > > Any suggestions on how I can get this to work? > > > Rick > > > -- > > 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 > > athttp://groups.google.com/group/nhusers?hl=en.- Hide quoted text - > > - Show quoted text - -- 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.
