System stored procedures are not available in LINQ to SQL
-
I want to use "sp_fkeys" system stored procedures inside LINQ to SQL.But all system stored procedures are not available in Server explorer to drag and drop into function pans in LINQ to Sql designer.Please tell me how i can get.
M.Sendilkumar
-
I want to use "sp_fkeys" system stored procedures inside LINQ to SQL.But all system stored procedures are not available in Server explorer to drag and drop into function pans in LINQ to Sql designer.Please tell me how i can get.
M.Sendilkumar
One option would be make your own stored procedure that simply calls the system one. Then call your user-created sproc from LINQ.
Tech, life, family, faith: Give me a visit. I'm currently blogging about: Feelings-Based Morality of the Secular World The apostle Paul, modernly speaking: Epistles of Paul Judah Himango
-
One option would be make your own stored procedure that simply calls the system one. Then call your user-created sproc from LINQ.
Tech, life, family, faith: Give me a visit. I'm currently blogging about: Feelings-Based Morality of the Secular World The apostle Paul, modernly speaking: Epistles of Paul Judah Himango
It is good idea.I tried.It is working for
sp_pkeysstored procedure,but not forsp_fkeys.Ok! The issue is,access rights to sysinformation.If the user has enough rights to accesssys ,sp_****procs can be accessed from server explorer to LINQ to Sql DataContext designer.M.Sendilkumar