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 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.
