代码1与代码2不同之处就是多了一个join连接,怎么使用了join后,Include就不启作用了?
//代码1:
//能查出所包含的User
return (from z in context.ZoneUser.Include("User")
                                where z.Zone.Name == zoneName
                                orderby z.JoinTime descending
                                select z)
                                    .Skip(pageSize * (pageIndex - 1))
                                    .Take(pageSize).ToList();
//代码2:
//查出来的User全为空
return (from z in context.ZoneUser.Include("User")
                                join m in context.ZoneMemberUsers on z.UserId equals m.UserId
                                where z.Zone.Name == zoneName
                                && m.ZoneMemberRole.Name == roleName
                                orderby z.JoinTime descending
                                select z)
                                    .Skip(pageSize * (pageIndex - 1))
                                    .Take(pageSize).ToList();