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

Suthish Nair · Answer

Good accept the post as answer that helped you.

kieky bouvier · Answer

thx suthish for your link.. yeah finally i've got the answer.. 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' .

Suthish Nair · Answer

http://msdn.microsoft.com/en-us/vcsharp/aa336746