Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use AdomdExecutionEngine class of NBi.Core.Query.Execution package

Best NBi code snippet using NBi.Core.Query.Execution.AdomdExecutionEngine

AdomdExecutionEngineTest.cs

Source:AdomdExecutionEngineTest.cs

...6namespace NBi.Testing.Integration.Core.Query.Execution7{8    [TestFixture]9    [Category("Olap")]10    public class AdomdExecutionEngineTest11    {12        [Test]13        public void Execute_ValidQuery_DataSetFilled()14        {15            var query = "SELECT [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year] ON 1 FROM [Adventure Works]";16            var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));17            var qe = new AdomdExecutionEngine(cmd.Connection, cmd);18            var ds = qe.Execute();19            Assert.IsInstanceOf<string>(ds.Tables[0].Rows[0][0]);20            Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "CY 2005");21            Assert.AreEqual((string)ds.Tables[0].Rows[1][0], "CY 2006");22            Assert.IsInstanceOf<double>(ds.Tables[0].Rows[1][1]);23        }24        [Test]25        public void Execute_ValidMdxWithNull_GetResult()26        {27            var query = "SELECT  [Measures].[Amount] ON 0, [Date].[Calendar].[Calendar Year].&[2010] ON 1 FROM [Adventure Works]";28            var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomd()));29            var qe = new AdomdExecutionEngine(cmd.Connection, cmd);30            var ds = qe.Execute();31            Assert.IsInstanceOf<string>(ds.Tables[0].Rows[0][0]);32            Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "CY 2010");33            Assert.IsInstanceOf<DBNull>(ds.Tables[0].Rows[0][1]);34            Assert.That(ds.Tables[0].Rows[0].IsNull(1), Is.True);35        }36        [Test]37        public void Execute_ValidDax_GetResult()38        {39            var query = "EVALUATE CALCULATETABLE(VALUES('Product Subcategory'[Product Subcategory Name]),'Product Category'[Product Category Name] = \"Bikes\")";40            var cmd = new AdomdCommand(query, new AdomdConnection(ConnectionStringReader.GetAdomdTabular()));41            var qe = new AdomdExecutionEngine(cmd.Connection, cmd);42            var ds = qe.Execute();43            Assert.IsInstanceOf<string>(ds.Tables[0].Rows[0][0]);44            Assert.AreEqual((string)ds.Tables[0].Rows[0][0], "Mountain Bikes");45            Assert.AreEqual((string)ds.Tables[0].Rows[1][0], "Road Bikes");46            Assert.AreEqual((string)ds.Tables[0].Rows[2][0], "Touring Bikes");47            Assert.AreEqual(ds.Tables[0].Rows.Count, 3);48            Assert.AreEqual(ds.Tables[0].Columns.Count, 1);49        }50    }51}...

AdomdExecutionEngine.cs

Source:AdomdExecutionEngine.cs

...13    /// Engine wrapping the Microsoft.AnalysisServices.AdomdClient namespace for execution of NBi tests14    /// <remarks>Instances of this class are built by the means of the <see>ExecutionEngineFactory</see></remarks>15    /// </summary>16    [SupportedCommandType(typeof(AdomdCommand))]17    internal class AdomdExecutionEngine : DbCommandExecutionEngine18    {19        public AdomdExecutionEngine(AdomdConnection connection, AdomdCommand command)20            : base(connection, command)21        { }22        internal override void OpenConnection(IDbConnection connection)23        {24            var connectionString = Command.Connection.ConnectionString;25            try26            { connection.ConnectionString = connectionString; }27            catch (ArgumentException ex)28            { throw new ConnectionException(ex, connectionString); }29            try30            { connection.Open(); }31            catch (Exception ex)32            { throw new ConnectionException(ex, connectionString); }33        }...

ExecutionEngineFactory.cs

Source:ExecutionEngineFactory.cs

