ForEachFromVarEnumerator-Klasse

This enumerator is used to loop over the objects that are in the variable specified in VariableName.

Vererbungshierarchie

System. . :: . .Object
  Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
    Microsoft.SqlServer.Dts.Runtime. . :: . .ForEachEnumerator
      Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar..::..ForEachFromVarEnumerator

Namespace:  Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar
Assembly:  Microsoft.SqlServer.ForEachFromVarEnumerator (in Microsoft.SqlServer.ForEachFromVarEnumerator.dll)

Syntax

'Declaration
Public NotInheritable Class ForEachFromVarEnumerator _
    Inherits ForEachEnumerator _
    Implements IDTSComponentPersist, IDTSForEachFromVarEnumerator
'Usage
Dim instance As ForEachFromVarEnumerator

public sealed class ForEachFromVarEnumerator : ForEachEnumerator, 
    IDTSComponentPersist, IDTSForEachFromVarEnumerator

public ref class ForEachFromVarEnumerator sealed : public ForEachEnumerator, 
    IDTSComponentPersist, IDTSForEachFromVarEnumerator

[<SealedAttribute>]
type ForEachFromVarEnumerator =  
    class
        inherit ForEachEnumerator
        interface IDTSComponentPersist
        interface IDTSForEachFromVarEnumerator
    end

public final class ForEachFromVarEnumerator extends ForEachEnumerator implements IDTSComponentPersist, IDTSForEachFromVarEnumerator

Der ForEachFromVarEnumerator-Typ macht folgende Elemente verfügbar.

Konstruktoren

	Name	Beschreibung
	ForEachFromVarEnumerator	Initializes a new instance of the ForEachFromVarEnumerator class.

Zum Anfang

Eigenschaften

	Name	Beschreibung
	CollectionEnumerator	Gets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (Geerbt von ForEachEnumerator.)
	VariableName	Gets or sets the name of the variable to enumerate.
	Version	Returns the version number of the package. This property is read-only. (Geerbt von ForEachEnumerator.)

Zum Anfang

Methoden

	Name	Beschreibung
	CanUpdate	A Boolean that indicates if the new package XML can update the old package XML. (Geerbt von ForEachEnumerator.)
	Equals	Determines whether two object instances are equal. (Geerbt von DtsObject.)
	Finalize	(Geerbt von Object.)
	GetEnumerator	Returns an enumerator that can iterate over the ForEachFromVarEnumerator instance. (Überschreibt ForEachEnumerator. . :: . .GetEnumerator(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging).)
	GetHashCode	Returns the hash code for this instance. (Geerbt von DtsObject.)
	GetType	(Geerbt von Object.)
	InitializeForEachEnumerator	Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Geerbt von ForEachEnumerator.)
	LoadFromXML	This method is not callable by your application code. To load a package saved as .xml, use the Application..::..LoadPackage method.
	MemberwiseClone	(Geerbt von Object.)
	SaveToXML	This method is not callable by your application code. To save a package as .xml, use the Application..::..SaveToXml method.
	ToString	(Geerbt von Object.)
	Update	This method updates the old package XML with the new package XML if CanUpdate is set to true. (Geerbt von ForEachEnumerator.)
	Validate	Allows the container to determine if it contains invalid settings that will prevent it from executing successfully. (Geerbt von ForEachEnumerator.)

Zum Anfang

Hinweise

An example of the use of this enumerator is when a query is run, and the result of the query is stored in the variable. You can use this enumerator to loop over the query results.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.

Siehe auch

Verweis

Microsoft.SqlServer.Dts.Runtime.Enumerators.FromVar-Namespace