Class AstOleDbCommandParameterNode
The OLE DB Command Parameter transformation maps an input column to an external column for use as an OLE DB command parameter.
public class AstOleDbCommandParameterNode : AstDataflowColumnMappingNode, IBindableItem, IGetJsonProvider, IFrameworkItem, IValidationInfo, INamedItem
- Inheritance
Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, System.ComponentModel.IDataErrorInfo,
Constructors
| AstOleDbCommandParameterNode(IFrameworkItem) | Initializes a new instance of the AstOleDbCommandParameterNode class with the specified parent node. |
Fields
| IsScopeImported |
Properties
| CodePage | This value specifies the integer index for the code page of this column mapping type. This property applies only to column mapping types that support code pages, such as strings. Code pages supported by Windows are listed at: http://msdn.microsoft.com/en-us/goglobal/bb964654.aspx. |
| CodePageDefaultValue | Gets the default value for the CodePage property |
| DataType | This value specifies the type of the column mapping using the unified type system. |
| Direction | This value specifies the role the parameter plays in the query - input, output, or return value. |
| DirectionDefaultValue | Gets the default value for the Direction property |
| FriendlyTypeNameStatic | Gets the friendly name of the type of this node |
| Length | This value specifies the length of the column mapping type. This property applies only to column mapping types that support a length specification, such as string and binary types. |
| LengthDefaultValue | Gets the default value for the Length property |
| Precision | This value specifies the precision or the number of digits in a column mapping type. This property only applies to column mapping types that support precision, such as decimal. |
| PrecisionDefaultValue | Gets the default value for the Precision property |
| Scale | This value specifies the precision, or the number of digits, in a column mapping type. This property applies only to column mapping types that support precision, such as decimal. |
| ScaleDefaultValue | Gets the default value for the Scale property |
| SsisDataTypeOverride | Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the DataType property. |
| Name | Gets or sets the Name of the column mapping, which corresponds directly to the SourceColumn property |
| SourceColumn | This value specifies the name of the source column in the data flow path mapping. |
| TargetColumn | This value specifies the name of the destination column in the data flow path mapping. |
| IsUsed | This value specifies whether the dataflow column is used. |
| SortKeyPosition | This value specifies where the parent column is situated in the sort order. For example if the rows were first sorted by 2 other columns, then the value would be 3. If this column was not used for sorting, it's value should be 0. |
| SourceColumnDefaultValue | Gets the default value for the SourceColumn property |
| TargetColumnDefaultValue | Gets the default value for the TargetColumn property |
| IsUsedDefaultValue | Gets the default value for the IsUsed property |
| SortKeyPositionDefaultValue | Gets the default value for the SortKeyPosition property |
| Guid | |
| Annotations | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| ObjectTag | This property provides a general purpose storage mechanism for .NET objects to be associated with AstNode objects. It supplements the annotation system, which is intended for use with string-based metadata. |
| BimlFile | This value specifies the BimlFile in which the Biml code that defines AstNode resides. |
| ItemLabel | Gets a label that can be used to identify this node |
| ParentItem | This value specifies the parent of the current node. All nodes must have a valid parent in the Biml framework, except for the root node. |
Methods
| BindingScopeBoundaries() | Retrieves the permitted scope boundaries to bind references from this node. |
| Duplicate() | Creates a duplicate of the current node |
| Duplicate(IFrameworkItem) | Creates a duplicate of the current node with the specified parent item |
| GetDefaultValue(String) | Retrieves the default value for the property with the name propertyName |
| GetDefaultValue<T>(String) | Retrieves the default value for the property with the name propertyName |
| GetSchemaLocalName() | Retrieves the local XML element name that corresponds to this node in Biml code. |
| StructureEquals(Object) | Compares this node to the provided object to determine if all defined children and references are equal. |
| FirstChildOfType<TChild>() | Gets the first defined descendant node of the specified type |
| RemoveFromParent() | Removes this node definition from its parent |
| DefinedAstNodes() | Retrieves a collection of nodes that have been defined as direct children of the current node. |
| GetJson() | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetExternalJson() | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetJson(Boolean, Boolean, Boolean, Boolean, Boolean) | Generates a JavaScript Object Notation (JSON) representation of the current node |
| GetXObjectName() | Gets the fully qualified XML element name for this node in the code document. |
| FirstParent<TAstNode>() | Retrieves the first parent or ancestor node of the specified type |
| FirstParent<TAstNode>(Type) | Retrieves the first parent or ancestor node of the specified type with the specified custom attribute type |
| FirstThisOrParent<TAstNode>() | Retrieves the first parent or ancestor node of the specified type, including this node |
| IsDirectAncestor(IFrameworkItem) | Retrieves a value indicating whether the specified node is a direct ancestor of this node. |
| AncestorDistance(IFrameworkItem) | Retrieves the number of steps between this node and the nearest shared ancestor with the specified relative node. |
| FirstThisOrParent<TAstNode>(Type) | Retrieves the first parent or ancestor node (including this node) of the specified type with the specified custom attribute type |
| AllDefinedSuccessors() | Retrieves the collection of all nodes defined as a child of this or any successor node or the current node |
| AllDefinedSuccessors(Boolean) | Retrieves the collection of all nodes defined as a child of this or any successor node or optionally the current node |
| OnNotificationTargetPropertyChanged(String) | |
| OnScopeBoundaryChanged(IScopeBoundary, IScopeBoundary) | |
| AddParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveParseableChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| AddScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>) | |
| RemoveScopeBoundaryChangedEventListener(IFrameworkItem, EventHandler<VulcanPropertyChangedEventArgs>) | |
| AddParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveParsePendingChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| AddFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| RemoveFromTemplateChangedEventListener(IFlowFileChanged, EventHandler<EventArgs>) | |
| GetAllItemsReferencedByDefinedSuccessors() | Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem. |
| ParseSelf(XElement, ParserContext) | |
| ParseChild(XElement, ParserContext) | |
| ParseNameValueMapping(XElement) | |
| BindReference(SymbolTable, String, Boolean, String, Int32, Boolean) | |
| GetBimlChildFragment(CulturedStringBuilder, Int32) | |
| HasAnyBimlChildNodes() |