How to get linqpad to update columns

Question

I am trying to make the SQL equivalent of UPDATE with C # statements in linqpad, but the data is not changing, and I'm not sure even debugging it further to find out why. The User table is pretty standard with only a row for storing Sid.

var usersWithSid = from u in Users where u.Sid != null select u; foreach(var u in usersWithSid) { u.Sid = "S-1-5-21-3812666658-2998621725-2245962016-6618"; } SubmitChanges(); usersWithSid.Dump(); 

Most of the examples I found seem to update only one record at a time. Why is this not working?

Answer 1

Do you have a primary key defined in the table? Updates will not fail if you do not.