Thanks a lot abrakadabr. It looked promising but i am getting this
error

illegal syntax near collection: index [from
ITAssessments.Core.Domain.Industry industry where index
(industry.AllNames) = :lcid order by industry.AllNames]

do you have a clue?

On May 15, 5:17 pm, abrakadabr <[email protected]> wrote:
> from Industry industry
> where index(industry.AllNames) = :lcid
> order by industry.AllNames
>
> On 15 май, 06:03, Michal <[email protected]> wrote:
>
> > Hi,
>
> > I have the following mapping of my "Industry" object:
>
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
> >   <class name="Domain.Industry, Core" table="industry">
>
> >     <id name="ID" unsaved-value="0">
> >       <generator class="identity" />
> >     </id>
>
> >     <map name="AllNames"
> >       access="nosetter.camelcase-underscore"
> >       table="_dict_industry_name"
> >       cascade="all-delete-orphan">
> >       <key column="record_id"></key>
> >       <index column="culture_id" type="Int32"></index>
> >       <element column="translation" type="String"></element>
> >     </map>
>
> >   </class>
> > </hibernate-mapping>
>
> > Now I would like toqueryall Industries ordered by the element of a
> > given culture_id.
> > I am stuck here ... I think i am close with this, but it does not
> > work:
>
> > stringquery= "from Industry industryorderby industry.AllNames
> > [:lcid]";
> > IQuery q = NHibernateSession.CreateQuery(query);
> > q.SetParameter("lcid", DomainCulture.Current);
>
> > Thanks guys!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to