var q1 = from p in Person
where whatever
select p.id;
var q2 = from p in Person
where whatever
select p.id;
var qC = from p in Person
where q1.Contains(p.id) || q2.Contains(p.id)
select p;
q1 and q2 will be used as subqueries when the SQL is formed.
/Oskar
2016-02-26 10:25 GMT+00:00 <[email protected]>:
> Hi all,
> is there a possibility to combine several IQueryable without execute the
> query?
>
> Pseudocode:
>
> var q1 = (IQueryable<Person>).....;var q2 = (IQueryable<Person>).....;
>
>
> var q = q1.Union(q2);
>
>
> or
>
> SELECT *
> FROM Table1
> WHERE id IN
> (Result ids of IQueryable1)
> OR
> (Result ids of IQueryable2)
>
> I achieved a solution by using Disjunction of Queryover. As result I need
> an IQueryable without the query has been executed. So a solution can also
> be if it is possible to convert IQueryover to IQueryable.
>
> Thanks in advance
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/nhusers.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
