Refreshing Stored Procedures

Posts   
 
    
llahman
User
Posts: 1
Joined: 13-Feb-2012
# Posted on: 13-Feb-2012 01:31:17   

I just downloaded and installed your trial today.

I am also relatively new to Entity Framework, but have some issues with the technology when refreshing stored procedures and views.

I have a large application with some complex data structures that require the use of "dynamic stored procedures" -- or stored procedures where the actual names of certain fields referenced are changed via parameters at run-time.

To accomplish this with "mapping" software, I have to first code the stored procedure using specific fields and the "AS" clause, save the stored procedure, "map" it, and then modify the stored procedure to use parameters to replace certain field names (but always using the "AS" named fields in the output).

In Entity Framework, I cannot allow a global "refresh" otherwise I "lose" the first version of the stored procedures and the resulting "dynamic" sp's are then unusable.

Is there a way, using your tools, to "mark" certain stored procedures so that they will not be refreshed unless I manually override them?

If I didn't explain myself well, please advise and I will include some sample sql code.

Thanks in advance!

Lynn

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 13-Feb-2012 10:22:37   

Removing a database element from the refresh wizard will signal its removal from the catalog explorer and hence the mapping with the project element will be removed too.