Ado Net Connection Element
X-Ref:
- Ast Ado Net Connection Node
- Ast Db Connection Node
- Ast Connection Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| ConnectionString | String | This value specifies how to open the connection for the specified data source. This is a required property | |
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| Provider | String | 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). This is a required property | |
| CreateInProject | Boolean | False | 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. |
| CreatePackageConfiguration | Boolean | True | This value specifies whether a PackageConfiguration should be created for this connection. |
| DelayValidation | Boolean | False | 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. |
| LogicalDisplayFolder | String | string.Empty | Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio. |
| LookupProviderFactory | Boolean | True | 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. |
| MaxActiveConnections | Int32 | 0 | This value specifies the maximum number of concurrent connections allowed. |
| RetainSameConnection | Boolean | False | This value indicates whether the same connection can be used for multiple tasks. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <AnalysisMetadata /> | AstAnalysisServicesConnectionMetadataNode | The SQL Server Analysis Services (SSAS) connection information node specifies supplemental information that is used by SSAS to connect to a given data source, usually in context of development and cube processing. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | 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. |
| <Expressions> <Expression /> </Expressions> | AstPropertyExpressionNode | This is a collection of SSIS expression definitions for connection property value overrides. |