title: WPF LINQ DataContext Refresh not reading new records in the sql database table
body: <p>I have a LINQ datacontext and a ObservableCollection holding records for a Companys table in SQL</p>
  
  <p>Changes to the current records and new records made to the current datacontext (DataDC) are reflected when I do a </p>
  
  <pre><code>DataDC.SubmitChanges();
  </code></pre>
  
  <p>However if I have another Window with a separate DataContext to the same tables, if I modify fields for records that currently exist in both DataContexts (ie Company Name modified) these changes are seen when I do a  </p>
  
  <pre><code>DataDC.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, Companys);
  </code></pre>
  
  <p>However if the OTHER window/datacontext created a new record or if I use SQL explorer to create a new record, these new records do not show in the DataContext.Company table even after a </p>
  
  <pre><code>DataDC.Refresh(System.Data.Linq.RefreshMode.OverwriteCurrentValues, Companys);
  </code></pre>
  
  <p>I've tried different Modes.</p>
  
  <p>So why doesn't a .Refresh(....) Load new records, but will reflect changes made to records that exist?</p>
  
  <p>Am I missing something?</p>
  
  <p>I can't see a way to just refresh the DC with completely all new data from the SQL tables?</p>