Is there any reason something like this would not work?
This is the logic I have used many times to update a record in a table with LINQ
DataClasses1DataContext db = new DataClasses1DataContext();
User updateUser = db.Users.Single(e => e.user == user);
updateUser.InUse = !updateUser.InUse;
db.Log = new System.IO.StreamWriter(@"c:\temp\linq.log") { AutoFlush = true };
db.SubmitChanges();
(updateUser.InUse is a bit field)
For some reason it isn't working?
If I check the linq.log it is completely blank?
Could there be a problem with my .dbml? Other tables seem to work fine but I've compared properties in the .dbml and they all match.
Its as if the db.SubmitChanges(); does nto detect any updates being required.