how to convert sql query to linq using C#?

Quote:

Linqer is a SQL to LINQ conversion tool. It helps learning LINQ and convert existing SQL statements.

var query=(from a in Subscriptions  INNER JOIN b in Publications on  a.PublicationID equals b.PublicationID inner join  c in Articles on b.PublicationID equals c.PublicationID  left join d in ArticleReadUnread on c.ArticleID equals d.ArticleID  LEFT JOIN e in
 BookmarkArticles ON c.ArticleID equals e.ArticleID WHERE    (a.EmployeeID = 2084) and b.PublicationID=1007 and b.Enabled=1  and c.Enabled=1 and c.Published=1
 
select new {b.PublicationID,   b.Name, c.Title,b.PublicationID,c.ArticleID,a.EmployeeID
           ,
(SELECT CASE WHEN d.EmployeeID = 2084 THEN d.ArticleID else 0 end) as 'ARTICLEREAD'
           ,(SELECT  CASE WHEN e.EmployeeID  = 2084 THEN e.ArticleID else 0 end) as 'BOOKMARKED'
           ,d.EmployeeID
           ,e.EmployeeID
}).ToList(); 

select r.actionitemid from actionitemmast r left join ActionItemResult ra

on r.actionitemid = ra.actionitemid

inner join MemberMast m on r.memberid = m.memberid

inner join MemberMast ma on r.assignfromid = ma.memberid

inner join project_member p on r.memberid = p.memberid

left join projectmast pa on p.projectid = pa.projectid

where (ra.ActionTaken like '%dipa%' or r.Description like '%dipa%'

or r.Task like '%dipa%' or m.First_name like '%dipa%' or ma.First_name like '%dipa%' or pa.projectname like '%dipa%')

group by r.actionitemid