How to reference System.Xml.Linq in SQL Server 2008 CLR Object?

Question

I want to create a CLR Stored Procedure for SQL Server 2008 that references the System.Xml.Linq assembly. According to the documentation (http://msdn.microsoft.com/en-us/library/ms403279.aspx) this assembly is safe for use in SQL Server 2008.

However when I attempt to add a reference using Visual Studio 2008 (Team Suite with GDR R2 installed) this assembly is not listed as one of the available assemblies.

Does anyone know how I can add this assembly to a SQL Server CLR project?

Answer 1

Try to click browse, then browse to C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5.

Answer 2

I have the same problem -- except I'm using Visual Studio 2005. There doesn't seem to be any way to add the DLL/Reference to my SQL CLR project.

Answer 3

Hi, This link may help you.

http://codebetter.com/blogs/rodpaddock/archive/2007/09/13/accessing-external-assemblies-from-sql-server-clr-stored-procedures.aspx