No, I mean HQL. Look at the first example in http://nhforge.org/doc/nh/en/index.html#queryhql-where
Diego On Thu, Apr 1, 2010 at 18:59, Paco Wensveen <[email protected]> wrote: > I didn't know that. Isn't it HSql what you mean, that returns object > arrays instead of entities? When it's implemented in hql, it will > probably implemented in linq in the future (Not sure again). > > On Thu, Apr 1, 2010 at 11:37 PM, Diego Mijelshon <[email protected]> > wrote: > > That's not correct. You can easily query unrelated entities in HQL, just > > like in SQL. > > Of course it's a lot easier when they ARE related, and there aren't many > > valid reasons NOT to create the relationships... > > > > Diego > > > > > > On Thu, Apr 1, 2010 at 18:32, Paco Wensveen <[email protected]> wrote: > >> > >> As far as I know (but I can be wrong) joins between unrelated entities > >> are not implemented in hql, or any other part of NHibernate. So the > >> options are: > >> - Create a relation between the entities > >> - Use a sql query (with NHibernate) > >> - Use a different orm that supports what you want. > >> > >> This is probably not the answer you would like to get, so I wonder why > >> you don't use a reference from SSObject to OtherObject in the code? > >> > >> Paco > >> > >> On Thu, Apr 1, 2010 at 11:21 PM, rboarman <[email protected]> wrote: > >> > 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]<nhusers%[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]<nhusers%[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]<nhusers%[email protected]> > . > >> > For more options, visit this group at > >> > http://groups.google.com/group/nhusers?hl=en. > >> > > >> > > >> > >> -- > >> 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]<nhusers%[email protected]> > . > >> For more options, visit this group at > >> http://groups.google.com/group/nhusers?hl=en. > >> > > > > -- > > 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]<nhusers%[email protected]> > . > > For more options, visit this group at > > http://groups.google.com/group/nhusers?hl=en. > > > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
