@tsdrivers/mssql

Appearance

@tsdrivers/mssql / Transaction

Class: Transaction ​

Defined in: projects/ts-mssql/core/transaction.ts:20

A database transaction. Use with await using for auto-rollback.

Example ​

ts
await using tx = await cn.beginTransaction();
await cn.execute("INSERT ...", params, { transaction: tx });
await tx.commit();
// auto-rollback if commit() not called

Implements ​

  • Disposable
  • AsyncDisposable

Properties ​

id ​

readonly id: string

Defined in: projects/ts-mssql/core/transaction.ts:21

isolation ​

readonly isolation: IsolationLevel

Defined in: projects/ts-mssql/core/transaction.ts:22

Accessors ​

isActive ​

Get Signature ​

get isActive(): boolean

Defined in: projects/ts-mssql/core/transaction.ts:42

Returns ​

boolean

Methods ​

[asyncDispose]() ​

[asyncDispose](): Promise<void>

Defined in: projects/ts-mssql/core/transaction.ts:103

Returns ​

Promise<void>

Implementation of ​

AsyncDisposable.[asyncDispose]

[dispose]() ​

[dispose](): void

Defined in: projects/ts-mssql/core/transaction.ts:99

Returns ​

void

Implementation of ​

Disposable.[dispose]

commit() ​

commit(): Promise<void>

Defined in: projects/ts-mssql/core/transaction.ts:87

Returns ​

Promise<void>

rollback() ​

rollback(): Promise<void>

Defined in: projects/ts-mssql/core/transaction.ts:93

Returns ​

Promise<void>