Question

Linq to SQL，三表联合查询，结果包含三个表的混合数据，如何获得记录总数？

语句如下，我知道目前的结果和News表的记录数一样，但是加上条件筛选后如何获得查询结果的记录总数？
public IQueryable FindAllNews()
{
return from n in db.NewsModel
join b in db.BigClassModel on n.BigClassID equals b.BigClassID
join s in db.SmallClassModel on n.SmallClassID equals s.SmallClassID
orderby n.AddTime descending
select new
{
n.NewsID,
n.BigClassID,
n.SmallClassID,
n.Title,
b.BigClassName,
s.SmallClassName,
};
}

Answer 1

var q= from n in db.NewsModel
join b in db.BigClassModel on n.BigClassID equals b.BigClassID
join s in db.SmallClassModel on n.SmallClassID equals s.SmallClassID
orderby n.AddTime descending
select new
{
n.NewsID,
n.BigClassID,
n.SmallClassID,
n.Title,
b.BigClassName,
s.SmallClassName,
};
return q.ToList();
q.Count()//这个就是记录总数