Actually i am trying to get the employees information based on the deptno.
My Tables:
1.tblemployee2-->colomns-->Id,name,email,sal,deptid
2.tbldept2-->colomns-->deptid,deptname.
here 2 tables has the relation with foreign key constraint.
now i want to retrieve employee names whose deptid is matching with deptid of tbldept2 table.I am getting error in controller
public class employeeController : Controller
{
//
// GET: /employee/
public ActionResult Index(int id)
{
employeecontext empcontext = new employeecontext();
employee emplist = empcontext.employees.Where(emp => emp.DEPTID == id);
return View(emplist);
}
public ActionResult Details()
{
employeecontext employeecontext = new employeecontext();
List<employee> empnames= employeecontext.employees.ToList();
return View(empnames);
}
}
solve this .....