Biml API Reference
AstAdoNetConnectionNode Type
BimlStudio 2017

The ADO.NET connection connects to a data source that can be accessed via a .NET Framework data provider.
Inheritance Hierarchy
Assembly:
Biml (in Biml.dll)
Language Element:
Properties
  Name Summary
AnalysisMetadata
Specifies supplemental information that is used by SQL Server Analysis Services (SSAS) to connect to a given data source.
(Inherited from AstDbConnectionNode)
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.
(Inherited from AstNode)
BimlFile
This value specifies the BimlFile in which the Biml code that defines AstNode resides.
(Inherited from AstNode)
ConnectionString
This value specifies how to open the connection for the specified data source.
(Inherited from AstDbConnectionNode)
ConnectionStringDefaultValue
Gets the default value for the ConnectionString property
(Inherited from AstDbConnectionNode)
ConnectTimeout
Gets the timeout value to use for this connection
(Inherited from AstDbConnectionNode)
CreateInProject
This value specifies whether the Connection should be created as a ConnectionManager within each SSIS package that uses it or as a shared ConnectionManager for each project that uses it.
(Inherited from AstConnectionBaseNode)
CreateInProjectDefaultValue
Gets the default value for the CreateInProject property
(Inherited from AstConnectionBaseNode)
CreatePackageConfiguration
This value specifies whether a PackageConfiguration should be created for this connection.
(Inherited from AstConnectionBaseNode)
CreatePackageConfigurationDefaultValue
Gets the default value for the CreatePackageConfiguration property
(Inherited from AstConnectionBaseNode)
DelayValidation
This value indicates that the connection should not be validated (tested to make sure that it points to a valid resource) until immediately before it is used.
(Inherited from AstConnectionBaseNode)
DelayValidationDefaultValue
Gets the default value for the DelayValidation property
(Inherited from AstConnectionBaseNode)
Error
Gets the error string for this node, if any
(Inherited from AstNode)
ErrorCount
Gets the count of error diagnostics that have been generated for this node
(Inherited from AstNode)
ExpressionProperties
This collection holds properties that can be referenced by expressions. It's not necessarily the same properties that are available directly on the object. These AstPropertyNodes are here to support binding, not to be confused with the Properties collection on the generic control flow base object, which has "real" AstPropertyNodes.
(Inherited from AstConnectionBaseNode)
Expressions
This is a collection of SSIS expression definitions for connection property value overrides.
(Inherited from AstConnectionBaseNode)
FlowFile
This value specifies the containing code file of this node for Xml Binding purposes.
(Inherited from AstNode)
ForceDisableIncrementalChangeTracking
This value specifies whether changes to property values of this node should be automatically reflected in the corresponding Biml code. Its primary use is for temporary nodes that will never be persisted into BimlFiles.
(Inherited from AstNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstNamedNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstConnectionBaseNode)
FriendlyTypeName
Gets the friendly name of the type of this node
(Inherited from AstDbConnectionNode)
FriendlyTypeName
Gets the friendly name of the type of this node
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstNamedNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstConnectionBaseNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
(Inherited from AstDbConnectionNode)
FriendlyTypeNameStatic
Gets the friendly name of the type of this node
ImportedScopeChildren
Gets this ScopeBoundary's referenceable items. This is used to notify the children items when this item's ScopedName changes.
(Inherited from AstConnectionBaseNode)
IsAstNodeReadOnly
Gets a value indicating whether this node is currently in a read-only state
(Inherited from AstNode)
IsInBrokenLiveBimlScript
Specifies whether or not this object is part of a live BimlScript containing an error, which means that this is a cached object that may be out-of-date
(Inherited from AstNode)
IsInBrokenLiveBimlScript
Specifies whether or not this object is part of a live BimlScript containing an error, which means that this is a cached object that may be out-of-date
(Inherited from AstConnectionBaseNode)
ItemLabel
Gets a label that can be used to identify this node
(Inherited from AstNode)
LogicalDisplayFolder
Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio.
(Inherited from AstConnectionBaseNode)
LogicalDisplayFolderDefaultValue
Gets the default value for the LogicalDisplayFolder property
(Inherited from AstConnectionBaseNode)
LookupProviderFactory
This value specifies whether the connection should attempt to resolve the provider name as an ADO.NET provider factory invariant name and use the provider factory to extract the connection type information. Set the value to False to avoid the lookup if it is causing connection strings not to match expectations.
LookupProviderFactoryDefaultValue
Gets the default value for the LookupProviderFactory property
MaxActiveConnections
This value specifies the maximum number of concurrent connections allowed.
(Inherited from AstDbConnectionNode)
MaxActiveConnectionsDefaultValue
Gets the default value for the MaxActiveConnections property
(Inherited from AstDbConnectionNode)
MessageCount
Gets the count of message diagnostics that have been generated for this node
(Inherited from AstNode)
Name
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.
(Inherited from AstNamedNode)
NameDefaultValue
Gets the default value for the Name property
(Inherited from AstNamedNode)
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.
(Inherited from AstNode)
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.
(Inherited from AstNode)
ParentXObjectMappingProvider
This value specifies the parent of the current node for Xml Binding purposes.
(Inherited from AstNode)
PersistSecurityInfo
Gets whether to persist security information for this connection
(Inherited from AstDbConnectionNode)
PropertyChangeNotificationTarget
Gets a reference to the ViewModel object for this node. This property should only be used by the internal Biml framework.
(Inherited from AstNode)
Provider
This value specifies the ADO.NET provider invariant name for the data provider, the assembly qualified name for the data provider’s ADO.NET factory, or the assembly qualified name for the data providers ADO.NET conneciton type. This is equivalent to the Qualifier property in SQL Server Integration Services (SSIS).
ProviderDefaultValue
Gets the default value for the Provider property
ReferenceCount
Gets or sets the total number of other node properties that hold a reference to this node.
(Inherited from AstNamedNode)
References
Gets collection of FrameworkItemReference objects, which track rich information about the properties that hold references to this node.
(Inherited from AstNamedNode)
RefId
Returns the SSIS refid that is used to reference this item from within an SSIS package or dataflow.
(Inherited from AstNamedNode)
RefId
Returns the SSIS refid that is used to reference this item from within an SSIS package.
(Inherited from AstConnectionBaseNode)
RenderedConnectionString
Gets the full connection string for this connection
(Inherited from AstConnectionBaseNode)
RenderedConnectionString
Gets the full connection string for this connection
RenderedProvider
Gets the ADO.NET provider name for this connection
RetainSameConnection
This value indicates whether the same connection can be used for multiple tasks.
(Inherited from AstDbConnectionNode)
RetainSameConnectionDefaultValue
Gets the default value for the RetainSameConnection property
(Inherited from AstDbConnectionNode)
ScopeBoundary
Gets the scope boundary for this node
(Inherited from AstNode)
ScopeBoundary
Gets the ScopeBoundary for this referenceable item
(Inherited from AstNamedNode)
ScopedName
Gets the scoped name which can be used to uniquely identify this object among other objects of its type
(Inherited from AstNamedNode)
ScopedNamePrefix
Gets the prefix to use for ScopedName calculations
(Inherited from AstNamedNode)
ScriptName
Gets the name to use for the emitted connection in a Script Component reference. It is equivalent to the buffer name but with illegal C#/VB characters removed.
(Inherited from AstConnectionBaseNode)
SsisSafeName
Returns a version of the Name that has been cleaned of invalid characters for SSIS.
(Inherited from AstNamedNode)
SsisSafeScopedName
Returns a version of the ScopedName that has been cleaned of invalid characters for SSIS.
(Inherited from AstNamedNode)
SymbolTable
Gets a reference to the symbol table that stores a reference to this and all other named objects in the project
(Inherited from AstNamedNode)
SymbolTableProvider
Gets the symbol table provider for this node
(Inherited from AstNode)
TreeDepth
Gets the distance between this node and the root item
(Inherited from AstNode)
UserDefinedItems
Gets the child items of this node that were defined in user code
(Inherited from AstNode)
WarningCount
Gets the count of warning diagnostics that have been generated for this node
(Inherited from AstNode)
XmlMapping
Gets the XML binding information that is used to track the Biml code that corresponds to this node
(Inherited from AstNode)
Methods
  Name Summary
