private void GetIds()
{
using (var TraceListener = new TraceEventListener())
{
using (SqlConnection connection = new SqlConnection(DataTestUtility.TCPConnectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT * From [Customers]", connection))
{
command.ExecuteNonQuery();
}
ids = TraceListener.IDs;
}
ids = TraceListener.IDs;
}
}
static DataTestUtility()
{
using (StreamReader r = new StreamReader("config.json"))
{
string json = r.ReadToEnd();
Config c = JsonConvert.DeserializeObject <Config>(json);
NPConnectionString = c.NPConnectionString;
TCPConnectionString = c.TCPConnectionString;
TCPConnectionStringHGSVBS = c.TCPConnectionStringHGSVBS;
TCPConnectionStringAASVBS = c.TCPConnectionStringAASVBS;
TCPConnectionStringAASSGX = c.TCPConnectionStringAASSGX;
AADAuthorityURL = c.AADAuthorityURL;
AADPasswordConnectionString = c.AADPasswordConnectionString;
SupportsLocalDb = c.SupportsLocalDb;
SupportsIntegratedSecurity = c.SupportsIntegratedSecurity;
SupportsFileStream = c.SupportsFileStream;
EnclaveEnabled = c.EnclaveEnabled;
TracingEnabled = c.TracingEnabled;
UseManagedSNIOnWindows = c.UseManagedSNIOnWindows;
if (TracingEnabled)
{
TraceListener = new DataTestUtility.TraceEventListener();
}
if (UseManagedSNIOnWindows)
{
AppContext.SetSwitch(ManagedNetworkingAppContextSwitch, true);
Console.WriteLine($"App Context switch {ManagedNetworkingAppContextSwitch} enabled on {Environment.OSVersion}");
}
if (IsAADPasswordConnStrSetup() && IsAADAuthorityURLSetup())
{
string username = RetrieveValueFromConnStr(AADPasswordConnectionString, new string[] { "User ID", "UID" });
string password = RetrieveValueFromConnStr(AADPasswordConnectionString, new string[] { "Password", "PWD" });
AADAccessToken = GenerateAccessToken(AADAuthorityURL, username, password);
}
string url = c.AzureKeyVaultURL;
Uri AKVBaseUri = null;
if (!string.IsNullOrEmpty(url) && Uri.TryCreate(url, UriKind.Absolute, out AKVBaseUri))
{
AKVBaseUri = new Uri(AKVBaseUri, "/");
AKVBaseUrl = AKVBaseUri.AbsoluteUri;
AKVUrl = (new Uri(AKVBaseUri, $"/keys/{AKVKeyName}")).AbsoluteUri;
}
AKVClientId = c.AzureKeyVaultClientId;
AKVClientSecret = c.AzureKeyVaultClientSecret;
}
if (EnclaveEnabled)
{
if (!string.IsNullOrEmpty(TCPConnectionStringHGSVBS))
{
AEConnStrings.Add(TCPConnectionStringHGSVBS);
AEConnStringsSetup.Add(TCPConnectionStringHGSVBS);
}
if (!string.IsNullOrEmpty(TCPConnectionStringAASVBS))
{
AEConnStrings.Add(TCPConnectionStringAASVBS);
}
if (!string.IsNullOrEmpty(TCPConnectionStringAASSGX))
{
AEConnStrings.Add(TCPConnectionStringAASSGX);
AEConnStringsSetup.Add(TCPConnectionStringAASSGX);
}
System.Net.ServicePointManager.SecurityProtocol |= System.Net.SecurityProtocolType.Tls12;
}
else
{
if (!string.IsNullOrEmpty(TCPConnectionString))
{
AEConnStrings.Add(TCPConnectionString);
AEConnStringsSetup.Add(TCPConnectionString);
}
}
}
static DataTestUtility()
{
Config c = Config.Load();
NPConnectionString = c.NPConnectionString;
TCPConnectionString = c.TCPConnectionString;
TCPConnectionStringHGSVBS = c.TCPConnectionStringHGSVBS;
TCPConnectionStringAASVBS = c.TCPConnectionStringAASVBS;
TCPConnectionStringAASSGX = c.TCPConnectionStringAASSGX;
AADAuthorityURL = c.AADAuthorityURL;
AADPasswordConnectionString = c.AADPasswordConnectionString;
AADServicePrincipalId = c.AADServicePrincipalId;
AADServicePrincipalSecret = c.AADServicePrincipalSecret;
SupportsLocalDb = c.SupportsLocalDb;
SupportsIntegratedSecurity = c.SupportsIntegratedSecurity;
SupportsFileStream = c.SupportsFileStream;
EnclaveEnabled = c.EnclaveEnabled;
TracingEnabled = c.TracingEnabled;
UseManagedSNIOnWindows = c.UseManagedSNIOnWindows;
DNSCachingConnString = c.DNSCachingConnString;
DNSCachingServerCR = c.DNSCachingServerCR;
DNSCachingServerTR = c.DNSCachingServerTR;
IsAzureSynapse = c.IsAzureSynapse;
IsDNSCachingSupportedCR = c.IsDNSCachingSupportedCR;
IsDNSCachingSupportedTR = c.IsDNSCachingSupportedTR;
EnclaveAzureDatabaseConnString = c.EnclaveAzureDatabaseConnString;
UserManagedIdentityObjectId = c.UserManagedIdentityObjectId;
System.Net.ServicePointManager.SecurityProtocol |= System.Net.SecurityProtocolType.Tls12;
if (TracingEnabled)
{
TraceListener = new TraceEventListener();
}
if (UseManagedSNIOnWindows)
{
AppContext.SetSwitch(ManagedNetworkingAppContextSwitch, true);
Console.WriteLine($"App Context switch {ManagedNetworkingAppContextSwitch} enabled on {Environment.OSVersion}");
}
string url = c.AzureKeyVaultURL;
if (!string.IsNullOrEmpty(url) && Uri.TryCreate(url, UriKind.Absolute, out Uri AKVBaseUri))
{
AKVBaseUri = new Uri(AKVBaseUri, "/");
AKVBaseUrl = AKVBaseUri.AbsoluteUri;
AKVUrl = (new Uri(AKVBaseUri, $"/keys/{AKVKeyName}")).AbsoluteUri;
}
AKVClientId = c.AzureKeyVaultClientId;
AKVClientSecret = c.AzureKeyVaultClientSecret;
if (EnclaveEnabled)
{
if (!string.IsNullOrEmpty(TCPConnectionStringHGSVBS))
{
AEConnStrings.Add(TCPConnectionStringHGSVBS);
AEConnStringsSetup.Add(TCPConnectionStringHGSVBS);
}
if (!string.IsNullOrEmpty(TCPConnectionStringAASVBS))
{
AEConnStrings.Add(TCPConnectionStringAASVBS);
}
if (!string.IsNullOrEmpty(TCPConnectionStringAASSGX))
{
AEConnStrings.Add(TCPConnectionStringAASSGX);
AEConnStringsSetup.Add(TCPConnectionStringAASSGX);
}
}
else
{
if (!string.IsNullOrEmpty(TCPConnectionString))
{
AEConnStrings.Add(TCPConnectionString);
AEConnStringsSetup.Add(TCPConnectionString);
}
}
}