查询包含对不同数据上下文上所定义项的引用。

IQueryable<CityReportEntity> result =null;

报错代码

IQueryable<District> listDistrict =
                                BLL.DistrictBLL.DistrictBLL.GetAndDistrictByPID((int)entity.DistrictId);

                        result = from c in result
                                     from d in listD
                                     where c.DistrictId == d.ID
                                     select new CityReportEntity
                                     {
                                         ID = c.ID,
                                         Title = c.Title,
                                         Content = c.Content,
                                         DistrictId = c.DistrictId,
                                         Attach = c.Attach,
                                         Type = c.Type,
                                         Status = c.Status,
                                         Description = c.Description,
                                         ModifiedDate = c.ModifiedDate,
                                         CreateDate = c.CreateDate,
                                         Account = c.Account,
                                         Category = c.Category
                                     };

查询包含对不同数据上下文上所定义项的引用。

 

正确代码

 IQueryable<District> listDistrict= from d in db.Districts
                                                          where d.ParentID == entity.DistrictId
                                                          || d.ID == entity.DistrictId
                                                          select d;
  var listD = listDistrict;

 

result = from c in result
                                     from d in listD
                                     where c.DistrictId == d.ID
                                     select new CityReportEntity
                                     {
                                         ID = c.ID,
                                         Title = c.Title,
                                         Content = c.Content,
                                         DistrictId = c.DistrictId,
                                         Attach = c.Attach,
                                         Type = c.Type,
                                         Status = c.Status,
                                         Description = c.Description,
                                         ModifiedDate = c.ModifiedDate,
                                         CreateDate = c.CreateDate,
                                         Account = c.Account,
                                         Category = c.Category
                                     };

解决问题

区别listDistrict