Section 4.3. Required .NET Namespaces


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

Description

System.Data

Classes that comprise the ADO.NET architecture

System.Data.Sql

Classes that support SQL Server 2005-specific functionality

Microsoft.SqlServer.Server

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

System.Data.SqlTypes

Classes that support native SQL Server data types

System.Data.SqlClient

.NET Frameworks data provider for SQL Server




Programming SQL Server 2005
Programming SQL Server 2005
ISBN: 0596004796
EAN: 2147483647
Year: 2007
Pages: 147
Authors: Bill Hamilton

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net