我有3张桌子:
Module_Articles_Articles Module_Articles_Categories Module_Articles_Comments
我想在转发器中显示我的文章我的查询:
var articles = (from a in context.Module_Articles_Articles join c in context.Module_Articles_Categories on a.CategoryID equals c.CategoryID join co in context.Module_Articles_Comments on a.ArticleID equals co.ArticleID where a.IsDraft == false orderby a.ArticleID descending select new { a.ArticleID, a.ArticleTitle, a.ArticleContent, a.Image, a.Sender, a.SentDate, a.Summary, a.Likes, a.Dislikes, a.Tags, a.PostMode, c.CategoryID, c.CategoryTitle, AcceptedCommentsCount = (from com in context.Module_Articles_Comments where com.ArticleID == a.ArticleID && com.Status select com) .Count(), DeniedCommentsCount = (from com in context.Module_Articles_Comments where com.ArticleID == a.ArticleID && com.Status == false select com) .Count() }).ToList();
但当Module_Articles_Categories
或Module_Articles_Comments
为空时,我的查询什么也没有返回!我的代码是真的吗?如果不是我怎么能这样做?