C# Class MdxClient.MdxCommand

Represents an MDX statement to execute against a SQL Server Analysis Services database.

Inheritance: System.Data.Common.DbCommand

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.

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

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

Tries to cancel the execution of an MdxCommand.

public Cancel ( ) : void
return	void

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

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

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

public ExecuteNonQuery ( ) : int
return	int

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

Initializes a new instance of the MdxCommand class.

public MdxCommand ( ) : System
return	System

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

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

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

public Prepare ( ) : void
return	void