Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Designer> Adding Microsoft Sql Server "System Stored Procedure" in the Relational Model Data Retrieval Wizard
 

Pages: 1
Designer
Adding Microsoft Sql Server "System Stored Procedure" in the Relational Model Data Retrieval Wizard
Page:1/1 

  Print all messages in this thread  
Poster Message
mprothme
User



Location:
Fayetteville
Joined on:
05-Oct-2017 21:57:29
Posted:
19 posts
# Posted on: 12-Aug-2019 20:18:47.  
I'd like to add a system stored procedure to my LLBLGEN PRO project. When I go to select Stored Procedures in the tree I don't see any of the ones that would normally appear in the System Stored Procedures folder. Is there any way to add these to my project?

Thanks!
  Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8071 posts
# Posted on: 13-Aug-2019 07:57:37.  
- What LLBLGen version are you using? (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7721)
- Why do you have your own SPs on the system stored procedure folder on your SQL Server? Those SPs are not retrieved as they are not meant to use it. If you really want to use them you could write your own version of that SP in the normal user defined SPs node.


David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
mprothme
User



Location:
Fayetteville
Joined on:
05-Oct-2017 21:57:29
Posted:
19 posts
# Posted on: 13-Aug-2019 20:39:09.  
We're using 5.5.

And we don't have our own sp's in that folder. Specifically, we're wanting to leverage Microsoft SQL's sp_getapplock and sp_releaseapplock stored procedures and call them through LLBLGEN Pro for a specific use case where we need to leverage distributed locking tied to the DB.

What you've recommended is what we've done. We wrapped the call to both of these procedures in our own that take the same parameters.

Quote:
Those SPs are not retrieved as they are not meant to use it.


I would argue against the above, however. It's true that most of the time you shouldn't call system stored procedures, but there are valid cases when you should (our case for example). If there were performance or implementation reasons to not allow those I would understand, but just preventing users from leveraging functionality because you typically shouldn't call them seems questionable to me.

I'm sure its low on the feature list, but it would be great if those procedures were hidden by default but you could check a box to see them as opposed to forcing developers to wrap those procedures.

Thanks!
  Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8071 posts
# Posted on: 14-Aug-2019 08:01:01.  
mprothme wrote:
What you've recommended is what we've done. We wrapped the call to both of these procedures in our own that take the same parameters.

Good to know you already found this workaround. Cool

mprothme wrote:
daelmo wrote:
Those SPs are not retrieved as they are not meant to use it.

I would argue against the above, however. It's true that most of the time you shouldn't call system stored procedures, but there are valid cases when you should (our case for example)...

...it would be great if those procedures were hidden by default but you could check a box to see them as opposed to forcing developers to wrap those procedures.

I will pass this thread to the feature request forum so it can be considered Wink


David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37476 posts
# Posted on: 14-Aug-2019 09:33:45.  
We'll look into adding a setting where you can switch on/off the retrieval of system procs. We filter them out by default as in general people won't use them. But fair point, *if* you want to use them, you should be able to. Regular Smiley
Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
mprothme
User



Location:
Fayetteville
Joined on:
05-Oct-2017 21:57:29
Posted:
19 posts
# Posted on: 16-Aug-2019 16:21:38.  
Thank you so much for your help and consideration!

  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.