title: How to correctly remove a stored procedure from DataEntities.edmx?
body: <p>If I define a stored procedure <code>myStoredProcedure</code> using Visual Studio Server Explorer in "Stored Procedures" folder, then I go to the <code>.edmx</code> to update the model.</p>
  
  <p>I can use that <code>myStoredProcedure</code> in the code behind, and can be detected by IntelliSense, and works fine.</p>
  
  <p>When I remove <code>myStoredProcedure</code> from the database and from the <code>.edmx</code> model.
  It is still detected by IntelliSense. Even if it has no trace neither in Server Explorer -> "Stored Procedures" folder nor in <code>.emdx</code> "Stored Procedures / Functions" folder.</p>
  
  <p>When it is used no compile error shown, but runtime error (Of course expected).  </p>
  
  <blockquote>
    <p>The function import 'DataEntities.myStoredProcedure' cannot be executed because it is not mapped to a store function.</p>
  </blockquote>
  
  <p>If I re-define <code>myStoredProcedure</code> again in the Database -> Server Explorer -> "Stored Procedures", and update the <code>.edmx</code> model. The IntelliSense detects two:</p>
  
  <ul>
  <li><code>myStoredProcedure</code>  -> this is the old one, and causes runtime error.  </li>
  <li><code>myStoredProcedure1</code> -> this is the new one, and works fine.</li>
  </ul>
  
  <p>So how to correctly remove a stored procedure from <code>DataEntities.edmx</code>?</p>