Arithmetic ADD operator

SQL Server Query

            
SELECT  

    ProductID,  

    ProductName,  

    UnitPrice + (UnitPrice * 0.10) AS NewPrice -- Add 10% to the UnitPrice  

FROM Products;  

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

    .Select()  

    .Columns("ProductID", "ProductName")  

    .Column(new ColumnArithmatic("UnitPrice").ADD().StartBracket("UnitPrice").MULTIPLY(0.10).EndBracket()  

    , "NewPrice")  

    .From("Products")  

    .Build();  

            
        

Query build by SqlQueryBuilder

            
SELECT ProductID,
       ProductName,
       UnitPrice + (UnitPrice * @pMAIN_2507200128177160440) AS NewPrice
FROM Products;


            
        

Parameters (If used)

Query Results: