Convert union all and Subquery SQL query to LINQ

Question

Any help to convert my below SQL to linq query?

SELECT *
FROM BaseCategory
WHERE
    Id = (SELECT ParentId FROM BaseCategory WHERE Id = 10)
UNION ALL
SELECT *
FROM BaseCategory
WHERE
    ParentId = (SELECT ParentId FROM BaseCategory WHERE Id = 10)

Possible duplicate of [SQL to LINQ Tool](http://stackoverflow.com/questions/296972/sql-to-linq-tool) — sagi, May 23 '16 at 06:42

Vishal Suthar · Accepted Answer · 2016-05-23T07:01:41.347

0

Here you go:

var query = (from c in db.BaseCategory 
            where c.Id = (From c1 in db.BaseCategory 
                          where c1.Id == 10 select c1.ParentId) 
            select c)
            .Concat
            (from c in db.BaseCategory 
            where c.ParentId = (From c1 in db.BaseCategory 
                                where c1.Id == 10 select c1.ParentId) 
            select c)

edited May 23 '16 at 07:01

answered May 23 '16 at 06:52

Vishal Suthar

17,013
3
59
105

why Concat, why not Union as expected by the OP – Mrinal Kamboj May 23 '16 at 10:40
Because `Concat` is the LINQ equivalent of `UNION ALL` in SQL. – Vishal Suthar May 23 '16 at 11:17

Convert union all and Subquery SQL query to LINQ

1 Answers1