Content deleted Content added
Line 144:
When writing code for SQL CLR, data stored in SQL Server databases can be accessed using the [[ADO.NET]] [[API]]s like any other [[managed code|managed application]] that accesses SQL Server data. However, doing that creates a new database session, different from the one in which the code is executing. To avoid this, SQL Server provides some enhancements to the [[ADO.NET]] provider that allows the connection to be redirected to the same session which already hosts the running code. Such connections are called context connections and are set by setting <code>context connection</code> parameter to <code>true</code> in the connection string. SQL Server also provides several other enhancements to the [[ADO.NET]] API, including classes to work with tabular data or a single row of data as well as classes to work with internal metadata about the data stored in the database. It also provides access to the XML features in SQL Server, including [[XQuery]] support. These enhancements are also available in T-SQL Procedures in consequence of the introduction of the new XML Datatype (query, value, nodes functions).<ref name="xmlsupport" />
==
SQL Server also includes an assortment of add-on services. While these are not essential for the operation of the database system, they provide value added services on top of the core database management system. These services either run as a part of some SQL Server component or out-of-process as [[Windows Service]] and presents their own [[API]] to control and interact with them.
| |||