title: Creating entities from stored procedures which have dynamic sql
body: <p>I have a stored procedure which uses a couple of tables and creates a cross-tab result set. For creating the cross-tab result set I am using CASE statements which are dynamically generated on basis of records in a table.</p>
  
  <p>Is it possible to generate an entity from this SP using ADO.NET Entity framework? Cuz each time I try <code>Get Column Information</code> for the particular SP, it says that <code>The selected stored procedure returns no columns</code>.</p>
  
  <p>Any help would be appreciated.</p>