Q: Linq to SQL DataContext.SubmitChanges incorrect syntax near the keyword Where I am working on an existing application and am trying to update a series of values within a database using Entity Framework and the DataContext. 
Using context.SaveChanges() this is giving me an error of 

There was an error when 'SubmitChanges' was called. object:  exception: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'WHERE'.
     at System.Data.Linq.ChangeDirector.StandardChangeDirector.Update(TrackedObject item)
     at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
     at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)

This has only become a problem since adding 
        var managerItem = entityDataContext.item.Single(f => f.Id == consoleItem.ID);
        managerItem.ItemCount = itemCount;
        managerItem.Cost = Cost;
        managerItem.Submit = true;

        entityDataContext.SubmitChanges();

After this error there are also two other errors that occur, one being the same as mentioned above, 
the other 

exception System.Data.Linq.ChangeConflictException: Row not found or changed.

However, the values I need to get updated are being updated so it I can only assume something else is or isnt happening. 
Any and all help with the initial error would be gladly received. 
