title: Why the order of params of function imported from stored procedure changed?
body: <p>I have a stored procedure in SQL Sever 2008 like:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[mySP]
  @FirstName As varchar(30),  
  @LastName As varchar(30),   
  @ID As int 
  As 
  Begin
  --......
  End
  </code></pre>
  
  <p>then in EF imported this SP as a function like:</p>
  
  <pre><code>public ObjectResult&lt;Nullable&lt;global::System.Int32&gt;&gt; MyFunc(global::System.String LastName,  global::System.String FirstName,Nullable&lt;global::System.Int32&gt; ID)
  {
  //....
  }
  </code></pre>
  
  <p>it works fine for long time. </p>
  
  <p>Then I add some new thing to EF edmx with "update from database" today, the function parameter changed! it became:</p>
  
  <pre><code>public ObjectResult&lt;Nullable&lt;global::System.Int32&gt;&gt; MyFunc(global::System.String LastName,Nullable&lt;global::System.Int32&gt; ID,  global::System.String FirstName)
  {
  //....
  }
  </code></pre>
  
  <p>It's hardto believe it. I already have many codes to call this func and it worked fine. Now all of them are not working. Even I can manually change the parameter, but maybe it back the orginal order with the generated-code!</p>
  
  <p>How to resolve this problem.</p>