SELECT predicate WHERE and ORDER BY

SQL Server Query

            
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice,  

UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued  

FROM Products  

WHERE CategoryID >= 5  

ORDER BY SupplierID; 

            
        

Create SQL query with SqlQueryBuilder

            
var (sql, parameters) = new SqlQueryBuilder()  

  .Select()  

  .Columns("ProductID", "ProductName", "SupplierID", "CategoryID", "QuantityPerUnit")  

  .Columns("UnitPrice", "UnitsInStock", "UnitsOnOrder", "ReorderLevel", "Discontinued")  

  .From("Products")  

  .Where(new Where(new Column("CategoryID").GreaterThanOrEqualeTo(5)))  

  .OrderBy(new OrderBy().SetColumnAscending("SupplierID"))  

.Build(); 

            
        

Query build by SqlQueryBuilder

            
SELECT ProductID,
       ProductName,
       SupplierID,
       CategoryID,
       QuantityPerUnit,
       UnitPrice,
       UnitsInStock,
       UnitsOnOrder,
       ReorderLevel,
       Discontinued
FROM Products
WHERE CategoryID >= @pMAIN_2507200206539574900
ORDER BY SupplierID ASC;


            
        

Parameters (If used)

Query Results: