title: Linq to Sql Update on extracted list not working
body: <p>I am having issues updating my Database using linq to sql.
  I have a master query that retrieves all records in the database (16,000 records)</p>
  
  <pre><code>PostDataContext ctxPost = new PostDataContext();
  int n = 0;    
  var d = (from c in ctxPost.PWC_Gs
                      where c.status == 1
                      select c);
  </code></pre>
  
  <p>I then take the first 1000, and pass it to to another object after modification using the following query:</p>
  
  <pre><code>var cr = d.Skip(n).Take(1000);
  </code></pre>
  
  <p>I loop through the records using foreach loop</p>
  
  <pre><code>foreach (var _d in cr)
  {
  // Some stuffs here
  _d.status = 0;
  }
  </code></pre>
  
  <p>I then Call SubmitChanges</p>
  
  <pre><code>ctxPost.SubmitChanges();
  </code></pre>
  
  <p>No Record gets updated</p>