using (var context = new DataBaseEntities()) { var data = from emp in context.Employees join dpt in context.Departments on emp.DepartmentId equals dpt.Id where dpt.Id == 1 select new { epf = emp.EPFNumber, dept_name = dpt.DepartmentName }; }
using (var context = new DataBaseEntities()) { var data = from emp in context.Employees join dpt in context.Departments on emp.DepartmentId equals dpt.Id where dpt.Id == 1 select new { epf = emp.EPFNumber, dept_name = dpt.DepartmentName }; }
Very helpful dude !!
Thanks !