转：ef获取某个表中的部分字段值

最新推荐文章于 2024-01-03 15:05:35 发布

天为我蓝

最新推荐文章于 2024-01-03 15:05:35 发布

阅读量377

点赞数

CC 4.0 BY-SA版权

文章标签： c#

原文链接：http://www.cnblogs.com/no27/p/5822854.html

本文介绍如何使用EF4.1从新闻表中读取特定字段(id, title, createtime)并展示在页面上。通过LINQ查询简化数据获取流程。

我有个新闻表

id,title,body,createtime,author,click

使用ef4.1 仅仅读取 id,title,createtime 并显示在页面上。

 public static List<NewInfo> GetHotNews()
        {
            List<NewInfo> list;
            list = (from n in db.NewInfoes
                    where n.IsTop == 1
                    orderby n.PublishTime descending
                    select new
                    {
                        Title = n.Title,
                        NewID = n.NewID,
                        PublishTime = n.PublishTime
                    }).ToList();
            return list;
        }

改为

public static List<NewInfo> GetHotNews()
        {
            List<NewInfo> list;
            list = (from n in db.NewInfoes
                    where n.IsTop == 1
                    orderby n.PublishTime descending
                   
       .Select(n => new NewInfo
                    {
                        Title = n.Title,
                        NewID = n.NewID,
                        PublishTime = n.PublishTime
                    });
            return list;
        }

转载于:https://www.cnblogs.com/no27/p/5822854.html