Hi, I have to search other multiple tables and union the results together. For example say I have the following: var search = "Temp"; var query1 = session.Query<Page>().Where(p => p.Name.Contains(search)).Select(p => p.Name); var query2 = session.Query<Category>().Where(c => c.Name.Contains(search)).Select(c => c.Name); var results = query1.Union(query2).Take(5); One solution is to execute each query individually and then do the union/concat in memory but this isn't efficient when a single query returns back thousands of results. I've done a search online and realized the Union operator is not supported ( https://nhibernate.jira.com/browse/NH-2710). I've done some extensions to the linq provider but nothing as complicated as this but I thought I would download the NHibernate source code and take a look. From my findings I see the linq provider uses the Remotion.Linq project. I'm not familiar with the project but I found the following blog post ( https://www.re-motion.org/blogs/mix/2012/10/12/re-linq-subquery-boundaries-after-groupby-union-and-similar-operators/) which would indicate that the Union operator is supported. I was wondering how hard it would be to enable it for NHibernate? If it's difficult then I guess I'll just scrap the idea and wait until one of you clever people implements it. Thanks Lee
-- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
