title: how to convert sql query with inner join to linq lambda expression?
body: <p>i want to select some fields from some tables 
  please help to convert sql query to linq , i need to show these values into mvc3 webgrid.</p>
  
  <p>How to convert inner join into linq? Or is there any way to do it in EF?</p>
  
  <pre><code>SELECT
  DISTINCT
      SecurityIdentifier_All.SecurityId,
      NAV.CompanyName,
      NAV.SecurityType,
      SecurityIdentifier_All.Identifier,
      SecurityIdentifier_All.SecurityIdentifierTypeId
  FROM
      Fireball_Reporting..Reporting_DailyNAV_Pricing NAV
  INNER JOIN
      Fireball_Reporting..SecurityIdentifier_All ON  
           SecurityIdentifier_All.SecurityId = NAV.PricingSecurityID
  inner join  
      (
      SELECT  SecurityId, MAX(SecurityIdentifierTypeId) SecurityIdentifierTypeId
  FROM    Fireball_Reporting..SecurityIdentifier_All
  where  SecurityIdentifierTypeId in (1,16)
  group by SecurityId
      ) IdentifierType on
      IdentifierType.SecurityId = SecurityIdentifier_All.SecurityId and
      IdentifierType .SecurityIdentifierTypeId = 
  
  SecurityIdentifier_All.SecurityIdentifierTypeId
  WHERE
      Date = Fireball_Configuration.dbo.PreviousBusinessDay()
  </code></pre>
  
  <p>In above <code>SecurityIdentifier_All</code> and <code>NAV</code> is an view.
  Fireball_Reporting database name.
  In Answer till 1st inner join it is done. please help me to complete last section.</p>