EF根据日期分组查询与视图显示

业务需求：页面显示的文章按照年份分组并按照年份倒序排列。 控制器代码实现：

public class ArticleController : Controller  
    {  
        private DataContext db = new DataContext();  
  
        //  
        // GET: /Article/  
  
        public ActionResult Index()  
        {  
            return View(db.Articles.GroupBy(a => a.CreateTime.Year).OrderByDescending(a => a.Key).ToList());  
        }  
}  

 视图部分：

引入类型：@model IEnumerable<IGrouping<int, _116.Models.ArticleModels>>

<h2><small>文章存档</small></h2>  
            <div>  
                @foreach (var items in Model)  
                {  
                    <h3 class="h3"><small>@items.Key</small></h3>  
                    <ul>  
                        @foreach (var item in items)  
                        {  
                            <li class="list-group-item-text">  
                                <a href="/Article/Details/@item.ObjectID">@Html.DisplayFor(modelItem => item.ObjectTitle)</a>  
                                <div class="meta">  
                                    <time>@item.CreateTime.ToString("yyyy-MM-dd")</time>  
                                    <i class="glyphicon glyphicon-eye-open eye"></i>  
                                    <span>(@Html.DisplayFor(modelItem => item.VisitedCount))</span>  
                                </div>  
                            </li>  
                        }  
                    </ul>  
                }  
            </div>