Usage

var services = new ServiceCollection() 
                       .AddDbContext<DemoDbContext>(builder => builder
                               .UseSqlServer("conn-string", 
                                             options => options.AddTableHintSupport());

// starts a database transaction
using var rootTx = myDbContext.Database.BeginTransaction();

var product = myDbContext.Products
                         .WithTableHints(SqlServerTableHint.RowLock, SqlServerTableHint.UpdLock)
                         .FirstOrDefaultAsync(p => p.Id == id);