相当于Sql查询的Linq
相当于Sql查询的Linq
提问于 2018-10-31 07:45:52
SQL查询-
select q.QuesId, q.Title, q.Description, count(a.QuesId) as Answers
from Question q
join Answer a on q.QuesId = a.QuesId
group by q.QuesId, q.Title, q.Description我想将这个Sql查询转换为linq。
我的方法是-
var questions = (from q in db.Questions
join a in db.Answers on q.QuesId equals a.QuesId
group q by new
{ q.QuesId, q.Title, q.Description, q.AskedBy, q.AskedOn, q.ModifiedOn }
into x
select new
{ x.Key.QuesId, x.Key.Title, x.Key.Description, x.Key.AskedBy, x.Key.AskedOn, x.Key.ModifiedOn, x.key.Answers.count }
).ToList();它似乎不起作用。
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-10-31 11:36:15
这就是我最后做的对我有用的事-
var questions = db.Questions
.GroupJoin(db.Answers, q => q.QuesId, a => a.QuesId, (q, a) => q)
.GroupBy(q => new { q.QuesId })
.SelectMany(x => x.Select(q => new
{ q.QuesId, q.Title, q.Description, q.UserDetail.FirstName, q.UserDetail.LastName, q.AskedOn, q.ModifiedOn, q.Answers.Count }
)).Distinct();页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/53078542
复制相关文章
相似问题
腾讯云开发者
