Sorry, my bad. You may use subquery to query about its child. On Tue, Oct 7, 2008 at 8:58 AM, Jon Palmer <[EMAIL PROTECTED]>wrote:
> I'm not sure that's what I need. Restrictions.In has the pseudo signature > > > > Restrictions.In (mappedProperty, collectionOfParams) > > > > Whereas the HQL elements query allows you to do the 'inverse' which is: > > > > Restrictions.In(param, mappedCollection) > > > > I'm not seeing anything in Restrictions that supports the second case. > > > > > > *From:* [email protected] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Tuna Toksöz > *Sent:* Monday, October 06, 2008 10:52 PM > > *To:* [email protected] > *Subject:* [nhibernate-development] Re: FW: [nhusers] Re: Criteria > querries and collections > > > > crt.Add(Restrictions.In()) > > On Tue, Oct 7, 2008 at 8:10 AM, Jon Palmer <[EMAIL PROTECTED]> > wrote: > > I'm not sure I understand. Yes I could write the query using HQL like this: > > > > Session.CreateQuery("from Person p where '[EMAIL PROTECTED]' in elements > (p.EmailAddresses)").List() > > The question is how do you perform the same query using the Criteria API? > > > > Jon > > *From:* [email protected] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Fabio Maulo > *Sent:* Monday, October 06, 2008 9:05 PM > > > *To:* [email protected] > *Subject:* [nhibernate-development] Re: FW: [nhusers] Re: Criteria > querries and collections > > > > in elements > > 2008/10/6 Tuna Toksöz <[EMAIL PROTECTED]> > > No, it is not. > > > > On Mon, Oct 6, 2008 at 7:27 PM, Tuna Toksöz <[EMAIL PROTECTED]> wrote: > > Session.CreateQuery("from Person p join p.EmailAddresses e where e = ' > [EMAIL PROTECTED]'").List() > > this may be possible, i am not sure. Let me check > > > > On Mon, Oct 6, 2008 at 7:18 PM, Jon Palmer <[EMAIL PROTECTED]> > wrote: > > Shame. I would have thought that collections and composite entities would > actually be easier than mapped objects right? > > > > *From:* [email protected] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Tuna Toksöz > *Sent:* Monday, October 06, 2008 9:15 AM > *To:* [email protected] > *Subject:* [nhibernate-development] Re: FW: [nhusers] Re: Criteria > querries and collections > > > > No it is not supported in criteria. i am thinking about what can be hard. I > don't think there is a jira issue so feel free to create a issue. > > On Mon, Oct 6, 2008 at 7:01 PM, Jon Palmer <[EMAIL PROTECTED]> > wrote: > > I figured the dev list might be a better place to ask this. Is there a Jira > issue for this and if so what is hard about the fix? > > > > Thanks > > Jon > > > > P.S. In HQL you can also do this: > > > > Session.CreateQuery("from Person p where p.EmailAddresses[0] = ' > [EMAIL PROTECTED]'").List() > > > > Is there an equivalent using the Criteria API? > > > > *Jon Palmer* > Senior Software Engineer, Contact Networks* > *35 Thomson Place T3 | Boston, MA 02210 > O: 617.856.1836 | M: 415.269.1862 > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Brian Chavez > *Sent:* Monday, October 06, 2008 3:18 AM > *To:* [EMAIL PROTECTED] > *Subject:* [nhusers] Re: Criteria querries and collections > > > > I think I tried doing this very same thing a few days ago, only with > <.composite-element.> mappings. > > > > From what I found, the answer is no, I had to promote the element to a > first class POCO in order to do some querying with Criteria API. > > > > I may be wrong, though, so wait for others to weight in. > > > > -Brian > > > > > > > ---------------------------------------------- > Brian Chavez > Bit Armory, Inc. > http://www.bitarmory.com > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Jon Palmer > *Sent:* Monday, October 06, 2008 2:30 AM > *To:* [EMAIL PROTECTED] > *Subject:* [nhusers] Criteria querries and collections > > > > Is the first item of 'Advanced Problems' on > http://www.hibernate.org/117.html still true or do recent versions of > NHibernate support querying collections though the Criteria API? > > > > > > I have a simple situation like this: > > > > Class Person > > { > > IList EmailAddresses {get; set;} > > } > > > > > > The Email addresses are mapped as simple strings like this: > > > > <class name="Person"/> > > <list name="EmailAddresses" table="PersonEmailAddresses" lazy=" > > > <key column="PersonID"/> > > <index column="DisplayOrder"/> > > <element column="EmailAddress" type="string"/> > > </list> > > </class> > > > > In HQL I can do a query on the email Addresses like this: > > > > Session.CreateQuery("from Person p join p.EmailAddresses e where e = ' > [EMAIL PROTECTED]'").List() > > > > Is there an equivalent using the Criteira API? I've tried a number of > things but they all break in some shape or form. > > > > Thanks > > Jon > > > > *Jon Palmer* > Senior Software Engineer, Contact Networks* > *35 Thomson Place T3 | Boston, MA 02210 > O: 617.856.1836 | M: 415.269.1862 > > [image: ThomsonReuters] > > *Contact Networks, a Thomson Reuters company, is the global leader of B2B > social networking for professionals.* > > > > > > > > > > > > > > > -- > Tuna Toksöz > > Typos included to enhance the readers attention! > > > > > -- > Tuna Toksöz > > Typos included to enhance the readers attention! > > > > > -- > Tuna Toksöz > > Typos included to enhance the readers attention! > > > > > -- > Fabio Maulo > > > > > -- > Tuna Toksöz > > Typos included to enhance the readers attention! > -- Tuna Toksöz Typos included to enhance the readers attention!
<<image001.gif>>
