TypedDataContext stored proc definitions of MSSQL master database - no parameters?
Options
In the connection manager... I see that the proc definitions for procs in databases other than MSSQL master have the parameter definitions. Only parameterless definitions are shown for master database. And no surprise... the datacontext in any code using a connection to the master database then knows nothing about the parameters.
My scenario... I am using some of the procs that come with Brent Ozar's First responder Kit. (https://www.BrentOzar.com/first-aid/). The procs will typically end up getting added to the master database. The procs produce excellent output when run without parameters. But if one wishes to filter down or zero in on something, the parameters are needed. No joy in Mudville... I have to write SqlClient code instead of the handy data context method that has admittedly spoiled me.
Intended? Oversight? Perhaps the pattern I believe I see can be reasonably explained?
My scenario... I am using some of the procs that come with Brent Ozar's First responder Kit. (https://www.BrentOzar.com/first-aid/). The procs will typically end up getting added to the master database. The procs produce excellent output when run without parameters. But if one wishes to filter down or zero in on something, the parameters are needed. No joy in Mudville... I have to write SqlClient code instead of the handy data context method that has admittedly spoiled me.
Intended? Oversight? Perhaps the pattern I believe I see can be reasonably explained?
Comments
-
It's a bug that's so far unreported.
I'll include a fix in the next beta build. -
Awesome! Thanks Joe!
-
Just a thought... if it turns out to something that might cause a slow startup or something like that.... make it an option on persisted connections rather than a default behavior.
-
The fix won't affect performance.
-
This is now fixed in the 5.21 beta:
http://www.linqpad.net/download.aspx#beta -
Alas... I have not been able to get my boss to pay the paltry sum to upgrade from v4.