tsanie/Billing
1
1
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity

ExecuteAsync 中无法一次执行多条语句 #1

New Issue
Closed
opened 2022-03-30 09:52:49 +08:00 by tsanie · 1 comment
tsanie commented 2022-03-30 09:52:49 +08:00
Owner
Copy Link

1072a1a15c/Billing.Shared/Store/StoreHelper.cs (L209)

建议引入事务处理。

await database.RunInTransactionAsync(conn =>
{
    conn.Execute("DELETE FROM [Logs]");
    conn.Execute("DELETE FROM [sqlite_sequence] WHERE [name] = 'Logs'");
});
https://git.tsanie.org:6443/tsanie/Billing/src/commit/1072a1a15c50ad54e1dc8079f73aed05ba7373b1/Billing.Shared/Store/StoreHelper.cs#L209 建议引入事务处理。 ``` await database.RunInTransactionAsync(conn => { conn.Execute("DELETE FROM [Logs]"); conn.Execute("DELETE FROM [sqlite_sequence] WHERE [name] = 'Logs'"); }); ```
tsanie commented 2022-04-11 15:09:07 +08:00
Author
Owner
Copy Link

已经解决。

已经解决。
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
tsanie
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: tsanie/Billing#1
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?