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

\clrlinq-to-xmlsql-server-2008visual-studio-2008

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?

Best Answer

This link may help you.

[...] the “external” assembly must be “pre-deployed” to the server.

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

SQL Server 2005 onwards:

IF EXISTS(SELECT 1 FROM sys.columns 
          WHERE Name = N'columnName'
          AND Object_ID = Object_ID(N'schemaName.tableName'))
BEGIN
    -- Column Exists
END

Martin Smith's version is shorter:

IF COL_LENGTH('schemaName.tableName', 'columnName') IS NOT NULL
BEGIN
    -- Column Exists
END

Which should I install first: Visual Studio 2008 or SQL Server 2008

I install the Developer Edition of SQL Server instead of the SQL Server Express edition that comes with VS2008. I find that the install works better if you install SQL Server first, that way there is no need to uninstall the Express edition before installing SQL Server Developer edition. I don't recommend having both editions installed. I had no end of problems until I figured out that having two versions installed was the issue. Uninstalling VS and SQL Server Express may be necessary, but I believe it was enough just to uninstall SQL Server Express and (re)install SQL Server Developer edition.

Best Answer

Related Solutions

Sql-server – How to check if a column exists in a SQL Server table

Which should I install first: Visual Studio 2008 or SQL Server 2008

Related Topic