You find a bug when compiling? Report it and it will be fixed usually within one business day.
All namespace support by SQL CLR are supported by Eval SQL.NET.
- All common namespace and extensions method can be used without specifying the fullname.
You can see the full list here
Let us know if you believe we have missing some.
You are worried about performance? Don’t worry, Eval SQL.NET is super-fast and can evaluate over 150,000 expressions in a loop under one second and over 1,000,000 using a table!
Result highly vary depending of your SQL Server performance and expression to evaluate.
SQL CLR allow three type of permission:
- UNSAFE Eval SQL.NET support all types and is installed by default with SAFE permissions. Read more about SQL CLR Permissions
This library allow to use parameter, so no SQL Injection is possible!
However if you build the string to evaluate as you build a dynamic SQL, then there is nothing we can do for you.
Decimal throw an error!
In C#, decimal must be suffixed with “m” to make them valid. By default “1.1” in C# is a double which cannot be added with decimal value.