It's not in the mapping. I am trying to create an arbitrary query. This works fine in Linq2SQL and LLBLGen.
In summary, does this mean we can only create inner joins when there is a FK relationship in place? If so, am I better off using an HQL query? Rick On Apr 1, 2:15 pm, Paco Wensveen <[email protected]> wrote: > I mean this a reference in the classes and mappings: > > public class SSObject > { > public OtherObject Row {get;} > > } > > var q = from sso in session.Linq<SSObject>() > where ot.TargetId == someId > select sso; > > I guess the join method in NHibernate is not implemented because > relations between tables are handled by the mapping already, and there > is a join is never needed when you use it in the mapping. > > > > On Thu, Apr 1, 2010 at 10:45 PM, rboarman <[email protected]> wrote: > > 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 > > 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.
