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