Diego, Use List<object[]> and map DTO is more performative than SetResultTransformer ?
On Wed, Oct 20, 2010 at 3:27 PM, Diego Mijelshon <[email protected]>wrote: > Workaround: instead of the ResultTransformer use List<object[]> and map the > DTO using LINQ to objects > .Select(x => new HouseDto{ HouseName = (string)x[0] ... }) > > Diego > > > > On Wed, Oct 20, 2010 at 01:46, Quooston <[email protected]> wrote: > >> Hi, >> >> I have a DTO which I am trying to map to by means of the >> AliasToBeanResultTransformer. >> >> All works as expected until I try to utilize the second level cache >> with SetCacheable(true): >> >> houseDtos = newSession.CreateCriteria<House>() >> .SetCacheable(true) >> .SetCacheMode(CacheMode.Get | CacheMode.Put) >> .CreateAlias("Rooms", "r", JoinType.LeftOuterJoin) >> .SetProjection(Projections.ProjectionList() >> .Add(Projections.Id(), "Id") >> >> .Add(Projections.Property("HouseName"), >> "HouseName") >> >> .Add(Projections.Property("r.RoomName"), >> "FirstRoomName") >> ) >> >> .SetResultTransformer(Transformers.AliasToBean(typeof(HouseDto))) >> .List<HouseDto>(); >> >> which results in: >> >> NHibernate.Exceptions.GenericADOException : Unable to perform >> find[SQL: SQL not available] >> ----> System.InvalidCastException : Unable to cast object of type >> 'Leica.Bond.Server.Core.IntegrationTests.HouseDto' to type >> 'System.Object[]'. >> >> What can I do to have the second level cache play nice with the above? >> >> Thanks in advance for any input provided. >> >> Cheers >> >> -- >> 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. >> >> > -- > 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. > -- ______________________________________ Felipe B. Oriani @felipeoriani <http://www.twitter.com/felipeoriani> | felipeoriani.com.br | [email protected] "...Trabalhe quanto puder, tornando-se útil quanto possível..." , por André Luiz -- 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.
