RawQuery | SurrealDB Docs

The .NET SDK for SurrealDB enables simple and advanced querying of a remote or embedded database.

Runs a set of SurrealQL statements against the database, based on a raw SurrealQL query.

Method Syntax

await db.RawQuery(sql, params)

Arguments

Arguments	Description
`sql`	Specifies the SurrealQL statements.
`params`	Assigns variables which can be used in the query.
`cancellationToken`	The cancellationToken enables graceful cancellation of asynchronous operations.

Example usage

// Assign the variable on the connection
var @params = new Dictionary<string, object> { { "table", "person" } };
var result = await db.RawQuery("CREATE person; SELECT * FROM type::table($table);", @params);

// Get the first result from the first query
var created = result.GetValue<Person>(0);

// Get all of the results from the second query
var people = result.GetValue<List<Person>>(1);