Fabio, Hi! To request and install NH3 on my office pc is going to take at least 7 days. I don't have the bandwidth. Is there an alternate way of doing this?
Thanks! On Aug 19, 7:44 am, Fabio Maulo <[email protected]> wrote: > did you try with NH3 and the embedded linq provider ? > > > > > > On Wed, Aug 18, 2010 at 11:35 PM, Kasi <[email protected]> wrote: > > "cannot use subqueries on a criteria without a projection". This is > > the error message I am getting. Is there an alternate way of > > accomplishing this? I am OK to not us LINQ. > > > public Questionnaire Get(string countryCode, string languageCode) > > { > > using (ISession session = > > NHibernateHelper.OpenSession()) > > using (ITransaction transaction = > > session.BeginTransaction()) > > { > > try > > { > > return > > session.Linq<Questionnaire>() > > .Where(x => > > x.CountryCode == countryCode && > > x.LanguageCode > > == languageCode && > > > x.EffectiveDate < DateTime.Now && > > > x.ExpirationDate > DateTime.Now) > > .Where(x => > > x.Sections == x.Sections.Where(s => s.Section.LanguageCode == > > languageCode)).ToList() > > > .FirstOrDefault(); > > } > > finally > > { > > transaction.Commit(); > > } > > } > > } > > > -- > > 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.
