JavaScript Editor Ajax toolkit     Ajax tutorials 

Main Page

Previous Page
Next Page

4.3. Required .NET Namespaces

The components needed to create simple CLR routines are installed with SQL Server 2005 in the .NET Framework assembly named System.Data.dllpart of the base class library of the .NET Framework and located in both the Global Assembly Cache (GAC) and in the <windir>\Microsoft.NET\Framework\<version> directory. The key namespaces in this assembly are described in Table 4-2.

Table 4-2. .NET namespaces for CLR routines

System.Data.dll namespaces



Classes that comprise the ADO.NET architecture


Classes that support SQL Server 2005-specific functionality


Classes that support .NET CLR functionality inside SQL Server CLR routinesuser-defined functions (UDFs), stored procedures, UDA functions, UDTs, and triggers


Classes that support native SQL Server data types


.NET Frameworks data provider for SQL Server

Previous Page
Next Page

JavaScript Editor Ajax toolkit     Ajax tutorials