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

Automation Advisor
NBi
NBi.NUnit.Runtime
ConnectionStringsFinder

How to use ConnectionStringsFinder class of NBi.NUnit.Runtime package

Best NBi code snippet using NBi.NUnit.Runtime.ConnectionStringsFinder

TestSuite.cs

Source:TestSuite.cs

...27        public string SettingsFilename { get; set; }2829        internal XmlManager TestSuiteManager { get; private set; }30        internal TestSuiteFinder TestSuiteFinder { get; set; }31        internal ConnectionStringsFinder ConnectionStringsFinder { get; set; }32        internal ConfigurationFinder ConfigurationFinder { get; set; }3334        public TestSuite()35        {36            TestSuiteManager = new XmlManager();37            TestSuiteFinder = new TestSuiteFinder();38            ConnectionStringsFinder = new ConnectionStringsFinder();39            ConfigurationFinder = new ConfigurationFinder();40        }4142        internal TestSuite(XmlManager testSuiteManager, TestSuiteFinder testSuiteFinder)43        {44            TestSuiteManager = testSuiteManager;45            TestSuiteFinder = testSuiteFinder;46        }4748        [Test, TestCaseSource("GetTestCases")]49        public virtual void ExecuteTestCases(TestXml test)50        {51            Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Test loaded by {0}", GetOwnFilename()));52            Trace.WriteLineIf(NBiTraceSwitch.TraceInfo, string.Format("Test defined in {0}", TestSuiteFinder.Find()));5354            //check if ignore is set to true55            if (test.Ignore)56                Assert.Ignore(test.IgnoreReason);57            else58            {59                ExecuteChecks(test.Condition);60                ExecuteSetup(test.Setup);61                foreach (var tc in test.Systems)62                {63                    foreach (var ctr in test.Constraints)64                    {65                        var testCase = new TestCaseFactory().Instantiate(tc, ctr);66                        AssertTestCase(testCase.SystemUnderTest, testCase.Constraint, test.Content);67                    }68                }69                ExecuteCleanup(test.Cleanup);70            }71        }7273        private void ExecuteChecks(ConditionXml check)74        {75            foreach (var predicate in check.Predicates)76            {77                var impl = new DecorationFactory().Get(predicate);78                var isVerified = impl.Validate();79                if (!isVerified)80                    Assert.Ignore("This test has been ignored because following check wasn't successful: {0}", impl.Message);81            }82        }8384        private void ExecuteSetup(SetupXml setup)85        {86            try87            {88                foreach (var command in setup.Commands)89                {90                    var impl = new DecorationFactory().Get(command);91                    impl.Execute();92                }93            }94            catch (Exception ex)95            {96                HandleExceptionDuringSetup(ex);97            }98        }99100        protected virtual void HandleExceptionDuringSetup(Exception ex)101        {102            var message = string.Format("Exception during the setup of the test: {0}", ex.Message);103            Trace.WriteLineIf(NBiTraceSwitch.TraceWarning, message);104            //If failure during setup then the test is failed!105            Assert.Fail(message);106        }107108        private void ExecuteCleanup(CleanupXml cleanup)109        {110            try111            {112                foreach (var command in cleanup.Commands)113                {114                    var impl = new DecorationFactory().Get(command);115                    impl.Execute();116                }117            }118            catch (Exception ex)119            {120                HandleExceptionDuringCleanup(ex);121            }122        }123124        protected virtual void HandleExceptionDuringCleanup(Exception ex)125        {126            var message = string.Format("Exception during the cleanup of the test: {0}", ex.Message);127            Trace.WriteLineIf(NBiTraceSwitch.TraceWarning, message);128            Trace.WriteLineIf(NBiTraceSwitch.TraceWarning, "Next cleanup functions are skipped.");129        }130131        public virtual void ExecuteTest(string testSuiteXml)132        {133            Trace.WriteLineIf(NBiTraceSwitch.TraceInfo, testSuiteXml);134135            byte[] byteArray = Encoding.ASCII.GetBytes(testSuiteXml);136            var stream = new MemoryStream(byteArray);137            var sr = new StreamReader(stream);138139            TestSuiteManager.Read(sr);140            foreach (var test in TestSuiteManager.TestSuite.Tests)141                ExecuteTestCases(test);142        }143144        /// <summary>145        /// Handles the standard assertion and if needed rethrow a new AssertionException with a modified stacktrace146        /// </summary>147        /// <param name="systemUnderTest"></param>148        /// <param name="constraint"></param>149        protected internal void AssertTestCase(Object systemUnderTest, NUnitCtr.Constraint constraint, string stackTrace)150        {151            try152            {153                Assert.That(systemUnderTest, constraint);154            }155            catch (AssertionException ex)156            {157                throw new CustomStackTraceAssertionException(ex, stackTrace);158            }159            catch (NBiException ex)160            {161                throw new CustomStackTraceErrorException(ex, stackTrace);162            }163        }164165        public IEnumerable<TestCaseData> GetTestCases()166        {167            //Find configuration of NBi168            if (ConfigurationFinder != null)169                ApplyConfig(ConfigurationFinder.Find());170171            //Find connection strings referecned from an external file172            if (ConnectionStringsFinder != null)173                TestSuiteManager.ConnectionStrings = ConnectionStringsFinder.Find();174175            //Build the Test suite176            var testSuiteFilename = TestSuiteFinder.Find();177            TestSuiteManager.Load(testSuiteFilename, SettingsFilename, AllowDtdProcessing);178179            return BuildTestCases();180        }181  182        internal IEnumerable<TestCaseData> BuildTestCases()183        {184            List<TestCaseData> testCasesNUnit = new List<TestCaseData>();185186            testCasesNUnit.AddRange(BuildTestCases(TestSuiteManager.TestSuite.Tests));187            testCasesNUnit.AddRange(BuildTestCases(TestSuiteManager.TestSuite.Groups));
...

ConnectionStringsFinder.cs

Source:ConnectionStringsFinder.cs

...7using NBi.Core;89namespace NBi.NUnit.Runtime10{11	public class ConnectionStringsFinder12	{13		protected internal virtual NameValueCollection Find()14		{15			var list = new NameValueCollection();16			string configFile = AppDomain.CurrentDomain.SetupInformation.ConfigurationFile;17			//Try to find a config file, if existing take the path inside for the TestSuite18			if (File.Exists(configFile))19			{20				//line bellow to avoid .Net framework bug: http://support.microsoft.com/kb/2580188/en-us21				var configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);2223				if (configuration.ConnectionStrings != null)24				{25					Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Section 'connectionStrings' found."));
...

ConnectionStringsFinder

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.NUnit.Runtime;7{8    {9        static void Main(string[] args)10        {11            var finder = new ConnectionStringsFinder();12            var connStrings = finder.Find();13            foreach (var connString in connStrings)14            {15                Console.WriteLine(connString);16            }17            Console.ReadKey();18        }19    }20}

ConnectionStringsFinder

Using AI Code Generation

1using NBi.NUnit.Runtime;2using NBi.NUnit.Runtime.Configuration;3using System;4using System.Collections.Generic;5using System.Linq;6using System.Text;7using System.Threading.Tasks;8{9    {10        static void Main(string[] args)11        {12            var finder = new ConnectionStringsFinder();13            var connectionStrings = finder.GetConnectionStrings();14            foreach (var connectionString in connectionStrings)15            {16                Console.WriteLine(connectionString);17            }18            Console.ReadKey();19        }20    }21}22Data Source=.\SQL2014;Initial Catalog=AdventureWorks2014;Integrated Security=True23Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014;Integrated Security=True24Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP2;Integrated Security=True25Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3;Integrated Security=True26Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_1;Integrated Security=True27Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_2;Integrated Security=True28Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_3;Integrated Security=True29Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_4;Integrated Security=True30Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_5;Integrated Security=True31Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_6;Integrated Security=True32Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_7;Integrated Security=True33Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_8;Integrated Security=True34Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_9;Integrated Security=True35Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_10;Integrated Security=True36Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3_11;Integrated Security=True37Data Source=.\SQL2014;Initial Catalog=AdventureWorksDW2014CTP3

ConnectionStringsFinder

Using AI Code Generation

1var finder = new ConnectionStringsFinder();2var connectionStrings = finder.Find();3foreach (var connectionString in connectionStrings)4{5    Console.WriteLine(connectionString.Name);6    Console.WriteLine(connectionString.ConnectionString);7    Console.WriteLine(connectionString.ProviderName);8    Console.WriteLine();9}10var connectionStringSettings = new ConnectionStringSettings("name", "connectionString", "providerName");11var finder = new ConnectionStringSettingsFinder();12var connectionStringSettings = finder.Find("name");13Console.WriteLine(connectionStringSettings.Name);14Console.WriteLine(connectionStringSettings.ConnectionString);15Console.WriteLine(connectionStringSettings.ProviderName);16Console.WriteLine();17var finder = new ConnectionStringSettingsFinder();18var connectionStringSettings = finder.Find("name");19var connectionString = new ConnectionString(connectionStringSettings);20Console.WriteLine(connectionString.Name);21Console.WriteLine(connectionString.ConnectionString);22Console.WriteLine(connectionString.ProviderName);23Console.WriteLine();24var finder = new ConnectionStringSettingsFinder();25var connectionStringSettings = finder.Find("name");26var connectionString = new ConnectionString(connectionStringSettings);27var factory = new AdomdFactory();28var connection = factory.Instantiate(connectionString);29var finder = new ConnectionStringSettingsFinder();30var connectionStringSettings = finder.Find("name");31var connectionString = new ConnectionString(connectionStringSettings);32var factory = new AdomdFactory();33var connection = factory.Instantiate(connectionString);34var command = connection.CreateCommand();35command.CommandText = "SELECT [Measures].[Internet Sales Amount] ON COLUMNS FROM [Adventure Works]";36var reader = command.ExecuteReader();37var table = new DataTable();38table.Load(reader);39Console.WriteLine(table.Rows[0][0]);40var finder = new ConnectionStringSettingsFinder();41var connectionStringSettings = finder.Find("name");42var connectionString = new ConnectionString(connectionStringSettings);43var factory = new AdomdFactory();44var connection = factory.Instantiate(connectionString);45var command = connection.CreateCommand();

ConnectionStringsFinder

Using AI Code Generation

1var finder = new ConnectionStringsFinder();2var connectionStrings = finder.GetConnectionStrings();3var connectionStrings = ConfigurationManager.ConnectionStrings;4var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();5var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();6var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();7var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();8var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();9var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();10var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();11var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();12var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();13var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();14var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();15var connectionStrings = new ConfigurationBuilder().Build().GetSection("ConnectionStrings").Get<ConnectionStringSettingsCollection>();

ConnectionStringsFinder

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.NUnit.Runtime;7{8    {9        static void Main(string[] args)10        {11            var conn = ConnectionStringsFinder.GetConnectionString("TestConnectionString");12            Console.WriteLine(conn);13            Console.ReadLine();14        }15    }16}17Data Source=.\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True

ConnectionStringsFinder

Using AI Code Generation

1var finder = new ConnectionStringsFinder();2var connectionStrings = finder.Find();3foreach (var connectionString in connectionStrings)4{5    Console.WriteLine(connectionString.Name);6    Console.WriteLine(connectionString.ConnectionString);7}8The SSIS Catalog is disabled by default in SQL Server 2012 and 2014. To enable the SSIS Catalog, you can use the following SQL Server Management Studio (SSMS) script:9The SSIS Catalog is disabled by default in SQL Server 2012 and 2014. To enable the SSIS Catalog, you can use the following SQL Server Management Studio (SSMS) script:

ConnectionStringsFinder

Using AI Code Generation

1var finder = new ConnectionStringsFinder();2var finder = new ConnectionStringsFinder();3var finder = new ConnectionStringsFinder();4var finder = new ConnectionStringsFinder();5var finder = new ConnectionStringsFinder();6var finder = new ConnectionStringsFinder();7var finder = new ConnectionStringsFinder();8var finder = new ConnectionStringsFinder();9var finder = new ConnectionStringsFinder();

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.