With the OutSystems Platform Enterprise Cloud you can use the SQL Server feature to deploy Common Language Runtime Assemblies directly on the database functions. This way you can deploy .Net functions directly on the database server that can improve the scalability of your data logic and data processing requirements.
In this post you will find information on how to create and deploy an assembly with functions that can be used directly on the database server as if they were relational database functions. All the functions you create should be created under a specific customer schema provided by OutSystems upon request.
Before we start, note that the deployment of CLR assemblies is separate from OutSystems Platform’s automatic deployment mechanisms (Lifetime) and should be treated as an external dependency that needs to be kept in sync.
This means that if you change the CLR assembly in one environment, you have to make sure you change it in other environments as well.
Deploying applications via Lifetime won't automatically update the target environment's CLR assembly.