.Set()
Assigns a value as a parameter for this connection.
Method Syntaxawait db.Set(key, value)
Arguments | Description | ||
---|---|---|---|
key required | Specifies the name of the variable. | ||
value required | Assigns the value to the variable name. | ||
cancellationToken optional | The cancellationToken enables graceful cancellation of asynchronous operations. |
// Assign the variable on the connection await db.Set("name", new Name { FirstName = "Tobie", LastName = "Morgan Hitchcock" }); // Use the variable in a subsequent query await db.Query($"CREATE person SET name = $name"); // Use the variable in a subsequent query await db.Query($"SELECT * FROM person WHERE name.first_name = $name.first_name");
You can remove the variable from the connection using the Unset()
method.