查询在实体框架

Question

有返回视图

var res = (from results in db.JobSearchAgents 
          where results.SiteID == 110 && results.UserID == sess 
          select results).AsEnumerable().Select(results => new Agentlist 
          { 
           JobSearchAgentID = results.JobSearchAgentID.ToString(), 

           EmailAddress = results.EmailAddress, 
           Keywords = results.Keywords, 


           Country = results.Country, 

           zipcode = results.ZipCode, 
           miles = results.Miles.ToString() 

          }); 

      return View(res); 

Answer 1

，你可以去内联状态

(from results in db.JobSearchAgents 
          where results.SiteID == 110 && results.UserID == sess 
          select results).AsEnumerable().Select(results => new Agentlist 
          { 
           //it is just an example 
           JobSearchAgentID =JobSearchAgentID!=null? results.JobSearchAgentID.ToString():[somthing else], 

           EmailAddress = results.EmailAddress, 
           Keywords = results.Keywords, 

           //another example 
           Country = String.IsNullOrEmpty(results.Country)?"No Country":results.Country, 
           //the last example 
           zipcode =results.Country=="United States"? "123": results.ZipCode, 
           miles = results.Miles.ToString() 

          }); 

      return View(res); 

Answer 2

查询可以改写为之前JobSearchAgentID如果条件适用于：

var res = from results in db.JobSearchAgents 
where results.SiteID == 110 && results.UserID == sess 
select new Agentlist 
{ 
    JobSearchAgentID = results.JobSearchAgentID.ToString(), 
    EmailAddress = results.EmailAddress, 
    Keywords = results.Keywords, 
    Country = results.Country, 
    zipcode = results.Country=="United States" ? "123" : results.ZipCode, 
    miles = results.Miles.ToString() 
}); 
string country = string.Emtpy; 

foreach (var agentLst in res) 
{ 
    country = agentLst.Country;  
} 

我最后的回答是在MVVM的上下文中，我们通常使用ObservableCollection（存在于System.Collections.Ob jectModel命名空间）。无论如何，我已经更新了我的答案。这将在你的情况下工作。 由于上面的linq查询的结果是一个集合（IEnumerable），因此您需要遍历它以获取所需的数据。希望它能回答你的问题。