SurrealDB Docs Logo

Enter a search query

SDK methods

The .NET SDK for SurrealDB has a single SurrealDB class that provides methods for querying a remote SurrealDB database. The class is designed to be simple to use and easy to understand for developers who are new to .NET or SurrealDB. This page lists out the methods that are available in the SurrealDB class.

Initialization methods

MethodDescription
db.Connect()Connects the client to the underlying endpoint, also improving performance to avoid cold starts
db.Use(namespace, database)Switch to a specific namespace and database
db.Set(key, value)Assigns a value as a parameter for this connection
db.Unset(key)Removes a parameter for this connection

Query methods

MethodDescription
db.Query<T>(sql)Runs a set of SurrealQL statements against the database
db.RawQuery<T>(sql, vars)Runs a set of SurrealQL statements against the database, based on a raw SurrealQL query
db.Select<T>(thing)Selects all records in a table, or a specific record
db.LiveQuery<T>(sql)Initiate a live query from a SurrealQL statement
db.LiveRawQuery<T>(sql)Initiate a live query from a SurrealQL statement, based on a raw SurrealQL query
db.LiveTable<T>(table, diff)Initiate a live query from a table
db.ListenLive<T>(queryUuid)Listen responses from an existing live query
db.Kill(queryUuid)Kill a running live query

Mutation methods

MethodDescription
db.Create<T>(thing, data)Creates a record in the database
db.Insert<T>(thing, data)Inserts one or multiple records in the database
db.Update<T>(thing, data)Updates all records in a table, or a specific record
db.Upsert<T>(thing, data)Creates or updates a specific record
db.Merge<T>(thing, data)Modifies all records in a table, or a specific record
db.Patch<T>(thing, data)Applies JSON Patch changes to all records in a table, or a specific record
db.Delete(thing)Deletes all records, or a specific record

Authentication methods

MethodDescription
db.SignUp(credentials)Signs this connection up to a specific authentication scope
db.SignIn(credentials)Signs this connection in to a specific authentication scope
db.Invalidate()Invalidates the authentication for the current connection
db.Authenticate(token)Authenticates the current connection with a JWT token
db.Info<T>()Returns the record of an authenticated scope user

On this page

© SurrealDB GitHub Discord Community Cloud Features Releases Install