Class AdomdConnectionManager
Connection manager for Adomd connection to a sql server analysis server.
Inheritance
AdomdConnectionManager
Inherited Members
Namespace: ETLBox.AnalysisServices
Assembly: ETLBox.AnalysisServices.dll
Syntax
public class AdomdConnectionManager : DbConnectionManager<AdomdConnection, AdomdTransaction, AdomdParameter>, IConnectionManager<AdomdConnection, AdomdTransaction>, IConnectionManager, IDisposable
Examples
ControlFlow.DefaultDbConnection = new AdmoConnectionManager(new ConnectionString("..connection string.."));Constructors
AdomdConnectionManager()
Declaration
public AdomdConnectionManager()
AdomdConnectionManager(SqlConnectionString)
Declaration
public AdomdConnectionManager(SqlConnectionString connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| SqlConnectionString | connectionString |
AdomdConnectionManager(string)
Declaration
public AdomdConnectionManager(string connectionString)
Parameters
| Type | Name | Description |
|---|---|---|
| string | connectionString |
Properties
ConnectionType
The database type for the connection manager.
Declaration
public override ConnectionType ConnectionType { get; protected set; }
Property Value
| Type | Description |
|---|---|
| ConnectionType |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.ConnectionType
QB
The quotation begin character that is used in the database. E.g. SqlServer uses: '[' and Postgres: '"'
Declaration
public override string QB { get; protected set; }
Property Value
| Type | Description |
|---|---|
| string |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.QB
QE
The quotation end character that is used in the database. E.g. SqlServer uses: ']' and Postgres: '"'
Declaration
public override string QE { get; protected set; }
Property Value
| Type | Description |
|---|---|
| string |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.QE
Methods
BulkDelete(ITableData)
Performs a bulk delete
Declaration
public override void BulkDelete(ITableData data)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.BulkDelete(ETLBox.ITableData)
BulkInsert(ITableData)
Performs a bulk insert
Declaration
public override void BulkInsert(ITableData data)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.BulkInsert(ETLBox.ITableData)
BulkUpdate(ITableData, ICollection<string>, ICollection<string>)
Performs a bulk update
Declaration
public override void BulkUpdate(ITableData data, ICollection<string> setColumnNames, ICollection<string> joinColumnNames)
Parameters
| Type | Name | Description |
|---|---|---|
| ITableData | data | Batch of data |
| ICollection<string> | setColumnNames | The column names used in the set part of the update statement |
| ICollection<string> | joinColumnNames | The column names to join for the update |
Overrides
CleanUpBulkInsert(string)
Called after the whole bulk insert operation to change back settings made to improve bulk insert performance
Declaration
public override void CleanUpBulkInsert(string tablename)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tablename |
Overrides
Clone()
Cretes a clone of the current connection manager
Declaration
public override IConnectionManager Clone()
Returns
| Type | Description |
|---|---|
| IConnectionManager | A instance copy of the current connection manager |
Overrides
ETLBox.DbConnectionManager<Microsoft.AnalysisServices.AdomdClient.AdomdConnection, Microsoft.AnalysisServices.AdomdClient.AdomdTransaction, Microsoft.AnalysisServices.AdomdClient.AdomdParameter>.Clone()
PrepareBulkInsert(string)
Performs preparations needed to improved performance of a bulk insert operation
Declaration
public override void PrepareBulkInsert(string tablename)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tablename |