Skip to main content

TableQuery Members

Obsolete. Obsolete. Use the SelectQuery class instead.

Constructors

Name Description
TableQuery() Initializes a new instance of the TableQuery class with the default settings.
TableQuery(String) Initializes a new instance of the TableQuery class with the specified settings.

Properties

Name Description
FilterString Gets or sets the criteria used to filter data returned by the current TableQuery.
GroupFilterString Gets or sets the filter criteria to add to the SELECT statement of the TableQuery containing grouped/aggregated columns.
Grouping Provides access to grouping settings used to group the result set of the current TableQuery by the specified column(s) into a set of summary rows.
IsolationLevel Specifies the isolation level for SqlQuery. Inherited from SqlQuery.
Name Specifies the query name. Inherited from SqlQuery.
Parameters Provides access to the collection of parameters defined for the SqlQuery. Inherited from SqlQuery.
Relations Provides access to the collection of data relations defined for the TableQuery.
Skip Gets or sets the number of rows to skip in a returned query result set.
Sorting Provides access to sort settings used to order the result set of the current TableQuery by the specified column(s).
Tables Provides access to the collection of data tables defined for the TableQuery.
Top Gets or sets the number of rows returned in the query result set.

Methods

Name Description
AddRelation(String, String, String, String) Creates a master-detail relation between two data tables across the specified key columns.
AddTable(String) Includes a data table with the specified name into the query.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
FindTable(String) Returns the data table with the specified name.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetSql(DBSchema) Returns the SQL query corresponding to the current TableQuery.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns the textual representation of SqlQuery. Inherited from SqlQuery.
Validate() Checks the validity of the TableQuery.
Validate(DBSchema) Checks the validity of the TableQuery.
See Also