Entity Framework查询数据返回指定列

 

Entity Framework查询返回指定列

 

using (var se = new SpinningWebSiteEntities())
 {
               return (from p in se.NewsDetail
                           where p.NewsCategoryIDSecond == newsCategoryID
                           orderby p.CreateTime descending
                           select new
                           {
                               NewsDetailID = p.NewsDetailID,
                               Title = p.Title,
                               CreateTime = p.CreateTime
                           }).Take(topNumber).ToList()
                           .Select(p => new NewsDetail
                           {
                               NewsDetailID = p.NewsDetailID,
                               Title = p.Title,
                               CreateTime = p.CreateTime
                           }).ToList();
}