I think this is fixed in NH 3.2 (to be released shortly). [NH-1090] - Query cache does not work when using Criteria API to create a projection query with a result transformer
Craig On Mon, Jul 25, 2011 at 3:59 AM, fel0niousmonk <[email protected]> wrote: > I'm getting the following error: > > System.InvalidCastException occurred > Message=Unable to cast object of type > 'AEGISweb.Data.Entities.TechSupportCallback' to type > 'System.Object[]'. > Source=NHibernate > StackTrace: > at NHibernate.Cache.StandardQueryCache.Put(QueryKey key, > ICacheAssembler[] returnTypes, IList result, Boolean > isNaturalKeyLookup, ISessionImplementor session) > InnerException: > > with a query + projection like: > > // open session & transaction in using (..) > // only return the properties we want! > var query = session.CreateCriteria<TechSupportCallback>() > .SetCacheable(true) > .SetCacheRegion("CallbacksByUserAndGroups") > .SetProjection(Projections.ProjectionList() > .Add(Projections.Alias(Projections.Id(), ex.NameOf(x => > x.ID))) // > .Add(Projections.Alias(Projections.Property(ex.NameOf(x => > x.ContactID)), ex.NameOf(x => x.ContactID))) > // ... > ) > .SetResultTra...; > rValue = query.List<TechSupportCallback>(); > > -- > 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. > > -- 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.
