实体框架-如何过滤渴望加载的导航/关系属性？
|
我有以下Entity Framework 4.1实体和关系
音乐会ConcertId，AdministratorUserId，名称，IsDeleted
订票
BookingId，ConcertId，UserId，IsDeleted
用户ID，用户ID，名称，已删除
人际关系
音乐会1 ..... M预订1 .... 1用户
现在，我正在尝试为特定的AdminstratorUserId选择所有音乐会，还包括每个音乐会的所有预订以及每个预订的用户详细信息。我还想对每个音乐会，预订和用户使用IsDeleted == false的过滤器。我想返回一个音乐会列表，这些音乐会的预订和用户详细信息都保留为导航属性。
在SQL中，这就是我要实现的目标：
SELECT *
FROM concert c, booking b, user u
WHERE c.ConcertId = b.ConcertId AND b.UserId = u.UserId AND c.AdministratorId = 10
AND c.IsDeleted = false AND b.IsDeleted = false AND u.IsDeleted = false
int adminId = 10;
var concerts = _context.Concerts
.Where(p => p.AdministratorId == adminId && p.IsDeleted == false)
.Select(p => new {
Concerts = p,
Bookings = p.Bookings
.Where(q => q.IsDeleted == false && q.User.IsDeleted == false)
.Select(r => new {
Bookings = r,
User = r.User
})
.AsEnumerable()
.Select(q => q.Bookings)
})
.AsEnumerable()
.Select(p => p.Concerts)
.ToList();
var concertsQuery = (ObjectQuery<Concert>)_context.Concerts
.Where(p => p.UserId == userId
&& p.IsDeleted == false
&& p.Bookings.Any(q => q.IsDeleted == false && q.User.IsDeleted == false)
);
var concerts = concertsQuery.Include(\"Bookings\").Include(\"Bookings.User\").ToList();
没有找到相关结果
已邀请:
2 个回复
琶竞捆栓
var concerts = _context.Concerts .Where(p => p.AdministratorId == adminId && p.IsDeleted == false) .Select(p => new { Concerts = p, Bookings = p.Bookings .Where(q => q.IsDeleted == false && q.User.IsDeleted == false) .Select(r => new { Bookings = r, User = r.User }) }) .ToList();夏瓤跋棘
var concertResult = new List<Concert>(); foreach (var concertObject in concerts) { var concert = concertObject.Concert; foreach (var bookingObject in concertObject.Bookings) { var booking = bookingObject.Booking; booking.User = bookingObject.User; concert.Bookings.Add(booking); } concertResult.Add(concert); }