VB.net Dll Functions in SQL Server

Question

I have a dll written in vb.net. i added a class with some functions that require a date/time for the function and return a string. The functions work fine in a test app. However i want to add that assembly to an SQL server and have a function in SQL to execute the code. I can create the assembly in SQL Server no errors. I would have thought the functions would show up under Scalar functions, but nothing. Any ideas on what i am missing or directions to where i can find valid info? BTW, i've not used forums in ages.. hopefully i am in the right spot.

Answer 1

Hi @Shafer, Brian A. (NSGAL) ,

Please check your steps follow MS document CLR Scalar-Valued Functions to check if you missing some steps when you create Scalar Function in SQL server. Please make sure the SQL server query running under the correct database.

I am not familiar with VB.net environment, so I can only do a simple test for you.

If I misunderstood your issue, please let me know.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Any ideas on what i am missing

Just adding a CLR assembly is not enough, how should SQL Server know what to appose how? You have to Create CLR Functions.