dotnetcore / dotnetcore/FreeSql

mysql和postgresql悲观锁skip locked

Open
#2,017 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
4.4k
Forks
910
PR merge metrics
No merged PRs in 30d

Description

#### Feature 特性
mysql和postgresql悲观锁for update语句的skip locked后缀可以跳过被锁定的行
```c#
// c# code
```

#### 简要描述原因
功能增强
```c#
// c# code
```

#### 使用场景
任务队列场景,每次取一个任务跳过正在处理的任务
```c#
fsql.Select().Where(xxx).ForUpdate(skipLocked: true).ToOne();
// c# code
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.