how to using 'count'

Question

i have 2 table Topic and Comment.. TOPIC IdTopic TopicName CreatedOn CreatedBy COMMENT IdComment IdTopic(FK) Comment ReplayOn ReplayBy I want to count all comment where Comment.IdTopic == Topic.IdTopic cant u help me? i'm using Linq to sql and C# thx

Sam Hobbs · Answer

For the future please post a question only once at a time; there is no need to post a question in more than one forum.

kieky bouvier · Answer

Thx for your replay.. :) finally i've got the answer.. count all comment using linq sql and c# protected String GetCountComment(string IdTopic) { string value = String.Empty; DMSDataAccess db = new DMSDataAccess(); var comment = db.DMSDataContext.Comments.Where(p => Convert.ToString(p.IdTopic) == IdTopic); value = Convert.ToString(comment.Count()); return value; }

Sam Hobbs · Answer

Also see how to using 'count' .

John Penn · Answer

select count(*) from topic inner join comment on Comment.IdTopic = Topic.IdTopic (that's the sql solution)