Hints

Table hints like NOLOCK or TABLOCK, passed straight through to SQL Server without dropping into raw SQL.

What it is

Hints are keywords injected into the generated DML to influence how SQL Server executes a command — a dirty read via NOLOCK, or an exclusive lock via TABLOCK, without writing the SQL statement by hand.

Fluent usage

var orders = connection.QueryAll<Order>(hints: "WITH (NOLOCK)");
var id = connection.Insert<Person>(person, hints: SqlServerTableHints.TabLock);

SQL Server only

The hints argument is specific to SQL Server — passing it against another provider throws, since table hints aren’t a portable SQL concept.