title: Refresh data in server explorer after remove row in context
body: <p>i have project with local database:</p>
  
  <p><img src="https://i.stack.imgur.com/WCy9e.jpg" alt="enter image description here"></p>
  
  <p>and first of all initial values in table:</p>
  
  <pre><code>Id, Name
  1,  aa
  2,  bb
  3,  cc
  </code></pre>
  
  <p>and now i have connect by ADO.NET Enityt Data Model, names <em>"Database1Entities"</em>, look:</p>
  
  <pre><code>public partial class Database1Entities : DbContext
  {
      public Database1Entities()
          : base("name=Database1Entities")
      {
      }
  
      protected override void OnModelCreating(DbModelBuilder modelBuilder)
      {
          throw new UnintentionalCodeFirstException();
      }
  </code></pre>
  
  <p>all is ok for reading this file:</p>
  
  <pre><code>var context = new Database1Entities();
  var products = context.Products;
  
  products.ToList().ForEach(p=&gt; Console.WriteLine(p.Id + " " + p.Name));
  </code></pre>
  
  <p>Return initial values, but when i remove first <code>(1,aa)</code>:</p>
  
  <pre><code>        var removed_prod = products.First();
          context.Products.Remove(removed_prod);
          context.SaveChanges();
  </code></pre>
  
  <p>and give repeat query:</p>
  
  <pre><code>products.ToList().ForEach(p=&gt; Console.WriteLine(p.Id + " " + p.Name));
  </code></pre>
  
  <p>then result looks like:</p>
  
  <pre><code>2,bb
  3,cc
  </code></pre>
  
  <p>Now all's Ok, when I debug again - only with code:</p>
  
  <pre><code> var context = new Database1Entities();
   var products = context.Products;
   products.ToList().ForEach(p=&gt; Console.WriteLine(p.Id + " " + p.Name))
  </code></pre>
  
  <p>then output's same: </p>
  
  <pre><code>2,bb
  3,cc
  </code></pre>
  
  <p>but when i would to view result in <code>Database1.sdf -&gt; Tables-&gt; Products -&gt; (PM) Show Table Data</code>, then i can't understand - why it's not refresh and is initial values with 3 rows. I refreshed all files, connection, REBUILD project - not results :(. It's any way to get real data in this view?
  It's look:
  <img src="https://i.stack.imgur.com/e9em1.jpg" alt="enter image description here"></p>