Converting Sql Union Query to Linq

Aniket Narvankar

How to convert following sql query to linq

SELECT top 1 Id, Name, Address,refNbr FROM tbl1
WHERE Name is not Null and refNbr='abc123'
Union
select l.Id,a.FirstName a.ResidenceAddress1, l.refNbr from tbl2 l, tbl3 a,
tbl4 b where b.auto = 1 and
l.Id = b.Id and l.Id = a.Id and l.refNbr = 'abc123'

Please do let me know how to convert this sql query written using union into linq in c sharp

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari4y ago
You can do in this way:
//for first query
Var data1 = (from tb1 dbContext.tbl1
                     .where tb1.Name != null && refNbr ='abc123'
                     .select new { tb1.Id, tb1.Name, tb1.Address,
                      tb1.refNbr})..FirstOrDefault();

Var data2 = (from tb2 dbContext.tbl2
                     .where
                     .select new { tb1.Id, Name = tb1.FirstName, Address =
                      tb1.ResidenceAddress,
                      tb1.refNbr})..FirstOrDefault();

var FinalData = data1.Union(data2).ToList();
In union, we need to make sure that both queries have same columns.
+2
milton pils4y ago
mobile app development services https://syndicode.com/mobile-application-development/ are perfect for businesses that need a highly-skilled software team. A Ukrainian team is likely to have an education in STEM, and they can operate with various technologies and programming languages. Some of the top languages used by Ukrainian software developers are Java, Ruby, and Typescript. The cost of hiring a Ukrainian software team is less than half that of a US company. The cost of maintaining an office in Ukraine is approximately $500 per month.
+1
Muhammad Imran Ansari4y ago
Union will merge but remove duplicates (distinct). For more information please follow the link to mold your query accordingly:

https://stackoverflow.com/questions/2744205/how-to-convert-sql-union-to-linq
+1