Yesterday we had a problem accessing property (attribute) in assembly, which is created over some dll.
For more about assemblies, please read this article.
It is not a problem create function over some method in assembly, but If you want to access some parameter, following trick should be used.
Instead of creating function over parameter name, add prefix get_ before parameter name, as shown in following code:
CREATE FUNCTION dbo.SomeFunction ()
RETURNS [nvarchar](128) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [AssemblyName].[NamespaceName].get_PropertyName
GO
One of my colleagues helped me with this and I am thankful for that.
For more about assemblies, please read this article.
It is not a problem create function over some method in assembly, but If you want to access some parameter, following trick should be used.
Instead of creating function over parameter name, add prefix get_ before parameter name, as shown in following code:
CREATE FUNCTION dbo.SomeFunction ()
RETURNS [nvarchar](128) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [AssemblyName].[NamespaceName].get_PropertyName
GO
One of my colleagues helped me with this and I am thankful for that.
No comments:
Post a Comment