Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Using SQL Server Common Language Runtime Integration 

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#. 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.

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.

NoteNote

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. For more detailed information, see the "Database Engine .NET Framework Programming" section in SQL Server 2005 Books Online.

In This Section

Introduction to SQL Server CLR Integration

Provides an introduction to SQL Server CLR integration.

CLR User-Defined Functions

Describes how to implement and use the various types of CLR functions: table-valued, scalar, and user-defined aggregate functions.

CLR User-Defined Types

Describes how to implement and use CLR user-defined types.

CLR Stored Procedures

Describes how to implement and use CLR stored procedures.

CLR Triggers

Describes how to implement and use CLR triggers.

SQL Server In-Process Specific Behavior of ADO.NET

Describes the SQL Server in-process specific extensions to ADO.NET, and the context connection.

Related Sections

What's New in ADO.NET

Introduces features that are new in ADO.NET.

Overview of ADO.NET

Provides an introduction to the design and components of ADO.NET.

Securing ADO.NET Applications

Describes secure coding practices when using ADO.NET.

Using DataSets in ADO.NET

Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

Modifying Data in ADO.NET

Describes how to modify data in a database and how to use transactions.

Connecting and Retrieving Data in ADO.NET

Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.

Using the .NET Framework Data Provider for SQL Server

Describes how to work with features and functionality that are specific to SQL Server.

Using the .NET Framework Data Provider for Oracle

Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.

Writing Provider-Independent Code in ADO.NET

Describes generic classes that allow you to write provider-independent code in ADO.NET.

Performing General Tasks in ADO.NET

Describes how to use various general-purpose features of ADO.NET.

Finding Additional ADO.NET Information

Provides links to additional online information about ADO.NET.

See Also

Other Resources

ADO.NET

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft