开发者

How to use a system stored procedure in LINQ to SQL

开发者 https://www.devze.com 2022-12-22 22:08 出处：网络

I\'d like to add the \"msdb.dbo.sp_help_job\" system stored procedure to a LINQ to SQL object, b开发者_运维技巧ut I can\'t figure out how to specify it. If I create a new Data Connection in Server Exp

相关专题：linq linq-to-sql sql-server sql-server-2008 system-stored-procedures

I'd like to add the "msdb.dbo.sp_help_job" system stored procedure to a LINQ to SQL object, b开发者_运维技巧ut I can't figure out how to specify it. If I create a new Data Connection in Server Explorer and specify the "msdb" database of the server I want, and navigate to "Stored Procedures", that procedure is not listed. Am I looking in the wrong place?

I've added regular (user defined) stored procedures in the past with no problem. I know I could get there by executing it via "ExecuteCommand" on the data context, and I could also create a "wrapper" stored procedure that did nothing but call "sp_help_job", but I'd like to know how to hook it up directly to LINQ, or if it's even possible.

The System Stored Procedures are not actually sitting inside your database, but rather the Read-Only Resource database.

http://msdn.microsoft.com/en-us/library/ms190940.aspx

However, here's how you can make it possible to find them:

Accessing System Databases/Tables using LINQ to SQL?