title: Entity Framework will not show stored procedures
body: <p>I have been messing with this all morning, but I can't find the answer. I am trying to use EF to reference a stored procedures, but no matter what I try I cannot get it to show up in the model browser.</p>
  
  <p>I have used the following steps to try to get the procedures into the modal:</p>
  
  <ol>
  <li><p>add procedure to Entity model</p></li>
  <li><p>right click on model and choose add new --> Function Import</p></li>
  <li><p>Give it a name and select my procedure</p></li>
  <li><p>generate a new complex collection (I have also tried using an entity, neither work)</p></li>
  <li><p>click OK</p></li>
  </ol>
  
  <p>I have done this many times, and I can see the function in the "function Imports" folder in the model, but it never shows up in the model, so I can't reference it.</p>
  
  <p>I find I can reference the stored procedure directly (without the import) by doing the following:</p>
  
  <pre><code>    DBEntities db = new DBEntities();
      var test = db.gsp_GetGroups();
  </code></pre>
  
  <p>However, I cannot convert this to <code>IQueryable&lt;T&gt;</code> without a big workaround.  </p>
  
  <p>Does anybody know what steps I'm missing to get this to add properly?</p>
  
  <p>Thanks</p>
  
  <p>P.S.  VS 2012, asp.net 4.0</p>