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