Skip to content

Latest commit

 

History

History
38 lines (27 loc) · 3.18 KB

csharp-overview.md

File metadata and controls

38 lines (27 loc) · 3.18 KB
title titleSuffix description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom monikerRange
What is C# Language Extension?
SQL Server Language Extensions
C# Language Extension is a feature of SQL Server used for executing external C# code. Relational data can be used in the external C# code using the extensibility framework.
WilliamDAssafMSFT
wiassaf
09/28/2021
sql
language-extensions
overview
intro-overview
>=sql-server-ver15||>=sql-server-linux-ver15

What is C# Language Extension?

[!INCLUDE SQL Server 2019 and later]

The open-source .NET C# language extension is a feature of SQL Server Language Extensions that can be used for executing C# code within SQL Server. You can pass an existing SQL Server table to a C# application as a DataFrame, perform operations in C# using rich libraries, and obtain back a result set. This C# language extension allows you to reuse existing C# code, calculations, logic, or extensive libraries that provide functionality which you cannot get in T-SQL.

The external C# language is defined with CREATE EXTERNAL LANGUAGE. The system stored procedure sp_execute_external_script is used as the interface for executing the C# code.

Note

The C# language extension is compatible with SQL Server 2019 CU3 or later. Currently, it integrates .NET core on SQL Server Windows only.

What you can do

The C# language extension uses the extensibility framework for executing external C# code. Code execution is isolated from the core engine processes, but fully integrated with SQL Server query execution. You can execute C# code at the data's source, eliminating the need to pull data across the network.

You can do data cleaning, fast data querying, or any other processing in C# that can occur through a DataFrame. By embedding C# code in stored procedures, you can push business logic down into the database for better performance. This helps avoid unnecessary data movement and latency because data does not need to be retrieved from SQL Server and moved into the app tier to do the business logic processing.

Get started

The C# language extension is not installed with SQL Server. To install and configure the C# extension, see .NET Core CSharp Language Extension. The Regex Sample tutorial shows you how to create a C# program that uses a regular expression to check text in a SQL table.

Next steps