QueryBuilder Class

Manages a collection of query fields and converts them into SQL statements.

Inheritance Hierarchy

SystemObject
Altaxo.DataConnectionQueryBuilder

Namespace: Altaxo.DataConnection
Assembly: AltaxoBase (in AltaxoBase.dll) Version: 4.8.3179.0 (4.8.3179.0)

Syntax

public class QueryBuilder

The QueryBuilder type exposes the following members.

Constructors

	Name	Description
	QueryBuilder	Initializes a new instance of a QueryBuilder.

Properties

	Name	Description
	ConnectionString	Gets or sets the connection string used by this QueryBuilder.
	Distinct	Gets or sets whether the query should return DISTINCT values.
	GroupBy	Gets or sets a value that specifies whether the query groups the data.
	GroupByExtension	Gets or sets a value that specifies how the query groups the data.
	MissingJoins	Gets a value that indicates not all tables in the query are related.
	QueryFields	Gets the collection of QueryField objects that defines the query.
	Schema	Gets or sets the schema that represents the underlying database.
	Sql	Gets or sets the SQL string that represents the current QueryFields collection.
	Top	Gets or sets the number of records the query returns using a TOP clause.

Methods

	Name	Description
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object)
	GetHashCode	Serves as the default hash function. (Inherited from Object)
	GetType	Gets the Type of the current instance. (Inherited from Object)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object)
	ToString	Returns a string that represents the current object. (Inherited from Object)