Left join multiple tables using lambda expression
<p>I have 2 tables:</p>

<blockquote>
  <p>specs {specId, desc, createdby, lastupdatedby}<br>
  users {userid, username}</p>
</blockquote>

<p>I want the below linq query need to be written in pure lambda expression</p>

<pre><code>    from spec in specs
    from user in users.where(x =&gt; x.userId== spec.createdby).DefaultIfEmpty()
    from updatedUser in users.where(x =&gt; x.userId== spec.lastupdatedbyby).DefaultIfEmpty()
select new {
spec = spec
user = user,
updatedUser = updatedUser
}
</code></pre>

<p>Please assist.</p>

<p>Data would be like say:</p>

<pre><code>spec[{1, test, 1234, 2345},{2, test1, 1234, null}]

users[{1234, Allen},{2345, Dwayne}]
</code></pre>

<p>So the result should be </p>

<pre><code>[{1, test, Allen, Dwayne}, {2, test1, Allen, null}]
</code></pre>