Entity framework for execute string stored procedure

Question

New to EF... using 6.0. I've have a Stored Proc which has the dynamic build select query inside a string variable that outputs using Execute(@StringQuery). This select has around 20 columns.

After adding this SP in EF, the return type is INT (not sure why). But I think I've to add all the columns manually in Complex types in EDMX. Wanted to know whether there is any better way to handle this as the columns are in huge number.

Please suggest.

Procedure Text:

DECLARE @StringQuery VARCHAR(MAX)
SET @StringQuery = 'SELECT AROUND 20 COLUMNS WITH LOT OF CONDITIONS ADDED'

EXECUTE(@StringQuery)

Giorgi Nakeuri · Accepted Answer · 2015-02-03 06:57:59Z

1

Open your model
Go to View->Other Windows->Entity Data Model Browser
In browser expand your Model->Function Imports and double click on Stored Proc
In Returns a Collections off choose Complex and press Get Column Information
Click Create New Complex Type
OK, Save

answered Feb 3, 2015 at 6:57

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Interstellar Over a year ago

When I do that, I get message saying 'The selected stored procedure or function returns no columns' and OK button is disabled.

Giorgi Nakeuri Over a year ago

Can you paste you Procedure text?

Interstellar Over a year ago

I've added a sample of procedure how it looks like

Giorgi Nakeuri Over a year ago

Do you have logic in Storec proc which builds dynamic query? Try at top of your procedyre SET FMTONLY OFF

Giorgi Nakeuri Over a year ago

Also read this. stackoverflow.com/questions/7128747/…

Collectives™ on Stack Overflow

Entity framework for execute string stored procedure

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related