EF 查询的两种方式

#EF 查询的两种方式

##方式一

EFFristModelEntities db = null;
            if (HttpContext.Current.Items["db"] == null)
            {
                db = new EFFristModelEntities();
                HttpContext.Current.Items["db"] = db;
            }
            else
            {
                db = HttpContext.Current.Items["db"] as EFFristModelEntities;
            }

           var userInfoList = from u in db.UserInfo
                               where u.ID == 133
                               orderby u.ID descending //排序
                               select u
           //var userInfoList = (from u in db.UserInfo
           //                   where u.ID == 133
           //                   orderby u.ID descending //排序
           //                   select u)Skip<UserInfo>(2).Take<UserInfo>(2);//跳过2条数据，取2条数据，用于分页                               
                               
 new{UName=u.UserName,UPwd=u.UserPass};
            foreach (var userInfo in userInfoList)
            {
                Response.Write(userInfo.UName+":"+userInfo.UPwd);
            }

##方式二

EFFristModelEntities db = new EFFristModelEntities();
          
            var userInfoList = db.UserInfo.Where<UserInfo>(u => u.ID >0);
        	//var userInfoList = db.UserInfo.Where<UserInfo>(u => u.ID >0).OrderByDescending(u=>u.ID).Skip<UserInfo>(2).Take<UserInfo>(2);//跳过2条数据，取2条数据，用于分页
            int i = 0;
            int count = userInfoList.Count();
            Response.Write(count);