Convert SQL to LINQ Query

Question

I am having the following SQL query and I want to have it in LINQ, I tried many things but I can't get it working.

Below is my SQL query.

SELECT     ST.Description, ST.STId, COUNT(SI.SIId) AS Expr1
FROM         BP INNER JOIN
                      MbrBP ON BP.BPId = MbrBP.BPId INNER JOIN
                      SI ON BP.BPId = SI.BPId RIGHT OUTER JOIN
                      ST ON SI.STId = ST.STId
WHERE     (BP.CountryId = 1) AND (BP.RegionId = 1) AND (MbrBP.MemberId = 1)
      AND (SI.IsActive = 1)
GROUP BY ST.Description, ST.STId
UNION 
SELECT      ST.Description, ST.STId, COUNT(SI.STId) AS Expr1
FROM         SI RIGHT OUTER JOIN
                      ST ON SI.STId = ST.STId
GROUP BY ST.Description, ST.STId  

Answer 1

You can try Linqer. It is an SQL-> LINQ converter. 

Or you can also try the LINQPad.

Using these sites, you can convert SQL->Linq.

Looking for SQL Tutorial? Sign up for the SQL Certification course to gain more knowledge on SQL.