title: Updating Foreign Key dependent record using LINQ to SQL
body: <p>I am working on application with more than 50 tables with a large amount of data.</p>
  
  <p>Let's say I have two tables:</p>
  
  <pre><code>Parent { pID int (PK), pName varchar(30) }
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Child { pID int (FK), cName varchar(30) }
  </code></pre>
  
  <p>Here is my query:</p>
  
  <pre><code>using(MyDBContext ctx = new MyDBContext())
  {
      Child ch = ctx.Childs.Where( c =&gt; c.pID == 1).FirstOrDefault();
      ch.cName = "ABCDEF";
      ctx.SubmitChanges();   //  &lt;--- Executes but nothing changes...
  }
  </code></pre>
  
  <p>I have tried multiple existing values but <code>ctx.SubmitChanges()</code> doesn't work when updating child record. Any workaround?</p>