using SurrealDb.Driver;

Database.Configure(config =>
{
    config.Address      = "http://127.0.0.1:8082";
    config.DatabaseName = "test";
    config.Namespace    = "test";
    config.AuthUsername = "root";
    config.AuthPassword = "root";
});
Database.Initialize();
await Database.Connect();

[Model("users")]
public class User : SurrealModel<User>
{
    public string Name { get; set; }
    public string Email { get; set; }
    public int Age { get; set; }
}

using SurrealDb.Driver;

var result = await Database.Query<User>("SELECT * FROM users;");

// When expecting one user:
var user = result!.First();
// When expecting multiple users:
var users = result!.Get();

using SurrealDb.Driver;

// Returns multiple users where name = john
User.Query().Where("name", "John").Get(); // = List<User>
// Returns first user where name = john
User.Query().Where("name", "John").First(); // = User

var john = await User.Create(new(){ Name = "John" });