Method Retrieve

Namespace

YndigoBlue.Velocity.Engine

Assembly

YndigoBlue.Velocity.dll

Retrieve(Query)

Executes a query and returns all results in a disconnected result set loaded into memory.

public ResultSet Retrieve(Query query)

Parameters

query Query

The Query to execute.

Returns

ResultSet

A ResultSet containing all query results, disconnected from the database.

Examples

using (var m = new Manager(conn))
{
    var schema = m.LoadSchema("app");
    var usersTable = schema["users"];

    var query = new Query()
        .Select([usersTable["id"], usersTable["name"], usersTable["email"]])
        .From(usersTable)
        .Where(new Criterion<string>(usersTable["role"], ConditionalType.Equals, "admin"));

    // Get all results at once
    var results = m.Retrieve(query);

    Console.WriteLine($"Found {results.Count} admins");
    foreach (var row in results)
    {
        Console.WriteLine($"ID: {row["id"]}, Name: {row["name"]}");
    }
}

Remarks

Use Retrieve when you need random access to results or when the result set is small enough to fit in memory. For large result sets, consider using Search instead to avoid memory issues.

Exceptions

DbException

Thrown when a database error occurs.