MergeStatement Class

Represents the MERGE statement.

Inheritance Hierarchy


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


<SerializableAttribute> _
Public Class MergeStatement _
    Inherits DataModificationStatement
public class MergeStatement : DataModificationStatement
public ref class MergeStatement : public DataModificationStatement
type MergeStatement =  
        inherit DataModificationStatement
public class MergeStatement extends DataModificationStatement

The MergeStatement type exposes the following members.


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



  Name Description
Public property ActionClauses Gets a list of conditions and actions to take.
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 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 SearchCondition Gets or sets the search condition.
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 TableAlias Gets or sets the target table alias.
Public property TableSource Gets or sets the table source.
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.)



  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.)


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


Microsoft.Data.Schema.ScriptDom.Sql Namespace