SurrealDB Docs Logo

Enter a search query

.Upsert<T>()

Creates or updates a specific record.

Method Syntax
await db.Upsert<T>(data)
Note

This function creates a new document / record or replaces the current one with the specified data.

Arguments

ArgumentsDescription
data required

The document / record data to insert.

cancellationToken optional

The cancellationToken enables graceful cancellation of asynchronous operations.

Example usage

var person = new Person { Id = ("person", "tobie"), // Id is mandatory to apply create or update Name = "Tobie", Settings = new Settings { Active = true, Marketing = true, }, }; // Create a new record when it doesn't exist var created = await db.Upsert(person); // Update an existing record when it does exist var updated = await db.Upsert(person);

On this page

© SurrealDB GitHub Discord Community Cloud Features Releases Install