Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

How to use SqlPerformanceEngine class of NBi.Core.Query.Performance package

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

SqlPerformanceEngineTest.cs

Source:SqlPerformanceEngineTest.cs

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

PerformanceEngineFactory.cs

Source:PerformanceEngineFactory.cs

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

SqlPerformanceEngine.cs

Source:SqlPerformanceEngine.cs

...8using NBi.Extensibility.Query;9namespace NBi.Core.Query.Performance10{11    [SupportedCommandType(typeof(SqlCommand))]12    internal class SqlPerformanceEngine : DbCommandPerformanceEngine13    {14        protected internal SqlPerformanceEngine(SqlConnection connection, SqlCommand command)15            : base(new SqlExecutionEngine(connection, command))16        { }17    }18}...

SqlPerformanceEngine

Using AI Code Generation

1using NBi.Core.Query.Performance;2using NBi.Core.Query;3using NBi.Core;4var engine = new SqlPerformanceEngine();5engine.Initialize(new ConnectionStringSettings("connectionString", "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;"));6engine.Execute("select * from Sales.SalesOrderHeader");7using System;8using System.Collections.Generic;9using System.Linq;10using System.Text;11using System.Threading.Tasks;12using NBi.Core.Query.Performance;13using NBi.Core.Query;14using NBi.Core;15var engine = new SqlPerformanceEngine();16engine.Initialize(new ConnectionStringSettings("connectionString", "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;"));17engine.Execute("select * from Sales.SalesOrderHeader");18I have the same problem, but I'm using the NBi.Core.Query.Performance package. I'm able to use the class in the same project, but when I load it in another project (using #load directive) it doesn't work. I'm

SqlPerformanceEngine

Using AI Code Generation

1using NBi.Core.Query.Performance;2var engine = new SqlPerformanceEngine();3var result = engine.Execute(4    new SqlPerformanceCommand(5        new SqlClientFactory(),6        @"Server=.\SQL2012;Integrated Security=true;Initial Catalog=AdventureWorks",7        new List<SqlPerformanceParameter>() { new SqlPerformanceParameter("SalesOrderID", 71774) }8    );9using NBi.Core.Query.Performance;10var engine = new SqlPerformanceEngine();11var result = engine.Execute(12    new SqlPerformanceCommand(13        new SqlClientFactory(),14        @"Server=.\SQL2012;Integrated Security=true;Initial Catalog=AdventureWorks",15        new List<SqlPerformanceParameter>() { new SqlPerformanceParameter("SalesOrderID", 71774) }16    );17using NBi.Core.Query.Performance;18var engine = new SqlPerformanceEngine();19var result = engine.Execute(20    new SqlPerformanceCommand(21        new SqlClientFactory(),22        @"Server=.\SQL2012;Integrated Security=true;Initial Catalog=AdventureWorks",23        new List<SqlPerformanceParameter>() { new SqlPerformanceParameter("SalesOrderID", 71774) }24    );25using NBi.Core.Query.Performance;26var engine = new SqlPerformanceEngine();27var result = engine.Execute(28    new SqlPerformanceCommand(29        new SqlClientFactory(),30        @"Server=.\SQL2012;Integrated Security=true;Initial Catalog=AdventureWorks",31        new List<SqlPerformanceParameter>() { new SqlPerformanceParameter("SalesOrderID", 71774) }32    );

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.