AdomdConnectionManager

Class AdomdConnectionManager

Connection manager for Adomd connection to a sql server analysis server.

Inheritance
DbConnectionManager<AdomdConnection, AdomdTransaction, AdomdParameter>
AdomdConnectionManager
Implements
IConnectionManager<AdomdConnection, AdomdTransaction>
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
TypeNameDescription
SqlConnectionStringconnectionString

AdomdConnectionManager(string)

Declaration
    public AdomdConnectionManager(string connectionString)
Parameters
TypeNameDescription
stringconnectionString

Properties

ConnectionType

The database type for the connection manager.

Declaration
    public override ConnectionType ConnectionType { get; protected set; }
Property Value
TypeDescription
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
TypeDescription
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
TypeDescription
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
TypeNameDescription
ITableDatadata

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
TypeNameDescription
ITableDatadata

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
TypeNameDescription
ITableDatadata

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
TypeNameDescription
stringtablename
Overrides

Clone()

Cretes a clone of the current connection manager

Declaration
    public override IConnectionManager Clone()
Returns
TypeDescription
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
TypeNameDescription
stringtablename
Overrides

Implements