C# Class MdxClient.MdxCommand

Represents an MDX statement to execute against a SQL Server Analysis Services database.
Inheritance: System.Data.Common.DbCommand
Exibir arquivo Open project: DynamicTyped/MdxClient Class Usage Examples

Public Methods

Method Description
Cancel ( ) : void

Tries to cancel the execution of an MdxCommand.

ExecuteNonQuery ( ) : int
ExecuteScalar ( ) : object

Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

MdxCommand ( ) : System

Initializes a new instance of the MdxCommand class.

MdxCommand ( string commandText ) : System

Initializes a new instance of the MdxCommand class with the text of the query.

MdxCommand ( string commandText, MdxConnection connection ) : System

Initializes a new instance of the MdxCommand class with the text of the query and a MdxConnection.

Prepare ( ) : void

Creates a prepared version of the command on an instance of SQL Server Analysis Services.

Protected Methods

Method Description
CreateDbParameter ( ) : DbParameter
Dispose ( bool disposing ) : void
ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader

Private Methods

Method Description
AddCellsFromMemberProperties ( IEnumerable specialColumns, Member member, int cellOrdinal, int columnOrdinal ) : IEnumerable
AddColumnsFromColumnAxis ( IEnumerable columns, IEnumerable cells, ResultSet crs ) : void
AddColumnsFromRowAxis ( IEnumerable rows, ResultSet crs ) : int
AddColumnsFromRowProperties ( ResultSet crs, IEnumerable columnMap ) : void

find the tokened column map

AddRows ( IEnumerable rows, List cells, int rowColumnCount, ResultSet crs ) : void
AdjustValueFromColumnType ( Cell cell, int columnIndex, ResultSet crs ) : void
ConvertIt ( string item ) : int
ConvertXmlTypeToType ( string type ) : Type
GetAxis ( System.Xml.Linq.XDocument doc ) : List
GetCellData ( System.Xml.Linq.XDocument doc ) : List
GetColumnMap ( Column column, string columnName = null ) : ColumnMap
GetParams ( ) : IEnumerable
GetTypeForColumn ( IEnumerable cells, Column column, int columnCount ) : Type
GetTypeFromDbType ( DbType dbType ) : Type
PopulateFromXml ( XmlReader xmlReader ) : ResultSet
ProcessOrdinalColumns ( ResultSet crs ) : void
SetColumnNameAndType ( Column column, string defaultName, Type defalutType = null ) : void

Method Details

Cancel() public method

Tries to cancel the execution of an MdxCommand.
public Cancel ( ) : void
return void

CreateDbParameter() protected method

protected CreateDbParameter ( ) : DbParameter
return System.Data.Common.DbParameter

Dispose() protected method

protected Dispose ( bool disposing ) : void
disposing bool
return void

ExecuteDbDataReader() protected method

protected ExecuteDbDataReader ( CommandBehavior behavior ) : System.Data.Common.DbDataReader
behavior CommandBehavior
return System.Data.Common.DbDataReader

ExecuteNonQuery() public method

public ExecuteNonQuery ( ) : int
return int

ExecuteScalar() public method

Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
public ExecuteScalar ( ) : object
return object

MdxCommand() public method

Initializes a new instance of the MdxCommand class.
public MdxCommand ( ) : System
return System

MdxCommand() public method

Initializes a new instance of the MdxCommand class with the text of the query.
public MdxCommand ( string commandText ) : System
commandText string The text of the query.
return System

MdxCommand() public method

Initializes a new instance of the MdxCommand class with the text of the query and a MdxConnection.
public MdxCommand ( string commandText, MdxConnection connection ) : System
commandText string The text of the query.
connection MdxConnection An MdxConnection representing the connection to SQL Server Analysis Services.
return System

Prepare() public method

Creates a prepared version of the command on an instance of SQL Server Analysis Services.
public Prepare ( ) : void
return void