Locking behavior

To ensure data integrity, the RDBMS uses a locking mechanism when updating a database table. The LN MSQL database driver can direct the SQL Server to choose a particular lock level when executing a query. Before understanding the LN MSQL database driver locking strategy, you must first understand the SQL Server locking mechanisms.