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,