MergeStatement Class

Represents the MERGE 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.MergeStatement

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

Syntax

'Declaration
<SerializableAttribute> _
Public Class MergeStatement _
    Inherits DataModificationStatement

[SerializableAttribute]
public class MergeStatement : DataModificationStatement

[SerializableAttribute]
public ref class MergeStatement : public DataModificationStatement

[<SerializableAttribute>]
type MergeStatement =  
    class
        inherit DataModificationStatement
    end

public class MergeStatement extends DataModificationStatement

The MergeStatement type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	ActionClauses	Gets a list of conditions and actions to take.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	OptimizerHints	Gets a list of optimizer hints. (Inherited from DataModificationStatement.)
	OutputClause	Gets or sets the output clause. (Inherited from DataModificationStatement.)
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SearchCondition	Gets or sets the search condition.
	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.)
	TableAlias	Gets or sets the target table alias.
	TableSource	Gets or sets the table source.
	Target	Gets or sets the data modification target. (Inherited from DataModificationStatement.)
	TopRowFilter	Gets or sets the top row filter. (Inherited from DataModificationStatement.)
	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 DataModificationStatement.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

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