Yesterday, I ran this query:
var serverQ = from a in Import2s
foreach (var a in serverQ)
var col = a.TempCol;
var split = col.Split('\\');
foreach (var s in split)
a.TempCol = s;
It ran up until row ~4700 then stopped generating code. I ran it again and left it overnight at work, and that time it ran until record ~37000. It is stuck on declaring the SQL variables for some reason, but I can see the query has been running for 16 hours without any change.
Here is a screenshot:
Any help on why my query is randomly stopping yet still saying "Executing" after only updating a few thousand records would be greatly appreciated.
PS: One more thing I tried was moving the "SubmitChanges" method outside the outer foreach loop but to no success.