How convert sql query to linq-to-sql

Question

I have Sql query:

SELECT News.NewsId, News.Subject, Cm.Cnt FROM dbo.News
LEFT JOIN 
(SELECT Comments.OwnerId, COUNT(Comments.OwnerId) as Cnt 
 FROM Comments 
 WHERE Comments.CommentType = 'News' 
 Group By Comments.OwnerId) Cm
ON Cm.OwnerId = News.NewsId

But I want linq-to-sql query, how I can convert this to linq?

What do you have so far?

bkaid
– bkaid

2010-06-02 20:36:51 +00:00
Commented Jun 2, 2010 at 20:36 — bkaid
– bkaid, Commented Jun 2, 2010 at 20:36

DOK · Accepted Answer · 2010-06-02 20:36:16Z

2

You might find it helpful to download LinqPad, which will make it extremely easy to write LINQ and test it. It will also help you learn the syntax. Awesome tool. And it's free.

answered Jun 2, 2010 at 20:36

DOK

32.8k8 gold badges64 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amy B · Accepted Answer · 2010-06-02 20:40:12Z

1

how I can convert this to linq?

Practice! :)

from news in News
let count = news.Comments
  .Where(comment => comment.CommentType == "News")
  .Count()
select new {news.NewsId, news.Subject, Count = count};

answered Jun 2, 2010 at 20:40

Amy B

110k21 gold badges140 silver badges191 bronze badges

Collectives™ on Stack Overflow

How convert sql query to linq-to-sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related