SelectStatement Class

Статья
11/05/2012

Represents a SQL SELECT statement.

Inheritance Hierarchy

System.Object
  Microsoft.Data.Schema.ScriptDom.Sql.TSqlFragment
    Microsoft.Data.Schema.ScriptDom.Sql.TSqlStatement
      Microsoft.Data.Schema.ScriptDom.Sql.StatementWithCommonTableExpressionsAndXmlNamespaces
        Microsoft.Data.Schema.ScriptDom.Sql.SelectStatement
          Microsoft.Data.Schema.ScriptDom.Sql.InvalidSelectStatement

Namespace: Microsoft.Data.Schema.ScriptDom.Sql
Assembly: Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Class SelectStatement _
    Inherits StatementWithCommonTableExpressionsAndXmlNamespaces

[SerializableAttribute]
public class SelectStatement : StatementWithCommonTableExpressionsAndXmlNamespaces

[SerializableAttribute]
public ref class SelectStatement : public StatementWithCommonTableExpressionsAndXmlNamespaces

[<SerializableAttribute>]
type SelectStatement =  
    class
        inherit StatementWithCommonTableExpressionsAndXmlNamespaces
    end

public class SelectStatement extends StatementWithCommonTableExpressionsAndXmlNamespaces

The SelectStatement type exposes the following members.

Constructors

	Name	Description
	SelectStatement	Initializes a new instance of the SelectStatement class.

Top

Properties

	Name	Description
	ComputeClauses	Gets a list of the COMPUTE BY clauses.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	ForClause	Gets or sets the FOR clause.
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	OptimizerHints	Gets a list of optional optimizer hints.
	OrderByClause	Gets or sets the optional ORDER BY clause.
	QueryExpression	Gets or sets the main body of the SELECT statement.
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	StartColumn	Gets the starting column. (Inherited from TSqlFragment.)
	StartLine	Gets the starting line. (Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value. (Inherited from TSqlFragment.)
	WithCommonTableExpressionsAndXmlNamespaces	Gets or sets the WITH common_table_expression and the XMLNAMESPACES clause. (Inherited from StatementWithCommonTableExpressionsAndXmlNamespaces.)

Top

Methods

	Name	Description
	Accept	Entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Calls Accept on the children with the given visitor. (Overrides StatementWithCommonTableExpressionsAndXmlNamespaces.AcceptChildren(TSqlFragmentVisitor).)
	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 a hash function for a particular type. (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.)

Top

Remarks

This design is a work in progress. At the present time, it only accepts select statements of the following nature:SELECT select_expression[, ...n] FROM table_source[, ...n]where select_expression only supports the wildcard and basic expressions at the moment, and the only supported table_sources are basic identifiers + AS clause.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Поделиться через