The following tables list the members exposed by Select.
Name | Description | |
---|---|---|
Select Constructor | Overloaded. |
Name | Description | |
---|---|---|
CanReadUncommitedData | Determines whether the query results will include the data for which the transaction is not completed. | |
Columns | Collection of expressions of query columns. | |
IsDistinct | Determines whether the query returns only unique records. | |
OffsetFetchPaging | Determines if offset-fetch paging is used. | |
QueryKind | Query kind, that is used to request special executor. | |
QueryOptimize | Additional information about the query, that can by use to optimization DBEngine. | |
RowsOffset | Number of rows to skip. | |
SourceExpression | The expression of the query data source. |
Name | Description | |
---|---|---|
As | Adds the specified alias for the last specified query expression. | |
BuildSqlText | Overridden. Generates the query text, using the specified System.Text.StringBuilder instance. | |
Clone | Overridden. Creates the clone of the current Select instance. | |
Column | Overloaded. | |
CrossJoin | Overloaded. | |
Distinct | To the current select query, adds the key word Distinct. | |
ExecuteReader | Overloaded. | |
ExecuteScalar | Overloaded. | |
From | Overloaded. | |
GetSqlText | Overridden. Returns the SQL text of the current query. | |
GetUsingParameters | Overridden. Returns the collection of parameters used by the query. | |
OffsetFetch | Adds offset-fetch clause to select. | |
Top | Specifies the number of first records returned by the resulting dataset. | |
ToPageable | Transforms the current query into a query that has an option of the paged output with the specified parameters. |