Queries for ROWLOCK Table Hint

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

SQL Server Query 1

            
 BEGIN TRANSACTION 

 SELECT  

     OD.OrderID,  

     OD.ProductID,  

     OD.Quantity,  

     OD.UnitPrice  

 FROM [Order Details] AS OD WITH (ROWLOCK)  

 WHERE OD.Quantity > 5  

 ORDER BY OD.OrderID, OD.ProductID;  

 ROLLBACK TRANSACTION 

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("OD.OrderID","OD.ProductID","OD.Quantity","OD.UnitPrice")  

     .From("[Order Details]", "OD", new List<IHint>() { new ROWLOCK() })  

     .Where(new Where(new Column("OD.Quantity").GreaterThan(5)))  

     .OrderBy(new OrderBy().SetColumnAscending("OD.OrderID")  

                           .SetColumnAscending("OD.ProductID"))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OD.OrderID,
       OD.ProductID,
       OD.Quantity,
       OD.UnitPrice
FROM [Order Details] AS OD WITH (ROWLOCK)
WHERE OD.Quantity > @pMAIN_2507200147312956860
ORDER BY OD.OrderID ASC, OD.ProductID ASC;


            
        

Parameters (If used)

Query Results 1: