HQL supports left joins with the condition in the join. You might want to
switch query methods...
Diego
On Wed, Aug 18, 2010 at 17:13, Francois Ward <[email protected]>wrote:
> That works for inner joins, but when LEFT joins are involved, it won't if i
> understand correctly. The condition is in the where clause, not in the join,
> when you do this. Same result for INNER JOIN, but you'll be missing rows
> with LEFT OUTER JOIN.
>
>
> On Wed, Aug 18, 2010 at 2:31 PM, John Davidson <[email protected]>wrote:
>
>>
>> session.CreateCriteria(typeof(MyParentTable))
>> .CreateAlias("MyChildTable", "children")
>> .Add(Expression.Eq("children.IsMain", 1)).List()
>>
>> John Davidson
>>
>> On Wed, Aug 18, 2010 at 2:12 PM, Mike <[email protected]> wrote:
>>
>>> Can you show an example of how to create an alias on a subset of
>>> MyChildTable? That's what I'm really after.
>>>
>>> On Aug 18, 12:42 pm, John Davidson <[email protected]> wrote:
>>> > Then a detached criteria or an alias for MyChildTable in a criteria
>>> query
>>> > would work
>>> >
>>> > John Davidson
>>> >
>>> >
>>> >
>>> > On Wed, Aug 18, 2010 at 12:28 PM, Mike <[email protected]> wrote:
>>> > > Sorry, forgot to mention that.
>>> >
>>> > > Parent can have many children. The mapping is a one to many, is
>>> > > completed, and works. I was trying to optimize a few of my queries.
>>> >
>>> > > On Aug 18, 11:09 am, John Davidson <[email protected]> wrote:
>>> > > > What are your mappings for MyParentTable and MyChildTable? Have you
>>> > > mapped
>>> > > > an association in either or both of them?
>>> >
>>> > > > John Davidson
>>> >
>>> > > > On Wed, Aug 18, 2010 at 11:42 AM, Mike <[email protected]>
>>> wrote:
>>> > > > > Hello,
>>> > > > > I am trying to emulate the following SQL statement in Criteria
>>> API:
>>> >
>>> > > > > SELECT ...
>>> > > > > FROM MyParentTable parent
>>> > > > > INNER JOIN MyChildTable child ON (child.ParentID = parent.ID
>>> AND
>>> > > > > child.IsMain = 1)
>>> >
>>> > > > > Is this something I would want to used DetachedCriteria for, or
>>> is
>>> > > > > there a more direct way?
>>> >
>>> > > > > Thanks!
>>> >
>>> > > > > --
>>> > > > > 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]>
>>> <nhusers%[email protected]<nhusers%[email protected]>>
>>> > > <nhusers%[email protected]<nhusers%[email protected]>
>>> <nhusers%252bunsubscr...@googlegroup s.com>>
>>> > > > > .
>>> > > > > 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]>
>>> <nhusers%[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.
