LINQ一对多，3级深度问题

Question

我正在尝试找出我在下面的LINQ语句中做错了什么。它不像第三个SELECT。当我输入查询时，它会在Intelisense中找到tblAddresse.tblAdminCounty，但当我在它之后输入SELECT时，它就会变得异常。

这与tblAddress和tblAdminCounty的关系有关吗？我本以为它在tblAddress下的智能感知中显示的事实会让这句话不言而喻，但显然不是。

如果我在一个单独的函数中只查询CountyName，它将如下所示-->

var countyName = from adminCounty in context.tblAdminCounties
                 where adminCounty.CountyID == countyID
                 select adminCounty.CountyName;

这是基于这个站点的更大的3层方法--> HERE

var query = from tblBusinesse in context.tblBusinesses
            where tblBusinesse.BusinessID == businessID
            select new
            {
                tblBusinesse.BusinessName,
                tblBusinesse.ContactName,
                tblBusinesse.EmailAddress,
                Address = from tblAddresse in tblBusinesse.tblAddresses 
                      select new 
                      { 
                          tblAddresse.AddressLine1, 
                          tblAddresse.AddressLine2, 
                          tblAddresse.AddressLine3, 
                          tblAddresse.CityName, 
                          County = from adminCounty in tblAddresse.tblAdminCounty
                                   select new
                                   {
                                       adminCounty.CountyName
                                   }

                      }
            };

Answer 1

您正在尝试查询它，就好像一个地址有多个县一样。它被称为tblAdminCounty而不是tblAdminCounties这一事实不表明它只是一个单独的项目吗？

尝试更改此设置：

County = from adminCounty in tblAddresse.tblAdminCounty
         select new
         {
             adminCounty.CountyName
         }

仅仅是：

County = tblAddresse.tblAdminCounty