KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I just have a very simple situation where all I need is to delete record using Linq2Entities. I tried to do some research and still can't figure out the right way to do it. Here's my simple code: [DataObjectMethod(DataObjectMethodType.Delete)] public void DeleteEmployee(Employee z) { using (var ctx = new MyEntity()) { var x = (from y in ctx.Employees where y.EmployeeId == z.EmployeeId select y).FirstOrDefault(); ctx.DeleteObject(x); ctx.SaveChanges(); } } [DataObjectMethod(DataObjectMethodType.Select)] public List<Employee> GetAllEmployee() { using (var ctx = new MyEntity()) { var x = from y in ctx.Employees select y; return x.ToList(); } } I can delete a particular record if for example I assign y.EmployeeName == "Harold Javier" to the Delete method above, but when I assign y.EmployeeId == z.EmployeeId to the above code, the delete doesn't work. (Note: EmployeeId is the primary key of the Employee table)
Tags (comma-separated)
Save Edits
Cancel