Wednesday, March 7, 2012

How to create a assembly

Hi,

I have one ClassLibrary three member functions.I have the dll for this...Can some one please tell me how to create a Assembly in .NET.

I need to create a simple private assembly with the dll that i have.

Thanks

Did you check out the CLR programmability samples? See below link:

http://msdn2.microsoft.com/en-us/library/ms160894.aspx

You can use CREATE ASSEMBLY DDL to create assembly in SQL Server or use the Visual Studio GUI. See Books Online for more details.

|||

I am guessing that this is for SQL Server.

create assembly AssemblyName
from '<path>\AssemblyName.dll'
go

--Then you can declare the objects within using syntax like:
CREATE FUNCTION [dbo].[DeployName](@.ParameterName [nvarchar](4000))
RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [AssemblyName].[RootNamespace.ClassName].[FunctionName]
GO

Or do you mean what you have to do to build the code to make the assembly ready for SQL Server?

No comments:

Post a Comment