SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.

  • Thread starter Thread starter Vimal
  • Start date Start date
V

Vimal

Hi,

I have created a CLR stored procedure and want to call it using Data
Access Application block provided by Microsoft. But in this
application block when method tried to derive SP's paramter using
SqlCommandBuilder.DeriveParameters, it throws
InvalidOperationException and give error message "The stored procedure
<SPName> does'nt exist".

Please provide me insight to solve this problem.

Thanks in advance.

Vimal
 
Ah, I'm not surprised that the CB can't interface with a CLR executable.
It's really designed to build the CRUD for specific data tables, not rowsets
returning from SPs.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Ah, I'm not surprised that the CB can't interface with a CLR executable.
It's really designed to build the CRUD for specific data tables, not rowsets
returning from SPs.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speakerwww.betav.com/blog/billvawww.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visitwww.hitchhikerguides.netto get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
---------------------------------------------------------------------------­--------------------------------------------










- Show quoted text -
Click to expand...

Does it mean Parameters of CLR sp can not be derived using
DeriveParameters method of CB?
 
Back
Top