记一次linq多表查询方法（分页、格式化对象数组）

记一次linq多表查询方法（分页、格式化对象数组）

var list = (from r in db.RealEstates
                        where r.DeleteFlag == 0 && r.StaticFlag == 2 && r.TypeFlag == 1
                        orderby r.CreatedTime descending
                        select new
                        {
                            r.City.CityName,
                            r.Community.VillageName,
                            DecorationName = r.Decoration.Name,
                            r.PropertyType.PropertyTypeName,
                            r.SellingPrice,
                            r.StaticFlag,
                            r.Title,
                            r.UnitType,
                            r.Area,
                            r.Floor,
                            r.Id,
                            HousingAllocationList = r.HousingAllocation.ToList().Select(h => new { h.Id, h.Name }),
                            HouseBookId = r.HouseBook.Id.Equals(null) ? "空" : r.HouseBook.Id.ToString(),
                            r.CreatedTime,
                        }).Skip((page.PageIndex-1) * page.PageSize).Take(page.PageSize).ToList();