Sql Server CLR Functions

Question

While writing a CLR function Sql Server can we use namespaces ?

namespace SomeName1.SomeName2
{
   public static class SomeClass
   {
       [SqlFunction]
       public static SqlString SomeMethod(SqlString input)
       {
          // ....
       }
   }
}

If so, then how do we call this function from SqlServer. In other words how do we call CLR functions from SQL Server with namespaces?

Yuck · Accepted Answer · 2011-07-27 18:48:38Z

7

Yes, you absolutely can:

CREATE FUNCTION SomeMethod(@input VarChar(200))
RETURNS VarChar(200) WITH EXECUTE AS CALLER AS

EXTERNAL NAME [SomeName1.SomeName2].[SomeName1.SomeName2.SomeClass.SomeMethod]

Where [SomeName1.SomeName2] in the first part is the assembly as named in SQL Server, and the rest ([SomeName1.SomeName2.SomeClass.SomeMethod]) is the fully qualified function name, including the namespace.

Incidentally, if you deploy from Visual Studio it handles a lot of this for you.

answered Jul 27, 2011 at 18:48

Yuck

51.1k13 gold badges108 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Deb Over a year ago

I just figured that out. I was about to answer that. [AssemblyName][Namespace.Class].[Method]. Thanks !

Deb Over a year ago

It would actually be [AssemlyName] then the rest goes as [SomeName1.SomeName2.SomeClass].[SomeMethod]

Yuck Over a year ago

Correct. I'm assuming your assembly name follows that of the namespace being defined here.

Colin Over a year ago

@Debjit - just a typo correction to your comment: [AssemblyName].[Namespace.Class].[Method]. Thanks!

Collectives™ on Stack Overflow

Sql Server CLR Functions

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related