title: how to write sql query in linq with left join
body: <pre><code>select 
      pm.GenerationID, srv.ServiceID, srv.ServiceName, srv.ServiceDescription, 
      srv.IsProPack, pm.MonthlyPrice, pm.AnnualPrice, ss.freeExpirationDate 
  from 
      tbl_BILLING_PricingModels pm 
      inner join tbl_BILLING_Services srv on pm.ServiceID = srv.ServiceId 
      left join tbl_BILLING_SubscribedServices ss on srv.ServiceID = ss.ServiceId 
          and ss.ClientId='3B345E8B-3E6C-40E6-A4B8-E6371B717018' 
  where 
      pm.GenerationID = 5 order by srv.ServiceID
  </code></pre>
  
  <p>How to write linq query?</p>