how do use join query of entities framework

Question

there are two table in the sqlEmployeeCategory And EmployeeStatus i want a join query that 1st check from employee category table employee category then from employeeStatus table the employee status in employeestatus table there are multiple records against same employee i want to get last one.

Pankaj Kumar Choudhary · Answer

You can use concept of Inner Tabel like this: select* from EmployeeCategory left outer join (select * from (select Distinct * from EmployeeStatus)Temp)Red on EmployeeCategory.id=Red.id in this query (select Distinct * from EmployeeStatus)Temp will select distinct data from table and named as Temp. Now you can use join on this table with a name(Here i give a name 'Red')

Syed Shanu · Answer

You can Use Linq Query. Check this link http://www.entityframeworktutorial.net/Querying-with-EDM.aspx In my article i have used Join query in Linq using Entity in WCF check that link also hope this will help you. http://www.c-sharpcorner.com/UploadFile/asmabegam/mvc-angular-js-and-wcf-rest-service-for-mind-reader-quiz/