Transactions​

Transactions allow you to execute transactional code via the TransactionAsync API, retrying your queries if a retryable error (e.g. a network failure) occurs. If an non-retryable error happens, the queries performed within the transactions are automatically rolled back:

var client = new EdgeDBClient();

await client.TransactionAsync(async tx =>
    await tx.ExecuteAsync("INSERT User { name := 'John Smith' }");
);

let client = new EdgeDBClient()

client.TransactionAsync(
  fun tx -> tx.ExecuteAsync("INSERT User { name := 'John Smith' }")
) |> Async.AwaitTask |> Async.Ignore |> ignore

The TransactionAsync method proxies the result of the transaction, allowing you to get the result of a query executed in a transaction:

var client = new EdgeDBClient();

var transactionResult = await client.TransactionAsync(async tx =>
    await tx.QueryRequiredSingleAsync<string>("SELECT 'Hello from Transaction!'");
);

Console.WriteLine(transactionResult);

let client = new EdgeDBClient()

client.TransactionAsync(
  fun tx -> tx.QueryRequiredSingleAsync<string>("SELECT 'Hello from Transaction!'")
)
|> Async.AwaitTask
|> Async.RunSynchronously
|> fun r -> printfn "Transaction result: %s" r