...13    public class ExecutionEngineFactory: EngineFactory<IExecutionEngine>14    {15        private Type[] classics = new[] 16        {17            typeof(AdomdExecutionEngine),18            typeof(OdbcExecutionEngine),19            typeof(OleDbExecutionEngine),20            typeof(SqlExecutionEngine)21        };22        public ExecutionEngineFactory() 23            : base()24        {25            RegisterEngines(classics);26        }27        public ExecutionEngineFactory(ClientProvider clientProvider, CommandProvider commandProvider)28            : base(clientProvider, commandProvider)29        {30            RegisterEngines(classics);31        }...

AdomdExecutionEngine

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Execution;7using System.Data;8{9    {10        static void Main(string[] args)11        {12            AdomdExecutionEngine adomd = new AdomdExecutionEngine();13            var connection = new NBi.Core.Query.Client.Adomd.AdomdClient();14            connection.ConnectionString = "Provider=MSOLAP;Data Source=localhost;Initial Catalog=Adventure Works DW 2008R2;Cube Name=Adventure Works;Integrated Security=SSPI;";15            adomd.Initialize(connection);16            var result = adomd.ExecuteQuery("select [Measures].[Internet Sales Amount] on 0, [Product].[Product Categories].[Category].Members on 1 from [Adventure Works]");17            var table = result.Table;18            foreach (DataRow row in table.Rows)19            {20                foreach (DataColumn column in table.Columns)21                {22                    Console.Write(row[column] + " ");23                }24                Console.WriteLine();25            }26        }27    }28}

AdomdExecutionEngine

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Execution;7{8    {9        static void Main(string[] args)10        {11            AdomdExecutionEngine engine = new AdomdExecutionEngine();12            engine.ConnectionString = "Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works DW 2008R2";13            engine.CommandText = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY [Date].[Calendar].[Calendar Year].Members ON ROWS FROM [Adventure Works]";14            var result = engine.Execute();15        }16    }17}18using System;19using System.Collections.Generic;20using System.Linq;21using System.Text;22using System.Threading.Tasks;23using NBi.Core.Query.Reader;24{25    {26        static void Main(string[] args)27        {28            AdomdDataReader reader = new AdomdDataReader();29            reader.ConnectionString = "Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works DW 2008R2";30            reader.CommandText = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY [Date].[Calendar].[Calendar Year].Members ON ROWS FROM [Adventure Works]";31            var result = reader.Execute();32        }33    }34}35using System;36using System.Collections.Generic;37using System.Linq;38using System.Text;39using System.Threading.Tasks;40using NBi.Core.Query.Execution;41{42    {43        static void Main(string[] args)44        {45            AdomdCommandBuilder builder = new AdomdCommandBuilder();46            builder.ConnectionString = "Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works DW 2008R2";47            builder.CommandText = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY [Date].[Calendar].[Calendar Year].Members ON ROWS FROM [Adventure Works]";48            var result = builder.Build();49        }50    }51}

AdomdExecutionEngine

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using NBi.Core.Query.Execution;6using Microsoft.AnalysisServices.AdomdClient;7using System.Data;8{9    {10        static void Main(string[] args)11        {12            AdomdExecutionEngine objAdomdExecutionEngine = new AdomdExecutionEngine();13            AdomdCommand objAdomdCommand = new AdomdCommand();14            AdomdConnection objAdomdConnection = new AdomdConnection();15            objAdomdCommand.Connection = objAdomdConnection;16            objAdomdCommand.CommandText = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY [Customer].[Customer Geography].[Country].Members ON ROWS FROM [Adventure Works]";17            objAdomdExecutionEngine.Command = objAdomdCommand;18            DataTable dt = objAdomdExecutionEngine.Execute();19        }20    }21}22I am trying to use NBi to test a SSAS cube. I am able to connect to the SSAS cube using the following code. However, I am getting an error when I try to execute the query against the SSAS cube. I am using the AdomdExecutionEngine class from the NBi.Core.Query.Execution package. The error I am getting is "The type or namespace name 'AdomdExecutionEngine' could not be found (are you missing a using directive or an assembly reference?)". I am using Visual Studio 2010. I have installed the package using the NuGet package manager. I have also tried to install the package using the Visual Studio package manager console. I am getting the same error in both cases. I have also tried to add a reference to Microsoft.AnalysisServices.Adom

AdomdExecutionEngine

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Query.Execution;7using NBi.Core.Query;8using NBi.Core.Query.Client;9using NBi.Core.Query.Resolver;10using NBi.Core.Query.Command;11using System.Data;12{13{14static void Main(string[] args)15{16string connectionString = "Provider=MSOLAP;Data Source=ServerName;Initial Catalog=DatabaseName";17AdomdExecutionEngine engine = new AdomdExecutionEngine();18AdomdCommand command = new AdomdCommand();19command.ConnectionString = connectionString;20command.CommandText = "SELECT { [Measures].[Total Sales] } ON COLUMNS, { [Product].[Product Categories].[Category].&[1] } ON ROWS FROM [Adventure Works]";21IDataReader reader = engine.Execute(command);22while (reader.Read())23{24Console.WriteLine(reader[0]);25}26Console.ReadLine();27}28}29}

AdomdExecutionEngine

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using NBi.Core.Query.Execution;6using NBi.Core.Query;7using System.Data;8using System.Data.OleDb;9using System.Data.Common;10using Microsoft.AnalysisServices.AdomdClient;11using System.Collections;12using System.Data.SqlClient;13using System.IO;14{15    {16        static void Main(string[] args)17        {18            string connectionString = "Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works";19            string query = "SELECT {[Measures].[Internet Sales Amount]} ON COLUMNS, " +20            "NON EMPTY {[Date].[Calendar].[Calendar Year].&[2003]} ON ROWS " +21            "FROM [Adventure Works]";22            AdomdExecutionEngine engine = new AdomdExecutionEngine();23            IQuery queryObj = new AdomdCommandQuery(query, connectionString);24            var result = engine.Execute(queryObj);25            foreach (DataRow row in result.Rows)26            {27                Console.WriteLine(row[0]);28            }29            Console.ReadLine();30        }31    }32}

AdomdExecutionEngine

Using AI Code Generation

1using NBi.Core.Query.Execution;2using System;3using System.Collections.Generic;4using System.Data.OleDb;5using System.Linq;6using System.Text;7using System.Threading.Tasks;8using System.Data;9{10    {11        static void Main(string[] args)12        {13            string connectionString = "Provider=MSOLAP;Data Source=.;Initial Catalog=Adventure Works DW 2008R2;Integrated Security=SSPI";14            string query = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS, NON EMPTY [Date].[Fiscal].[Fiscal Year].Members ON ROWS FROM [Adventure Works]";15            AdomdExecutionEngine engine = new AdomdExecutionEngine();16            engine.Initialize(connectionString);17            var result = engine.Execute(query);18            foreach (DataRow row in result.Rows)19            {20                foreach (var item in row.ItemArray)21                {22                    Console.WriteLine(item.ToString());23                }24            }25            Console.ReadLine();26        }27    }28}

AdomdExecutionEngine

Using AI Code Generation

1using NBi.Core.Query.Execution;2using System.Data;3using System.Data.OleDb;4using System.Data.Odbc;5using System.Data.Common;6using System;7using System.Collections.Generic;8using System.Linq;9using System.Text;10using System.Threading.Tasks;11{12    {13        static void Main(string[] args)14        {15            AdomdConnection conn = new AdomdConnection("Provider=MSOLAP.5;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Adventure Works DW 2008R2;Data Source=MYPC");16            conn.Open();17            AdomdCommand cmd = new AdomdCommand("SELECT [Measures].[Internet Sales Amount] ON COLUMNS, [Date].[Calendar].[Calendar Year].MEMBERS ON ROWS FROM [Adventure Works]");18            cmd.Connection = conn;19            AdomdDataReader dr = cmd.ExecuteReader();20            while (dr.Read())21            {22                Console.WriteLine(dr[0].ToString());23            }24            dr.Close();25            conn.Close();26        }27    }28}

AdomdExecutionEngine

Using AI Code Generation

1using NBi.Core.Query.Execution;2using System.Data.OleDb;3using System.Data;4using System.Collections.Generic;5using System;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9using System.Data.Common;10using System.IO;11using System.Xml.Linq;12using System.Xml;13using System.Xml.XPath;14using System.Xml.Serialization;15using System.Runtime.Serialization.Formatters.Binary;16using System.Runtime.Serialization;17using System.Security.Cryptography;18using System.Security.Cryptography.Xml;19using System.Security.Cryptography.X509Certificates;20{21    {22        static void Main(string[] args)23        {24            using (AdomdExecutionEngine engine = new AdomdExecutionEngine())25            {26                engine.Initialize(connectionString);27                var result = engine.Execute("select [Measures].[Internet Sales Amount] on 0, [Customer].[Customer Geography].[Country] on 1 from [Adventure Works]");28                var dt = result.Table;29                foreach (DataRow row in dt.Rows)30                {31                    Console.WriteLine(row[0].ToString() + " " + row[1].ToString());32                }33            }34            Console.ReadLine();35        }36    }37}

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.