Microsoft open sources .NET 5 C# Language Extension for SQL Server
(8 September 2021)

Other recent news...

Microsoft highlights .NET 8 Hardware Intrinsics features
Additional hardware functionality via APIs so the bespoke web apps we develop can take advantage of users' underlying hardware, e.g. WebAssembly support so that core algorithms can...
11 December 2023
Google launches Gemini AI model
Gemini was designed for flexibility, so it can run on everything from data centres to mobile devices. It's been optimized for three different sizes: Ultra, Pro and Nano (for on-dev...
6 December 2023
Apple launches release candidate versions of iOS 17.2 & iPadOS 17.2
Developing and testing our bespoke Apple iOS apps on beta versions of iOS 17.2 & iPadOS 17.2 allows our app developers to confirm that the apps we develop will work as expected...
5 December 2023
Microsoft open sources .NET 5 C# Language Extension for SQL Server
For over two decades, the C# programming language has allowed developers to build secure and robust applications within the .NET ecosystem. New Media Aid's app engineers have been coding .Net apps in C# for all those two decades! Today Microsoft announced that they are open sourcing the .NET 5 C# Language Extension for SQL Server on GitHub.
 
This extension allows our app developers to have the freedom to use existing SQL Server tables which they can pass to a C# application as a DataFrame. Then, they can perform operations in C#, use the rich libraries, and obtain back a result set.
 
One of the reasons to use C# is to reuse existing customer C# code, calculations, logic, or extensive libraries that provide functionality which you cannot get in T-SQL.
 
Our app engineering team here at New Media Aid are experimenting with the .NET 5 C# Language Extension and hope to build on it.
 
Some of the advantages of using C# inside SQL Server are listed below:
  • Data cleaning.
  • Fast data querying.
  • Any processing in C# can now occur through a DataFrame.
  • Customers are not limited to the T-SQL language surface area.
  • C# application development teams that leverage SQL Server as backend storage can now even embed C# code in stored procedures which enables pushing business logic down into the database for better performance.
  • Avoid unnecessary data movement and latency when data must be retrieved from SQL Server and moved into the app tier to do the business logic processing.
Why open source?
Like Java, Python, and R have open-source language extensions, it is a natural next step to open source the .NET 5 C# Language Extension. This language extension leverages the Extensibility Framework API for SQL Server and this API is publicly documented.
 
The API along with the open-source code of the .NET Core C# language extension shows an example of how a programming language extension can be built. Now, more developers in the SQL Server community can continue to develop additional programming language extensions.

more news...