HI ALl,
i have one sql query which i need to rewrite in LINQ?
Can someone please help me ?
SELECT Publications.PublicationID, Publications.Name, Articles.Title,Publications.PublicationID,Articles.ArticleID,Subscriptions.EmployeeID
,(SELECT CASE WHEN ArticleReadUnread.EmployeeID = 2084 THEN ArticleReadUnread.ArticleID else 0 end) as 'ARTICLEREAD'
,(SELECT CASE WHEN BookmarkArticles.EmployeeID = 2084 THEN BookmarkArticles.ArticleID else 0 end) as 'BOOKMARKED'
,ArticleReadUnread.EmployeeID
,BookmarkArticles.EmployeeID
FROM Subscriptions
INNER JOIN
Publications ON Subscriptions.PublicationID = Publications.PublicationID
INNER JOIN
Articles ON Publications.PublicationID = Articles.PublicationID
LEFT JOIN
ArticleReadUnread ON Articles.ArticleID = ArticleReadUnread.ArticleID
LEFT JOIN
BookmarkArticles ON Articles.ArticleID = BookmarkArticles.ArticleID
WHERE (Subscriptions.EmployeeID = 2084) and Publications.PublicationID=1007
and publications.Enabled=1 and Articles.Enabled=1 and Articles.Published=1