ASP.Net MVC Error

Question

Code: [HttpGet] public ActionResult Edit(int ? employeeid) { EmployeeDataAccess employeeDataAccess = new EmployeeDataAccess(); Employee employee = employeeDataAccess.Employees.Single(emp => emp.EmployeeId == employeeid); return View(employee); } Error: Sequence contains no matching element Please Help me...

Tamal Marick · Answer

Hi Chandrakala, 'Single()' is returning null, that's why its get error, you should do null check for employee object and it's better to use 'SingleOrDefault()' [HttpGet] public ActionResult Edit(int ? employeeid) { EmployeeDataAccess employeeDataAccess = new EmployeeDataAccess(); Employee employee = employeeDataAccess.Employees.SingleOrDefault(emp => emp.EmployeeId == employeeid); return View(employee); }

Sonu Gupta · Answer

Hi, Use the SingleOrDefault() instead of Single() Like this - [HttpGet] public ActionResult Edit(int ? employeeid) { EmployeeDataAccess employeeDataAccess = new EmployeeDataAccess(); Employee employee = employeeDataAccess.Employees.SingleOrDefault(emp => emp.EmployeeId == employeeid); return View(employee); }

Rajanikant Hawaldar · Answer

Hi Chandrakala, Single is returning null, so its error please go through this discussion and you should do null check for employee object and better use 'SingleOrDefault' https://stackoverflow.com/questions/3994336/sequence-contains-no-matching-element https://social.msdn.microsoft.com/Forums/en-US/b73e5838-6d89-4043-84dc-5224a137c409/sequence-contains-no-matching-element?forum=linqprojectgeneral