• Artigo

Classe ForEachFromVarEnumerator

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

Hierarquia de herança

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 (em Microsoft.SqlServer.ForEachFromVarEnumerator.dll)

Sintaxe

'Declaração
Public NotInheritable Class ForEachFromVarEnumerator _
    Inherits ForEachEnumerator _
    Implements IDTSComponentPersist, IDTSForEachFromVarEnumerator
'Uso
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

O tipo ForEachFromVarEnumerator expõe os membros a seguir.

Construtores

  Nome Descrição
Método público ForEachFromVarEnumerator Initializes a new instance of the ForEachFromVarEnumerator class.

Início

Propriedades

  Nome Descrição
Propriedade pública CollectionEnumerator Gets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (Herdado de ForEachEnumerator.)
Propriedade pública VariableName Gets or sets the name of the variable to enumerate.
Propriedade pública Version Returns the version number of the package. This property is read-only. (Herdado de ForEachEnumerator.)

Início

Métodos

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

Início

Comentários

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.

Segurança de thread

Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.