SqlServer 无法加多种锁 .With(SqlWith.UpdLock).With(SqlWith.RowLock 返回

实例

var a = await _invRepository.AsQueryable()

    .With(SqlWith.UpdLock)

    .With(SqlWith.RowLock)

    .With(SqlWith.ReadPast)

    .ToListAsync();

// SQLSugar生成的SQL语句

 SELECT * FROM [WMS_InventoryDetail] 

WITH(READPAST) 

// 实际我需要生成的SQL语句

SELECT * FROM [WMS_InventoryDetail] 

WITH(READPAST,UPDLOCK, ROWLOCK)