Events
  Name Summary
ItemLabelChanged
The ItemLabelChanged event occurs when the name of this node or any scope boundary ancestor (as determined by following ParentItem to the AstRootNode) name changes.
NameChanged
The NameChanged event occurs when the Name property of the current node has changed to a new value and that value has been committed.
NameChanging
The NameChanging event occurs when the Name property of the current node is receiving a new value but that value has not yet been committed.
ScopeBoundaryChanged
The ScopeBoundaryChanged event occurs when any ancestor (as determined by following ParentItem to the AstRootNode) changes in such a way as the ScopeBoundary for this node changes. This will force the ScopedName of this node to change if it is an AstNamedNode.
ScopedNameChanged
The ScopedNameChanged event occurs when the name of this node or any scope boundary ancestor (as determined by following ParentItem to the AstRootNode) name changes.
Extension Methods
  Name Summary
AddAnnotation(AnnotationType,String)
Adds an annotation to an AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
AddAnnotation(AnnotationType,String,String)
Adds an annotation to an AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
EnumerateAncestors
Returns the ancestors of the current node
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateSchemaBiml
Create the Biml to represent a schema from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateSchemaNode
Create a node that represents the specified schema
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateSchemaNodes()
Create the nodes to represent all schemas from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateSchemasBiml()
Create the Biml to represent all schemas from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateTableNode(String,String)
Create a node that represents the specified table
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateTableNode(String,String,ImportOptions)
Create a node that represents the specified table
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateTableNodes()
Create the nodes to represent all tables from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
GenerateTableNodes(String)
Create the nodes to represent all tables for a specified schema from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetBiml()
Retrieve the Biml that represents the AstNode
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetDatabaseSchema()
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetDatabaseSchema(ImportOptions)
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetDatabaseSchema(Int32)
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetDataTable(String)
Retrieves a data table from a database
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetDataTable(String,Int32)
Retrieves a data table from a database
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String,Boolean)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
GetTag(String,Boolean,Boolean)
Gets the first annotation with a matching tag and returns the value. If the tag is not found, returns an empty string.
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportDB()
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportDB(RemoteExecutionContext,String,String,ImportOptions)
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportDB(String,String)
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportDB(String,String,ImportOptions)
Import all supported objects from the database connection (tables, views, and schemas)
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportTableNodes(String,String)
Create the nodes to represent all tables from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
ImportTableNodes(String,String,ImportOptions)
Create the nodes to represent all tables from a database connection
[Extension Method: Import namespace Varigence.Biml.Extensions]
.NET API Metadata
Assembly:
Biml
Friendly Name:
AdoNetConnection
Abstract:
False
Referenceable:
True
Root Item:
False
Scope Boundary:
False
Symbol Table Provider:
False
Xml Schema Name:
Varigence.Languages.Biml.Connection.AstAdoNetConnectionNode
Xsd Namespace:
http://schemas.varigence.com/biml.xsd
Referenceable:
True
Scope Boundary:
False