title: Why my complex types is not updated when i add a stored procedure into edmx in Visual Studio 2017?
body: <p>I'm using the Entity Framework to create a complex types from some stored procedures. Now, I changed one of the stored procedure to display 2 more fields.</p>
  <p>I'm trying to update the complex type that maps to this stored procedure, but it's not working!  Also, I tried both approaches:</p>
  <ol>
  <li>Delete all 3 parts in model, and add again</li>
  <li>Update the Model from the database and then update function imports</li>
  </ol>
  <p>but they did not work!</p>
  <p>Also, in the first way, when I add the stored procedure to the model, the complex type isn't updated. Besides, in the second way, when I &quot;Edit Function Imports&quot; and &quot;Get Column Information&quot;, I get a message</p>
  <blockquote>
  <p>The selected stored procedure or function returns no columns</p>
  </blockquote>
  <p>while it's returning about 30 columns through a select statement!</p>
  <p>The last part of my stored procedure is like this:</p>
  <pre><code>select * 
  from MyTable  
  where Name like '%My Name%'
  </code></pre>