SqlCommandBuilder.DeriveParameters not working for CLR Stored Procedure.

[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

 

[William \(Bill\) Vaughn]

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)

 

[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 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 -

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