Security BINARY_CHECKSUM SQL function

1. Usage of BINARY_CHECKSUM.

SQL Server Query 1

            
 SELECT BINARY_CHECKSUM(EmployeeID, LastName, FirstName, PostalCode, Photo, LEN(PhotoPath),  

 (SELECT Address FROM Employees where EmployeeID = 1)) AS BinaryCheckSum  

 FROM Employees  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new BINARY_CHECKSUM(new Column("EmployeeID"), new Column("LastName"), new Column("FirstName"),   

         new Column("PostalCode"), new Column("Photo"), new LEN(new Column("PhotoPath")),  

         new SqlQueryBuilder().Select().Column("Address", "Address").From("Employees")  

             .Where(new Where(new Column("EmployeeID").Equale(1)))), "BinaryCheckSum")  

     .From("Employees")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT BINARY_CHECKSUM(EmployeeID, LastName, FirstName, PostalCode, Photo, LEN(PhotoPath), (SELECT Address AS Address
                                                                                            FROM Employees
                                                                                            WHERE EmployeeID = @pMAIN_2512060923068096260)) AS BinaryCheckSum
FROM Employees;


            
        

Parameters (If used)

Query Results 1: