how do use join query of entities framework

Sajid Hussain

there are two table in the sql,EmployeeCategory 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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Kumar Choudhary11y ago
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 Shanu11y ago
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/