Dim editEmployee = (From c In Employee _
Where (c.lastName = txtLastName.Text And c.firstName = txtFirstName.Text))
Select c).Single()
I'm getting errors with this particular syntax. Trying to retrieve a single row for employee that matches first and last name.
Try .Take(1) instead of .Single(). Single() expects only one row to be returned, if more than one employee has the same name it will throw an exception. Take(1) might not give you the employee you want if there are multiple so you may want to search for an employee id instead.
