新闻组中的Total News

我有两个模型:

1. GroupNews

新闻

我想列出组新闻在视图的部分视图，并显示有多少新闻相关的组

in groupnews model:

public long GroupId { get; set; }
public string Name { get; set; }

in News Model

public long newsId { get; set; }
public string Title { get; set; }
public long GroupId { get; set; }

在控制器:

public ActionResult Index()
{
    var db = new ApplicationDbContext()
    var CountNews = from p in db.tbl_GroupNews
                    let cCount = (from c in db.tbl_News
                                  where p.GroupId== c.GroupId
                                  select c
                                 ).Count()
                    select new { GroupId= p.GroupId, coun = cCount }
    ViewBag.CountNews= CountNews.Count()}

和我的局部视图

@foreach (var item in Model){
<div class="info-box">
    <div class="info-box-content">
        <span class="info-box-text">@item.Name::count of news in this group </span>
        <span class="info-box-number">
         @ViewBag.CountNews
        </span>

    </div><!-- /.info-box-content -->
</div><!-- /.info-box -->}

 var db = new ApplicationDbContext()
var CountNews = db.tbl_GroupNews.News.Count();
ViewBag.Counter = CountNews;
and if you are not using lazy loading then can get by
var db = new ApplicationDbContext()
var CountNews = db.tbl_GroupNews.Include(w=>w.News).News.Count();
ViewBag.Counter = CountNews;

var db = new ApplicationDbContext();
var model = db.groupnew.include(w=>w.News).tolist();

@foreach (var item in Model){
<div class="info-box">
    <div class="info-box-content">
        <span class="info-box-text">@item.Name::count of news in this group </span>
        <span class="info-box-number">
         @item.News.Count()
        </span>

    </div><!-- /.info-box-content -->
</div><!-- /.info-box -->}