InsertStatement Class

Represents the INSERT 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.DataModificationStatement
          Microsoft.Data.Schema.ScriptDom.Sql.InsertStatement

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

Syntax

'Declaration
<SerializableAttribute> _
Public Class InsertStatement _
    Inherits DataModificationStatement
[SerializableAttribute]
public class InsertStatement : DataModificationStatement
[SerializableAttribute]
public ref class InsertStatement : public DataModificationStatement
[<SerializableAttribute>]
type InsertStatement =  
    class
        inherit DataModificationStatement
    end
public class InsertStatement extends DataModificationStatement

The InsertStatement type exposes the following members.

Constructors

  Name Description
Public method InsertStatement Initializes a new instance of the InsertStatement class.

Top

Properties

  Name Description
Public property Columns Gets a list of optional target columns.
Public property FirstTokenIndex Gets or sets the first token index. (Inherited from TSqlFragment.)
Public property FragmentLength Gets the fragment length. (Inherited from TSqlFragment.)
Public property InsertOption Gets or sets the insert option.
Public property InsertSource Gets or sets the insert source, which can be ValuesInsertSource, SelectStatement, or ExecuteStatement.
Public property LastTokenIndex Gets or sets the last token index. (Inherited from TSqlFragment.)
Public property OptimizerHints Gets a list of optimizer hints. (Inherited from DataModificationStatement.)
Public property OutputClause Gets or sets the output clause. (Inherited from DataModificationStatement.)
Public property ScriptTokenStream Gets or sets a list of token streams. (Inherited from TSqlFragment.)
Public property StartColumn Gets the starting column. (Inherited from TSqlFragment.)
Public property StartLine Gets the starting line. (Inherited from TSqlFragment.)
Public property StartOffset Gets the fragment start offset value. (Inherited from TSqlFragment.)
Public property Target Gets or sets the data modification target. (Inherited from DataModificationStatement.)
Public property TopRowFilter Gets or sets the top row filter. (Inherited from DataModificationStatement.)
Public property WithCommonTableExpressionsAndXmlNamespaces Gets or sets the WITH common_table_expression and the XMLNAMESPACES clause. (Inherited from StatementWithCommonTableExpressionsAndXmlNamespaces.)

Top

Methods

  Name Description
Public method Accept Entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public method AcceptChildren Calls Accept on the children with the given visitor. (Overrides DataModificationStatement.AcceptChildren(TSqlFragmentVisitor).)
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)

Top

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.

See Also

Reference

Microsoft.Data.Schema.ScriptDom.Sql Namespace