Table of Contents

Namespace YndigoBlue.Velocity.Model

Classes

Aggregate

Represents an aggregate function operation (COUNT, SUM, AVG, MIN, MAX, STDDEV, VAR) that can be used in expressions.

ArithmeticOperator

Represents an arithmetic operator (+, -, *, /, %) used in expressions and calculations.

BlobColumnConfig

Configuration for how a blob column is handled during CSV import or export.

BooleanItem

Represents a boolean operator (AND/OR) used to connect criteria in WHERE and HAVING clauses.

Cast

Represents a CAST operation that converts a value or expression to a different data type.

CheckOperator

Represents a comparison operator used in CHECK constraints to validate column values.

Column

Represents a column in a database table.

CommandInfo

Provides timing and diagnostic information for database command execution.

Criterion<T>

Represents a single comparison criterion in a WHERE or HAVING clause.

Database

Represents a database containing multiple schemas.

Datum

Abstract base class for working with database row data, providing strongly-typed field access and automatic type conversions.

Delete

Represents a DELETE statement for removing rows from a database table.

ExportConfig

Configuration for exporting query results to CSV files.

Expression

Represents a calculated expression in a SELECT clause using arithmetic operators, functions, and literals.

Filter

Represents a filter container for WHERE and HAVING clauses in SQL queries.

FullTextIndex

Represents a full-text index that enables advanced text search capabilities on table columns.

Function

Abstract base class for all database function calls in SELECT clauses, expressions, filters, and constraints.

Geography

Represents geographic spatial data with coordinate reference system (SRID) support for earth-based locations.

ImportConfig

Configuration for importing CSV data into database tables.

ImportConfig.ImportConfigMappings

Defines the mapping between CSV column headers and database column names, along with the data type for each mapped column.

Index

Represents a database index that improves query performance on table columns.

Join

Represents a SQL JOIN operation that combines rows from two or more tables based on column equality or function-based predicates such as geospatial relationships.

Literal<T>

Represents a literal constant value used in queries, expressions, and constraints.

OrderClause

Represents an ORDER BY clause that specifies how query results should be sorted.

Query

Represents a SQL SELECT query with support for filtering, joining, grouping, ordering, and unions.

Record

Represents a database record for INSERT and UPDATE operations. A Record contains field values that will be persisted to a specific table, with support for literal values, subqueries, and database functions.

Record<T>

Represents a typed database record that supports automatic data binding between C# objects and database columns.

Result

Represents a single row returned from a SELECT query.

Schema

Represents a database schema containing tables and views.

Snippet<T>

Represents a raw value embedded directly in SQL without parameterization, used primarily in views and CHECK constraints.

SpatialIndex

Represents a spatial index that accelerates queries on geometric and geographic data columns.

Statement

Represents a raw SQL statement that can be used as an element in expressions or queries.

Table

Represents a database table with columns, constraints, and indexes.

Union

Represents a UNION operation that combines the result sets of two or more queries.

Update

Represents an UPDATE statement for modifying existing rows in a database table.

View

Represents a database view - a virtual table defined by a query.

Structs

DatabaseInfo

Contains metadata about the database server that Velocity is connected to.