public void Configure_Without_ServiceInfo_Returns_Config() { var configurer = new SqlServerProviderConfigurer(); var opts = configurer.Configure(null, config); Assert.Contains("Data Source=localhost,1433", opts); Assert.Contains("User Id=username;", opts); Assert.Contains("Password=password;", opts); Assert.Contains("Initial Catalog=database;", opts); }
public void Configure_With_ServiceInfo_NamedInstance_Overrides_Config() { var configurer = new SqlServerProviderConfigurer(); // override provided by environment var si = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://servername/databaseName=de5aa3a747c134b3d8780f8cc80be519e;instanceName=someInstance;integratedSecurity=true"); // apply override var opts = configurer.Configure(si, config); // resulting options should contain values parsed from environment Assert.Contains("Data Source=servername\\someInstance", opts); Assert.Contains("Initial Catalog=de5aa3a747c134b3d8780f8cc80be519e;", opts); Assert.Contains("integratedSecurity=true;", opts); }
public void Configure_With_ServiceInfo_CredsInUrl_Overrides_Config() { var configurer = new SqlServerProviderConfigurer(); // override provided by environment var si = new SqlServerServiceInfo("MyId", "jdbc:sqlserver://*****:*****@servername:1433/databaseName=de5aa3a747c134b3d8780f8cc80be519e"); // apply override var opts = configurer.Configure(si, config); // resulting options should contain values parsed from environment Assert.Contains("Data Source=servername,1433", opts); Assert.Contains("Initial Catalog=de5aa3a747c134b3d8780f8cc80be519e;", opts); Assert.Contains("User Id=Dd6O1BPXUHdrmzbP;", opts); Assert.Contains("Password=7E1LxXnlH2hhlPVt;", opts); }