Uredi

What is C# Language Extension?

  • Članak
  • 2 min. za čitanje

Applies to: yesSQL Server 2019 (15.x)

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