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

Copied to Clipboard!

How to use OdbcPerformanceEngine method of NBi.Core.Query.Performance.OdbcPerformanceEngine class

Best NBi code snippet using NBi.Core.Query.Performance.OdbcPerformanceEngine.OdbcPerformanceEngine

OdbcPerformanceEngineTest.cs

Source:OdbcPerformanceEngineTest.cs

...7using NBi.Core.Query.Performance;8namespace NBi.Testing.Integration.Core.Query.Performance9{10    [TestFixture]11    public class OdbcPerformanceEngineTest12    {13        [Test]14        public void CheckPerformance_OneQuery_ReturnElapsedTime()15        {16            var sql = "WAITFOR DELAY '00:00:00';";17            var cmd = new OdbcCommand(sql, new OdbcConnection(ConnectionStringReader.GetOdbcSql()));18            var qp = new OdbcPerformanceEngine(cmd.Connection, cmd);19            var res = qp.Execute(new TimeSpan(0, 1, 0));20            Assert.That(res.TimeElapsed.TotalMilliseconds, Is.GreaterThanOrEqualTo(0).And.LessThan(5000));21            Assert.That(res.IsTimeOut, Is.False);22        }23        [Test]24        public void Execute_OneQueryHavingTimeout_ReturnTimeoutInfo()25        {26            var query = "WAITFOR DELAY '00:00:03';";27            var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetOdbcSql()));28            var qp = new OdbcPerformanceEngine(cmd.Connection, cmd);29            var res = qp.Execute(new TimeSpan(0, 0, 1));30            Assert.That(res.TimeOut.TotalMilliseconds, Is.EqualTo(1000));31            Assert.That(res.IsTimeOut, Is.True);32        }33        [Test]34        [Category("LocalSQL")]35        [Ignore("Privilege is too high")]36        public void CleanCache_Any_DoesNotThrow()37        {38            var query = "select 1;";39            var cmd = new OdbcCommand(query, new OdbcConnection(ConnectionStringReader.GetLocalOdbcSql()));40            var qp = new OdbcPerformanceEngine(cmd.Connection, cmd);41            Assert.DoesNotThrow(() => qp.CleanCache());42        }43    }44}...

PerformanceEngineFactory.cs

Source:PerformanceEngineFactory.cs

...16        public PerformanceEngineFactory()17        {18            RegisterEngines(new[] {19                typeof(AdomdPerformanceEngine),20                typeof(OdbcPerformanceEngine),21                typeof(OleDbPerformanceEngine),22                typeof(SqlPerformanceEngine) }23            );24        }25    }26}...

OdbcPerformanceEngine.cs

Source:OdbcPerformanceEngine.cs

...7using NBi.Extensibility.Query;8namespace NBi.Core.Query.Performance9{10    [SupportedCommandType(typeof(OdbcCommand))]11    internal class OdbcPerformanceEngine : DbCommandPerformanceEngine12    {13        protected internal OdbcPerformanceEngine(OdbcConnection connection, OdbcCommand command)14            : base(new OdbcExecutionEngine(connection, command))15        { }16    }17}...

OdbcPerformanceEngine

Using AI Code Generation

1using System;2using System.Data;3using System.Data.Odbc;4using System.Collections.Generic;5using System.Linq;6using System.Text;7using System.Threading.Tasks;8using NBi.Core.Query.Performance;9{10    {11        static void Main(string[] args)12        {13            string connectionString = "Driver={SQL Server Native Client 11.0};Server=ServerName;Database=DatabaseName;Trusted_Connection=yes;";14            string query = "select * from TableName";15            OdbcConnection odbcConnection = new OdbcConnection(connectionString);16            OdbcPerformanceEngine odbcPerformanceEngine = new OdbcPerformanceEngine(odbcConnection);17            odbcPerformanceEngine.Query = query;18            odbcPerformanceEngine.Execute();19            DataTable result = odbcPerformanceEngine.Result;20            odbcConnection.Close();21        }22    }23}24using System;25using System.Data;26using System.Data.Odbc;27using System.Collections.Generic;28using System.Linq;29using System.Text;30using System.Threading.Tasks;31using NBi.Core.Query.Performance;32{33    {34        static void Main(string[] args)35        {36            string connectionString = "Driver={SQL Server Native Client 11.0};Server=ServerName;Database=DatabaseName;Trusted_Connection=yes;";37            string query = "select * from TableName";38            OdbcConnection odbcConnection = new OdbcConnection(connectionString);39            OdbcPerformanceEngine odbcPerformanceEngine = new OdbcPerformanceEngine(odbcConnection);40            odbcPerformanceEngine.Query = query;41            odbcPerformanceEngine.Execute();42            DataTable result = odbcPerformanceEngine.Result;43            odbcConnection.Close();44        }45    }46}

