SQL Server 公共语言运行时集成SQL Server Common Language Runtime Integration

SQL Server 2005 引入了 Microsoft Windows 的 .NET Framework 的公共语言运行库 (CLR) 组件的集成。SQL Server 2005 introduced the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. 这意味着您可以使用任意 .NET Framework 语言(包括 Microsoft Visual Basic .NET 和 Microsoft Visual C#)编写存储过程、触发器、用户定义类型、用户定义函数、用户定义聚合函数以及流处理表值函数。This means that you can 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#. Microsoft.SqlServer.Server 命名空间包含一组新的应用程序编程接口 (API),使托管代码可以与 Microsoft SQL Server 环境交互。The Microsoft.SqlServer.Server namespace contains a set of new application programming interfaces (APIs) so that managed code can interact with the Microsoft SQL Server environment.

本节介绍 SQL Server 公共语言运行库 (CLR) 集成特定的功能和行为以及 SQL Server 进程中专用的 ADO.NET 扩展。This section describes features and behaviors that are specific to SQL Server common language runtime (CLR) integration and the SQL Server in-process specific extensions to ADO.NET.

本节只是为了提供足够的信息,以便开始使用 SQL Server CLR 集成编程,而并非为了提供完整的信息。This section is meant to provide only enough information to get started programming with SQL Server CLR integration, and is not meant to be comprehensive. 有关更多详细信息,请参见您正在使用的 SQL Server 版本的“SQL Server 联机丛书”版本。For more detailed information, see the version of SQL Server Books Online for the version of SQL Server you are using.

SQL Server 联机丛书SQL Server Books Online

  1. 公共语言运行时 (CLR) 集成编程概念Common Language Runtime (CLR) Integration Programming Concepts

本节内容In This Section

SQL Server CLR 集成简介Introduction to SQL Server CLR Integration
简介 SQL Server CLR 集成。Provides an introduction to SQL Server CLR integration. 提供指向其他主题的链接。Provides links to additional topics.

CLR 用户定义的函数CLR User-Defined Functions
描述如何实现和使用各种类型的 CLR 函数:表值函数、标量值函数以及用户定义聚合函数。Describes how to implement and use the various types of CLR functions: table-valued, scalar, and user-defined aggregate functions.

CLR 用户定义的类型CLR User-Defined Types
描述如何实现和使用 CLR 用户定义类型。Describes how to implement and use CLR user-defined types. 提供指向其他主题的链接。Provides links to additional topics.

CLR 存储过程CLR Stored Procedures
描述如何实现和使用 CLR 存储过程。Describes how to implement and use CLR stored procedures. 提供指向其他主题的链接。Provides links to additional topics.

CLR 触发器CLR Triggers
描述如何实现和使用 CLR 触发器。Describes how to implement and use CLR triggers. 提供指向其他主题的链接。Provides links to additional topics.

上下文连接The Context Connection
介绍上下文连接。Describes the context connection.

ADO.NET 的 SQL Server 进程内特定行为SQL Server In-Process-Specific Behavior of ADO.NET
介绍 SQL Server 进程中专用的 ADO.NET 扩展以及上下文连接。Describes the SQL Server in-process specific extensions to ADO.NET, and the context connection. 提供指向其他主题的链接。Provides links to additional topics.

请参阅See Also

SQL Server 和 ADO.NETSQL Server and ADO.NET
在托管代码中创建 SQL Server 2005 对象Creating SQL Server 2005 Objects In Managed Code
ADO.NET 托管提供程序和数据集开发人员中心ADO.NET Managed Providers and DataSet Developer Center