Databases
StackOverflow2013
Postsdbo
POentity framework 4 function imports stored proc complex type return no column
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POentity framework 4 function imports stored proc complex type return no column
    primarykey
    data
    text
    <p>I have imported a SP to Entity Entity Data Model and added it to the function imports.</p> <p>I can get column information and create a complex type <code>GetErrorCheckJobs_Result</code>.</p> <p>However, after i added a parameter onto the sp and try to update(refresh,delete and add back) the function import, it failed to retrieve column information.</p> <p>It says: <code>the selected stored procedure returns no columns</code></p> <p>I have searched various solutions online and have </p> <pre><code>SET NOCOUNT OFF SET FMTONLY OFF </code></pre> <p>at the beginning of my SP but still no luck.</p> <p>Here is my sp:</p> <pre><code>ALTER Procedure [dbo].[s_GetErrorCheckJobs] @ErrorChecked bit as begin SET NOCOUNT OFF SET FMTONLY OFF IF OBJECT_ID('tempdb..#TempColumns') IS NOT NULL DROP TABLE #TempColumns create table #TempColumns ( AssetID int ,JobReference varchar(30) ,DetailCode varchar(4) ,Lamp varchar(255) ,pLamp varchar(255) ,LuminaireType varchar(255) ,pLuminaireType varchar(255) ,ColumnStyle varchar(255) ,pColumnStyle varchar(255) ,ColumnHeight varchar(255) ,pColumnHeight varchar(255) ,ColumnOutreach varchar(255) ,pColumnOutreach varchar(255) ) //Insert into #TempColumns //update #TempColumns select v.JobId ,v.JobReference ,v.ErrorChecked ,v.WASPAssetId ,v.StreetlightId ,v.DateReceived ,v.DateDueActual ,v.DateCompleted ,v.ActivityCodeIdActual ,v.CrewId ,v.JobCause ,v.Suburb ,v.Address ,v.Problem ,v.SpecialInstructions ,v.Notes ,t.Lamp ,t.pLamp ,t.LuminaireType ,t.pLuminaireType ,t.ColumnStyle ,t.pColumnStyle ,t.ColumnHeight ,t.pColumnHeight ,t.ColumnOutreach ,t.pColumnOutreach from v_errorcheck_jobs v join #TempColumns t on t.jobreference = v.jobreference and t.assetid = v.waspassetid where v.ErrorChecked = @ErrorChecked end </code></pre> <p>any help appreciate, thanks</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USypercubeᵀᴹ
    1. USKiddo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POentity framework 4 function imports stored proc complex type return no column
      1. This table or related slice is empty.
      1. VTUpMod
    1. COdid you try blowing away the function import and re-adding it?
      singulars
      1. POentity framework 4 function imports stored proc complex type return no column
      1. USRPM1984
    2. COyes, hundreds of times
      singulars
      1. POentity framework 4 function imports stored proc complex type return no column
      1. USKiddo
    3. COWhen this happens normally the only way to fix it is to go into the xml of the edmx and remove all traces of your complex object as well as our function import and the mapping, I normally start with the Complex Type and do a find on the name and then on the function import
      singulars
      1. POentity framework 4 function imports stored proc complex type return no column
      1. USTBohnen.jnr
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload