Hi, My question is first is it possible to return records from a clr procedure that is called from a VB.net interface. The CLR proc is using SQL context and a pipe to return the records. The proc works fine as far as returning results when used by itself. I have tried to figure out the interface part by creating a console application and then writing the code for the interface to call it but I get nothing returned. Any clue?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
vb.net Interface calling a CLR procedure
- Thread starter yeltom
- Start date
I'm not following what exactly you are trying to do, but wouldn't you just call the proc through ADO the way you would a normal t-sql proc?
Hope this helps,
Alex
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
Hope this helps,
Alex
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
- Thread starter
- #3
Yes that is normally the case, calling the proc with ADO.net. I was asked to have the clr procedure be implmented by an interface
Interface ICLRmethod
CLRmethod(P1,P2)
End interface
I think I may have the syntax wrong or the wrong type of project. I don't know. Never had this type of request before.
Interface ICLRmethod
CLRmethod(P1,P2)
End interface
I think I may have the syntax wrong or the wrong type of project. I don't know. Never had this type of request before.
This doesn't make much sense. I don't see why you couldn't add an interface to a CLR method (you would have to nest it I believe), but I also don't really see why you would want to?
Even if you had an interface in there, you wouldn't really be able to use it polymorphically as such because you'd still need to execute the proc through ADO.net.
Can you show what your CLR Method is doing? Maybe that will help clear things up a bit.
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
Even if you had an interface in there, you wouldn't really be able to use it polymorphically as such because you'd still need to execute the proc through ADO.net.
Can you show what your CLR Method is doing? Maybe that will help clear things up a bit.
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
- Status
