NHibernate Linq - Duplicate Records

Posted by adegiamb on Stack Overflow See other posts from Stack Overflow or by adegiamb
Published on 2010-03-11T21:05:02Z Indexed on 2010/03/11 21:09 UTC
Read the original article Hit count: 199

I am having a problem with duplicate blog post coming back when i run the linq statement below.

The issue that a blog post can have the same tag more then once and that's causing the problem. I know when you use criteria you can do the followingcriteria.SetResultTransformer(new DistinctRootEntityResultTransformer());

How can I do the same thing with linq?

List<BlogPost> result = (from blogPost in _session.Linq<BlogPost>()
                         from tags in blogPost.Tags
                         where tags.Tag == tag && blogPost.IsPublished 
                            && blogPost.Slug != slugToExclude
                         orderby blogPost.DateCreated descending
                         select blogPost).Distinct()
                        .Skip(recordsToSkip).Take(pageSize).ToList();

© Stack Overflow or respective owner

Related posts about LINQ

Related posts about fluent-nhibernate