Let take a very short overview with the API


SELECT SQLNET::New('x+y').ValueInt('x', 1).ValueInt('y', 2).EvalInt() as Result
  • SQLNET: A CLR Type created by Eval SQL.NET library
  • ”::”: This is how you call static method in SQL CLR
  • New: A static method which create a new instance of SQLNET Type
  • ValueInt: Set a int value for a specific parameter name used in the expression
  • EvalInt: Evaluate the expression and return a result of type INT