Updating Sql Bit Column From Entity Framework

I'm having an issue updating a 'bit' column in a SQL database, using C# and Entity Framework. I have a 'Settings' table with a NOT NULL bit column named 'Active'. When I create a r

Solution 1:

I think this is because when you create a Setting object .Active field takes is default value: that is false. So when you set Active to false there is no change. You have to load the entity from the Db before the update.