我已经构建了一个查询,从两个表中返回数据,它们通过内连接进行关联。虽然查询看起来没问题,但是当我尝试访问查询的选定字段名称时,我收到了错误消息。我该如何在这个查询中使用.SingleOrDefault()函数?有谁能帮我解决问题。
private void FindByPincode(int iPincode)
{
using (ABCEntities ctx = new ABCEntities())
{
var query = from c in ctx.Cities
join s in ctx.States
on c.StateId equals s.StateId
where c.Pincode == iPincode
select new {
s.StateName,
c.CityName,
c.Area};
// var query = ctx.Cities.AsNoTracking().SingleOrDefault(_city => _city.Pincode == iPincode);
if (query != null)
{
cboState.SelectedItem.Text =query.State; //Getting error "Could not found"
cboCity.SelectedItem.Text = query.CityName; //Getting error "Could not found"
txtArea.Text = query.Area; //Getting error "Could not found"
}
}
}
感谢先行一步。