Queries for XLOCK Table Hint

1. Usage of XLOCK table hint (to be used in transaction)

SQL Server Query 1

            
 BEGIN TRANSACTION;  

 SELECT ProductID, ProductName, UnitPrice  

 FROM Products WITH (XLOCK, ROWLOCK)   

 ROLLBACK TRANSACTION;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("ProductID", "ProductName", "UnitPrice")  

     .From("Products", new List<IHint>() { new XLOCK(), new ROWLOCK() })  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT ProductID,
       ProductName,
       UnitPrice
FROM Products WITH (XLOCK, ROWLOCK);


            
        

Parameters (If used)

Query Results 1: