Concat 2 filtered results

Question

I have NH query

result = Session.Query<s>()
.Include(s => s.a)
.Include(x => x.b)
.Include(x => x.c);

and I have two filtered results

IQueryable<s> r1 = result.Where(x => x.c.Any(a => a.Id == "value"));
IQueryable<s> r2 = result.Where(x => x.d.Any(a => a.Id == "other"));

And I want to have

IQueryable<s> r1.Union(r2)

Or

IQueryable<s> r1.Concat(r2).Distinct()

So far everything ok, code compile and run, but in run time I got error:

The ConcatResultOperator result operator is not current supported

How to concat this two results without lose NHibernate query context. I know I can cast to list and concat lists but I want still IQuerable.

Mohamed Elrashid · Accepted Answer · 2019-01-17T17:04:50.443

0

more :

edited Jan 17 '19 at 17:04

answered Jan 17 '19 at 16:55

Mohamed Elrashid

Note that relevant issues are now at Github: https://github.com/nhibernate/nhibernate-core/issues/937 and https://github.com/nhibernate/nhibernate-core/issues/867 – Oskar Berggren Jan 24 '19 at 01:04

1 Answers1