Tuesday, March 6, 2012

.NET assembly

Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with COM
objects
Thanks"Julio Delgado" <jdelgado89@.hotmail.com> wrote in message
news:u%23ll%23BhwGHA.888@.TK2MSFTNGP02.phx.gbl...
> Can I reference a .NET assembly in MS-SQL 2005 Workgroup like we do with
> COM objects
Yes CLR integration is available in every edition of SQL Server 2005. But
.NET isn't COM, and the procedure is different. You need to install the all
required assemblies in SQL with CREATE ASSEMBLY (or let Visual Studio do it
for you). Then surface specially written .NET methods as a clr stored
procedures or functions.
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learning/prog/clr/default.aspx
David

No comments:

Post a Comment