查询在实体框架

Question

在它给错误上面的查询我想查询的列像字符串s =一些字符串变量来获取顶级记录和存储zipcd.zipcode

var zipcd = (from u in db.ZipCodes1 
             where u.CityName == temparray[0].Trim() && u.StateAbbr == temparray[1].Trim() && u.CityType == "D" 
             select new Viewsearch 
             { 
              Zipcode = u.ZIPCode, 
              CityName = u.CityName, 
              stateabbr = u.StateAbbr 

             }).First(); 
          Viewsearch vs = (Viewsearch)zipcd; 
          string description = (new ObservableCollection<Viewsearch>(zipcd))[0].Zipcode.ToString(); 


         locationarray = vs.Zipcode + " " + vs.CityName + ", " + vs.stateabbr; 

Answer 1

var city = temparray[0].Trim(); 
var stat = temparray[1].Trim(); 
var zipcd = db.ZipCodes1 
    .Where(u => u.CityName == city && u.StateAbbr == stat && u.CityType == "D") 
    .Select(new Viewsearch { Zipcode = u.ZIPCode, u.CityName, stateabbr = u.StateAbbr }) 
    .First(); 
locationarray = zipcd.Zipcode + " " + zipcd.CityName + ", " + zipcd.stateabbr; 

这应该工作。