I have a member object that has a one to many relationship with a phones object. i want to get a list of members that have the same name and have a phone no that also matches.
I can match the records but the phone numbers are not being included because of the join. Any ideas how i might get the list of phone numbers returned?
Code so far:
            var membersA = dc.Members.Include("Phones");
            var membersB = dc.Members.Include("Phones");
            var matchingMembers = from ma in membersA
                                  join mb in membersB
                            开发者_Go百科      on new { ma.Forename, ma.Surname } equals new { mb.Forename, mb.Surname }
                                  where ma.MemberID < mb.MemberID
                                  select new { ma, mb };
            if (SearchByPhone)
                matchingMembers = from mm in matchingMembers
                                  where mm.ma.Phones.Any(phoneA => mm.mb.Phones.Any(phoneB => phoneB.PhoneNumber == phoneA.PhoneNumber))
                                  select mm;
can't you do something like:
var membersA = dc.Members.Include("Phones");
var membersB = dc.Members.Include("Phones");
var matchingMembers = from ma in membersA
                      join mb in membersB
                      on new { ma.Forename, ma.Surname } equals new { mb.Forename, mb.Surname }
                      where ma.MemberID < mb.MemberID and ma.Phones.Any(pa => mb.Any.Phones(pb => pb.PhoneNumber == pa.PhoneNumber)
                      select new { Member = ma, Phones = ma.Phones };
Update: It appear to be some limitation with linq-to-entities and include. The code above is updated so it should work so it selects an anonymous object. I haven't tried it and don't know what the SQL will look like, but it could be one solution.
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论