Platform Core .NET Assemblies API
Select Class Members
See Also  Properties  Methods  Send Feedback
Terrasoft.Core.DB Namespace : Select Class

Glossary Item Box

The following tables list the members exposed by Select.

Public Constructors

 NameDescription
Public ConstructorSelect ConstructorOverloaded.   
Top

Public Properties

 NameDescription
Public PropertyCanReadUncommitedDataDetermines whether the query results will include the data for which the transaction is not completed.  
Public PropertyColumnsCollection of expressions of query columns.  
Public PropertyIsDistinctDetermines whether the query returns only unique records.  
Public PropertyOffsetFetchPagingDetermines if offset-fetch paging is used.  
Public PropertyQueryKindQuery kind, that is used to request special executor.  
Public PropertyQueryOptimizeAdditional information about the query, that can by use to optimization DBEngine.  
Public PropertyRowsOffsetNumber of rows to skip.  
Public PropertySourceExpressionThe expression of the query data source.  
Top

Public Methods

 NameDescription
Public MethodAsAdds the specified alias for the last specified query expression.  
Public MethodBuildSqlTextOverridden. Generates the query text, using the specified System.Text.StringBuilder instance.  
Public MethodCloneOverridden. Creates the clone of the current Select instance.  
Public MethodColumnOverloaded.   
Public MethodCrossJoinOverloaded.   
Public MethodDistinctTo the current select query, adds the key word Distinct.  
Public MethodExecuteReaderOverloaded.   
Public MethodExecuteScalarOverloaded.   
Public MethodFromOverloaded.   
Public MethodGetSqlTextOverridden. Returns the SQL text of the current query.  
Public MethodGetUsingParametersOverridden. Returns the collection of parameters used by the query.  
Public MethodOffsetFetchAdds offset-fetch clause to select.  
Public MethodTopSpecifies the number of first records returned by the resulting dataset.  
Public MethodToPageableTransforms the current query into a query that has an option of the paged output with the specified parameters.  
Top

See Also

© Terrasoft 2002-2018.