Namespace FluentCommand.Query
Classes
- ChangeTableBuilder
Provides a builder for constructing SQL Server
CHANGETABLE (CHANGES ...)queries for change tracking.
- ChangeTableBuilderExtensions
Provides extension methods for integrating SQL Server
CHANGETABLE (CHANGES ...)queries into select query builders.
- DeleteBuilder
Provides a builder for constructing SQL DELETE statements with fluent, chainable methods.
- DeleteBuilder<TBuilder>
Provides a generic base class for building SQL DELETE statements with fluent, chainable methods.
- DeleteEntityBuilder<TEntity>
Provides a builder for constructing SQL DELETE statements for a specific entity type with fluent, chainable methods.
- InsertBuilder
Provides a builder for constructing SQL INSERT statements with fluent, chainable methods.
- InsertBuilder<TBuilder>
Provides a generic base class for building SQL INSERT statements with fluent, chainable methods.
- InsertEntityBuilder<TEntity>
Provides a builder for constructing SQL INSERT statements for a specific entity type with fluent, chainable methods.
- JoinBuilder
Provides a builder for constructing SQL JOIN clauses with fluent, chainable methods.
- JoinBuilder<TBuilder>
Provides a generic base class for building SQL JOIN clauses with fluent, chainable methods.
- JoinEntityBuilder<TLeft, TRight>
Provides a builder for constructing SQL JOIN clauses between two entity types with fluent, chainable methods.
- LogicalBuilder
Provides a builder for constructing logical SQL query expressions (such as grouped AND/OR conditions) with fluent, chainable methods.
- LogicalBuilder<TBuilder>
Provides a generic base class for building logical SQL query expressions (such as grouped AND/OR conditions) with fluent, chainable methods.
- LogicalEntityBuilder<TEntity>
Provides a builder for constructing logical SQL query expressions (such as grouped AND/OR conditions) for a specific entity type with fluent, chainable methods.
- OrderBuilder
Provides a builder for constructing SQL ORDER BY clauses with fluent, chainable methods.
- OrderBuilder<TBuilder>
Provides a generic base class for building SQL ORDER BY clauses with fluent, chainable methods.
- OrderEntityBuilder<TEntity>
Provides a builder for constructing SQL ORDER BY clauses for a specific entity type with fluent, chainable methods.
- QueryBuilder
Provides a high-level builder for constructing and composing multiple SQL query statements.
- QueryParameter
Represents a parameter used in a SQL query, including its name, value, and type information.
- QueryStatement
Represents a SQL query statement, including the SQL text and its associated parameters.
- SelectBuilder
Provides a builder for constructing SQL SELECT statements with fluent, chainable methods.
- SelectBuilder<TBuilder>
Provides a generic base class for building SQL SELECT statements with fluent, chainable methods.
- SelectEntityBuilder<TEntity>
Provides a builder for constructing SQL SELECT statements for a specific entity type with fluent, chainable methods.
- StatementBuilder
Provides a builder for constructing raw SQL query statements and parameters.
- StatementBuilder<TBuilder>
Provides a base class for building SQL query statements, supporting tagging, comments, and parameter management.
- TemporalBuilder
Provides a builder for constructing SQL Server temporal table queries using
FOR SYSTEM_TIMEclauses.
- TemporalBuilderExtensions
Provides extension methods for integrating SQL Server temporal table queries (
FOR SYSTEM_TIME) into select query builders.
- UpdateBuilder
Provides a builder for constructing SQL UPDATE statements with fluent, chainable methods.
- UpdateBuilder<TBuilder>
Provides a generic base class for building SQL UPDATE statements with fluent, chainable methods.
- UpdateEntityBuilder<TEntity>
Provides a builder for constructing SQL UPDATE statements for a specific entity type with fluent, chainable methods.
- WhereBuilder
Provides a builder for constructing SQL WHERE clauses with fluent, chainable methods.
- WhereBuilder<TBuilder>
Provides a generic base class for building SQL WHERE clauses with fluent, chainable methods.
- WhereEntityBuilder<TEntity>
Provides a builder for constructing SQL WHERE clauses for a specific entity type.
Interfaces
- IQueryBuilder
Defines a builder interface for constructing SQL queries, including access to the query generator and parameters.
- IQueryStatement
Defines an interface for a SQL query statement, including the SQL text and its parameters.
- IStatementBuilder
Defines a builder for constructing SQL query statements.
- IWhereEntityBuilder<TEntity, TBuilder>
Defines methods for building SQL WHERE clauses for a specific entity type with fluent, chainable methods.
Enums
- AggregateFunctions
Specifies the available aggregate functions for use in SQL queries.
- FilterOperators
Specifies the available filter operators for use in SQL WHERE clauses.
- JoinTypes
Specifies the types of SQL JOIN operations available for combining tables in a query.
- LogicalOperators
Specifies the logical operators used to combine Boolean expressions in SQL WHERE clauses.
- SortDirections
Specifies the sort direction to use in SQL ORDER BY clauses.