How call inner join in SvcClient entites?

Vote count: 0

How to insert join enties when we call webservice calls?

SELECT 
      distinct [COMMITTEE_MAST_CUST]      
  FROM [PDEV].[dbo].[COM_COMMITTEE_MEMBER] cc Inner join CUSTOMER c 
  on c.MASTER_CUSTOMER_ID = cc.COMMITTEE_MAST_CUST
  where MEMBER_MAST_CUST = '0827857' and cc.END_DATE > GETDATE()  
 and c.CUSTOMER_CLASS_CODE IN ('SECTION_OFFICER','CHAPTER_OFFICER')

But now doing now this don't have clue where to put join in this using above query.

SvcClient.Client.Context.ComCommittees.Where(x => x.MemberMasterCustomer 
        == masterCustomerId  && x.EndDate > DateTime.Today.AddMonths(-3)).ToList();

asked 29 secs ago

James123

Let's block ads! (Why?)

How call inner join in SvcClient entites?