SQL Query in LINQ to Entities

Can anyone tell 开发者_如何学运维me,how to write this query in LINQ?

select a.UTP_NAME, b.UPS_NAME, c.USS_NAME from 
    TB_UTILIDADE_PUBLIC_UTP a inner join
    TB_UTILIDADE_PUBLIC_SECTOR_UPS b on 
    a.UPS_ID = b.UPS_ID 
       inner join TB_UTILIDADE_PUBLIC_SUBSECTOR_USS c 
 on a.USS_ID = c.USS_ID and a.UPS_ID = c.UPS_ID /* IMPORTANT LINE! */

Thanks.

Creating a new anonymous type allows you to join with multiple criteria

var query = from a in context.TB_UTILIDADE_PUBLIC_UTP
            join b in context.TB_UTILIDADE_PUBLIC_SECTOR_UPS 
              on a.UPS_ID equals b.UPS_ID
            join c in context.TB_UTILIDADE_PUBLIC_SUBSECTOR_USS 
              on new { a.USS_ID, a.UPS_ID } equals new { c.USS_ID, c.UPS_ID }
            select new
            {
              a.UTP_NAME, 
              b.UPS_NAME, 
              c.USS_NAME
            };