Linq, selecting two records from one table based on 2 different ID's
<p>I'm trying to create a statement in where i start out with an ID to select an object in table1, then take 2 new ids from that object and using them to look up 2 different objects in table2.<br>
My goal is to end up with an anonymous object that has the object from table1 and the 2 objects from table2 i.e. <code>(table1.object, table2.object1, table2.object2)</code>.</p>

<p>I don't know if this can be done in a single statement or not.</p>

<p>So far I got this, but it only gives me <code>table1.object</code> and <code>table2.object1</code>, and not <code>table2.object2</code>:</p>

<pre><code>db.Person.Where(x =&gt; x.Id == myId)
      .SelectMany(p =&gt; db.OtherPerson
        .Where(o=&gt; p.OhterP1_Id1 == o.Id).DefaultIfEmpty(),
        (p, o) =&gt; new {pers = p, otherP = o})
</code></pre>