ForEachADOEnumerator Class

Enumerates over rows in a dataset, data table, or recordset. This class cannot be inherited.


Namespace:  Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO
Assembly:  Microsoft.SqlServer.ForEachADOEnumerator (in Microsoft.SqlServer.ForEachADOEnumerator.dll)

public sealed class ForEachADOEnumerator : ForEachEnumerator, 
	IDTSForEachADOEnumerator, IDTSComponentPersist

The ForEachADOEnumerator type exposes the following members.

Public methodForEachADOEnumeratorInitializes a new instance of the ForEachADOEnumerator class.

Public propertyCollectionEnumeratorGets or sets Boolean that indicates if the foreach loop enumerator is enumerating collections of objects or enumerating collections of collections. (Inherited from ForEachEnumerator.)
Public propertyDataObjectVariableGets or sets a String that contains the name of the package variable that contains the persisted data object from the enumerator.
Public propertyTypeGets or sets a value that indicates what type of object to enumerate over.
Public propertyVersionReturns the version number of the package. This property is read-only. (Inherited from ForEachEnumerator.)

Public methodCanUpdateA Boolean that indicates if the new package XML can update the old package XML. (Inherited from ForEachEnumerator.)
Public methodEqualsDetermines whether two object instances are equal. (Inherited from DtsObject.)
Protected methodFinalize (Inherited from Object.)
Public methodGetEnumeratorReturns an IEnumerator interface that can iterate over the ActiveX Data Objects (ADO) object. (Overrides ForEachEnumerator.GetEnumerator(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging).)
Public methodGetHashCodeReturns the hash code for this instance. (Inherited from DtsObject.)
Public methodGetType (Inherited from Object.)
Public methodInitializeForEachEnumeratorInitializes the properties associated with the task. This method is called by the runtime and is not used in code. (Inherited from ForEachEnumerator.)
Public methodLoadFromXMLThis method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodSaveToXMLThis method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. This method cannot be inherited.
Public methodToString (Inherited from Object.)
Public methodUpdateThis method updates the old package XML with the new package XML if CanUpdate is set to true. (Inherited from ForEachEnumerator.)
Public methodValidateAllows the container to determine if it contains invalid settings that will prevent it from executing successfully. (Inherited from ForEachEnumerator.)

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions