Database Engine .NET Framework Programming
Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. This means that you can now write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
重要提示: |
---|
By default, the .NET Framework is installed with SQL Server 2005, but the .NET Framework SDK is not. Without the SDK installed on your computer and included in the Books Online collection, links to SDK content in this section do not work. Install the .NET Framework SDK. Once installed, add the SDK to the Books Online collection and table of contents by following the instructions in 下载和更新联机丛书. |
The following table lists the topics in this section.
Topic | Description |
---|---|
Provides a brief overview of the CLR, and describes how and why this technology has been used in SQL Server. Describes the benefits of using the CLR to create database objects. |
|
Building Database Objects with Common Language Runtime (CLR) Integration |
Describes the kinds of objects that can be built using the CLR, and reviews the requirements for building CLR database objects. |
Describes how a CLR routine can access data stored in an instance of SQL Server. |
|
Discusses the CLR integration security model. |
|
Describes limitations of and requirements for debugging CLR database objects. |
|
Discusses deploying assemblies to production servers. |
|
Describes how to create and drop CLR integration assemblies. |
|
Usage Scenarios and Examples for Common Language Runtime (CLR) Integration |
Describes usage scenarios and code samples using CLR objects. |
请参阅
其他资源
程序集(数据库引擎)
安装 .NET Framework SDK