SQL Eval Function API

Overview

Let's take a very short overview with the API

SELECT SQLNET::New('x+y').ValueInt('x', 1).ValueInt('y', 2).EvalInt() as Result

include component-try-it.html href='http://sqlfiddle.com/#!18/9eecb/1123' %}

• 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 creates a new instance of SQLNET Type
• ValueInt: Sets a int value for a specific parameter name used in the expression
• EvalInt: Evaluates the expression and return a result of type INT