which is the reason because you want use Criteria ?
On Wed, Aug 11, 2010 at 9:24 AM, marek <[email protected]>wrote:
> Hello,
>
> I have following mapping:
>
> [code]
>
> <class xmlns="urn:nhibernate-mapping-2.2" name="Category"
> table="`Categories`">
> <id name="Id" type="System.Int32">
> <column name="Id" />
> <generator class="identity" />
> </id>
> <map cascade="all"
> name="Translations"
> table="CategoriesTranslations">
> <key column="CategoryId" />
> <index column="Language" type="System.String"/>
> <composite-element class="Translation">
> <property name="Name"/>
> <property name="Tooltip"/>
> </composite-element>
> </map>
> </class>
>
> [/code]
>
> and following HQL query:
>
> [code]
> var categories = _session.CreateQuery("from Category category " +
> "left join fetch
> category.Translations translations " +
> "where
> index(translations)=:language")
> .SetString("language", "en")
> .List<Category>();
> [/code]
>
> I would like to use ICriteria query instead od HQL but I have no idea
> what to use for "where index(translations)=:language" as restriction
> using CreateCriteria query.
>
> Thank you in advance.
> Marek
>
> --
> 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.
>
>
--
Fabio Maulo
--
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.