OdbcPerformanceEngine

Using AI Code Generation

1using System;2using System.Data;3using System.Data.Odbc;4using System.Diagnostics;5using System.IO;6using System.Text;7using NBi.Core.Query.Performance;8{9    {10        private readonly string connectionString;11        private readonly string commandText;12        private readonly string counter;13        private readonly string category;14        private readonly string instance;15        private readonly string machineName;16        public OdbcPerformanceEngine(string connectionString, string commandText, string counter, string category, string instance, string machineName)17        {18            this.connectionString = connectionString;19            this.commandText = commandText;20            this.counter = counter;21            this.category = category;22            this.instance = instance;23            this.machineName = machineName;24        }25        public long Execute()26        {27            var stopwatch = new Stopwatch();28            stopwatch.Start();29            using (var connection = new OdbcConnection(connectionString))30            {31                connection.Open();32                using (var command = new OdbcCommand(commandText, connection))33                {34                    command.ExecuteNonQuery();35                }36            }37            stopwatch.Stop();38            return stopwatch.ElapsedMilliseconds;39        }40        public PerformanceResult GetPerformance()41        {42            var stopwatch = new Stopwatch();43            stopwatch.Start();44            using (var connection = new OdbcConnection(connectionString))45            {46                connection.Open();47                using (var command = new OdbcCommand(commandText, connection))48                {49                    command.ExecuteNonQuery();50                }51            }52            stopwatch.Stop();53            var result = new PerformanceResult();54            result.Duration = stopwatch.ElapsedMilliseconds;55            if (!string.IsNullOrEmpty(counter) && !string.IsNullOrEmpty(category))56            {57                var performanceCounter = new PerformanceCounter(category, counter, instance, machineName);58                result.Counter = performanceCounter.NextValue();59            }60            return result;61        }62    }63}64using System;65using System.Data;66using System.Data.Odbc;67using System.Diagnostics;68using System.IO;69using System.Text;70using NBi.Core.Query.Performance;71{72    {73        private readonly string connectionString;74        private readonly string commandText;75        private readonly string counter;76        private readonly string category;77        private readonly string instance;78        private readonly string machineName;

OdbcPerformanceEngine

Using AI Code Generation

1using System;2using System.Data;3using System.Data.Odbc;4using System.Data.Common;5using System.Collections.Generic;6using System.Linq;7using System.Text;8using System.Threading.Tasks;9using NBi.Core.Query.Performance;10using NBi.Core.Query;11using NBi.Core.Query.Command;12using NBi.Core.Query.Resolver;13using NBi.Core.Query.Client;14using NBi.Core.Query.Execution;15using NBi.Core.Query.Reader;16using NBi.Core.Query.Performance;17using NBi.Core.Query.Performance.Command;18using NBi.Core.Query.Performance.Execution;19using NBi.Core.Query.Performance.Reader;20{21    {22        static void Main(string[] args)23        {24            OdbcPerformanceEngine perfEng = new OdbcPerformanceEngine();25            OdbcCommand cmd = new OdbcCommand();26            cmd.CommandText = "SELECT * FROM [dbo].[Table1]";27            OdbcConnection conn = new OdbcConnection();28            conn.ConnectionString = "Driver={SQL Server};Server=ServerName;Database=DatabaseName;Trusted_Connection=yes;";29            cmd.Connection = conn;30            OdbcCommandPerformanceEngineArgs cmdArgs = new OdbcCommandPerformanceEngineArgs(cmd);31            OdbcCommandPerformanceEngineArgs cmdArgs2 = new OdbcCommandPerformanceEngineArgs(cmd);32            OdbcCommandPerformanceEngineArgs cmdArgs3 = new OdbcCommandPerformanceEngineArgs(cmd);33            OdbcCommandPerformanceEngineArgs cmdArgs4 = new OdbcCommandPerformanceEngineArgs(cmd);34            OdbcCommandPerformanceEngineArgs cmdArgs5 = new OdbcCommandPerformanceEngineArgs(cmd);

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.