Class XmlaTask

This task can exeucte any XMLA.

Inheritance
object
LoggableTask
ControlFlowTask
DbTask
XmlaTask
Implements
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.ControlFlow.Tasks
Assembly: ETLBox.dll
Syntax
    public class XmlaTask : DbTask, ILoggableTask
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

Constructors

XmlaTask()

Declaration
    public XmlaTask()
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

XmlaTask(string, Action, Action, params Action<object>[])

Declaration
    public XmlaTask(string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
TypeNameDescription
stringxmla
System.ActionbeforeRowReadAction
System.ActionafterRowReadAction
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

XmlaTask(string, params Action<object>[])

Declaration
    public XmlaTask(string xmla, params Action<object>[] actions)
Parameters
TypeNameDescription
stringxmla
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

XmlaTask(string, string)

Declaration
    public XmlaTask(string name, string xmla)
Parameters
TypeNameDescription
stringname
stringxmla
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

XmlaTask(string)

Declaration
    public XmlaTask(string xmla)
Parameters
TypeNameDescription
stringxmla
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

Properties

TaskName

Declaration
    public override string TaskName { get; set; }
Property Value
TypeDescription
string
Overrides
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

Methods

ExecuteNonQuery(IConnectionManager, string)

Declaration
    public static int ExecuteNonQuery(IConnectionManager connectionManager, string xmla)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
Returns
TypeDescription
int
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteNonQuery(string)

Declaration
    public static int ExecuteNonQuery(string xmla)
Parameters
TypeNameDescription
stringxmla
Returns
TypeDescription
int
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteReader(IConnectionManager, string, Action, Action, params Action<object>[])

Declaration
    public static void ExecuteReader(IConnectionManager connectionManager, string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
System.ActionbeforeRowReadAction
System.ActionafterRowReadAction
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteReader(IConnectionManager, string, params Action<object>[])

Declaration
    public static void ExecuteReader(IConnectionManager connectionManager, string xmla, params Action<object>[] actions)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteReader(string, Action, Action, params Action<object>[])

Declaration
    public static void ExecuteReader(string xmla, Action beforeRowReadAction, Action afterRowReadAction, params Action<object>[] actions)
Parameters
TypeNameDescription
stringxmla
System.ActionbeforeRowReadAction
System.ActionafterRowReadAction
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteReader(string, params Action<object>[])

Declaration
    public static void ExecuteReader(string xmla, params Action<object>[] actions)
Parameters
TypeNameDescription
stringxmla
System.Action<T><object>[]actions
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalar(IConnectionManager, string)

Declaration
    public static object ExecuteScalar(IConnectionManager connectionManager, string xmla)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
Returns
TypeDescription
object
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalar(string)

Declaration
    public static object ExecuteScalar(string xmla)
Parameters
TypeNameDescription
stringxmla
Returns
TypeDescription
object
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalar<T>(IConnectionManager, string)

Declaration
    public static T? ExecuteScalar<T>(IConnectionManager connectionManager, string xmla) where T : struct
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
Returns
TypeDescription
T?
Type Parameters
NameDescription
T
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalar<T>(string)

Declaration
    public static T? ExecuteScalar<T>(string xmla) where T : struct
Parameters
TypeNameDescription
stringxmla
Returns
TypeDescription
T?
Type Parameters
NameDescription
T
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalarAsBool(IConnectionManager, string)

Declaration
    public static bool ExecuteScalarAsBool(IConnectionManager connectionManager, string xmla)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
stringxmla
Returns
TypeDescription
bool
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

ExecuteScalarAsBool(string)

Declaration
    public static bool ExecuteScalarAsBool(string xmla)
Parameters
TypeNameDescription
stringxmla
Returns
TypeDescription
bool
Examples
XmlaTask.ExecuteNonQuery("Log description here","Xmla goes here...")

Implements