title: Entity Framework : join two tables and where clause
body: <p>I'm having trouble working with Entity Framework and PostgreSQL, does anybody know how to join two tables and use the second table as a where clause?</p>
  <p>The select I want to do in Entity Framework would be in SQL:</p>
  <pre><code>SELECT ai.id, ai.title, ai.description, ai.coverimageurl 
  FROM app_information ai 
  INNER JOIN app_languages al on al.id = ai.languageid
  WHERE al.languagecode = 'es'
  </code></pre>
  <p>Currently I have this</p>
  <pre><code>appInformationToReturn = context.app_information
                                  .Join(context.app_language, ai =&gt; ai.languageid, 
                                        al =&gt; al.id, (ai, al) =&gt; new AppInformation()
                                                                     {
                                                                          id = ai.id,
                                                                          title = ai.title,
                                                                          description = ai.description,
                                                                          coverimageurl = ai.coverimageurl
                                                                     })
                                  .Where()
                                  .FirstOrDefault();
  </code></pre>
  <p>I don't know how to build the <code>where</code> clause.</p>