private static void CheckHaveParsedTypicalConnectionString(string providerName)
{
const string connectionString = "Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=MyPassword";
const string connectionStringName = "MyConnectionString";
var result = ConfigurationConnectionStringModelFactory.Create(new ConnectionStringSettings(connectionStringName, connectionString, providerName));
Assert.Equal(providerName, result.ProviderName);
Assert.Equal(connectionStringName, result.Key);
Assert.Equal("Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=########", result.Raw);
Assert.True(result.Details.Count > 4);
Assert.Equal("MyServer", result.Details["Data Source"]);
Assert.Equal("MyDatabase", result.Details["Initial Catalog"]);
Assert.Equal("MyUsername", result.Details["User Id"]);
Assert.Equal("########", result.Details["Password"]);
}
public void HaveParsedNonTypicalConnectionString()
{
const string connectionString = "DefaultEndpointsProtocol=https;AccountName=SomeAccount;AccountKey=SomeAccountKey";
const string connectionStringName = "MyConnectionString";
const string providerName = null;
var result = ConfigurationConnectionStringModelFactory.Create(new ConnectionStringSettings(connectionStringName, connectionString, providerName));
Assert.Equal(providerName, result.ProviderName);
Assert.Equal(connectionStringName, result.Key);
Assert.Equal("DefaultEndpointsProtocol=https;AccountName=SomeAccount;AccountKey=########", result.Raw);
Assert.Equal(5, result.Details.Count);
Assert.Equal("ProviderName is empty, therefore assuming ProviderName=System.Data.SqlClient", result.Details["WARNING"]);
Assert.True(result.Details["ERROR"].ToString().StartsWith("Connection string is invalid for ProviderName=System.Data.SqlClient : "));
Assert.Equal("https", result.Details["DefaultEndpointsProtocol"]);
Assert.Equal("SomeAccount", result.Details["AccountName"]);
Assert.Equal("########", result.Details["AccountKey"]);
}
public void HaveHandledUnknownProvider()
{
const string connectionString = "Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=MyPassword";
const string connectionStringName = "MyConnectionString";
const string providerName = "This.Is.Unknown";
var result = ConfigurationConnectionStringModelFactory.Create(new ConnectionStringSettings(connectionStringName, connectionString, providerName));
Assert.Equal(providerName, result.ProviderName);
Assert.Equal(connectionStringName, result.Key);
Assert.Equal("Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=########", result.Raw);
Assert.Equal(5, result.Details.Count);
Assert.True(!string.IsNullOrEmpty(result.Details["FATAL"] as string));
Assert.Equal("MyServer", result.Details["Data Source"]);
Assert.Equal("MyDatabase", result.Details["Initial Catalog"]);
Assert.Equal("MyUsername", result.Details["User Id"]);
Assert.Equal("########", result.Details["Password"]);
}
public void HaveHandledInvalidConnectionStringForKnownProvider()
{
const string connectionString = "Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=MyPassword;SomeUnknownKey=BadValue";
const string connectionStringName = "MyConnectionString";
const string providerName = "System.Data.SqlClient";
var result = ConfigurationConnectionStringModelFactory.Create(new ConnectionStringSettings(connectionStringName, connectionString, providerName));
Assert.Equal(providerName, result.ProviderName);
Assert.Equal(connectionStringName, result.Key);
Assert.Equal("Data Source=MyServer;Initial Catalog=MyDatabase;User Id=MyUsername;Password=########;SomeUnknownKey=BadValue", result.Raw);
Assert.Equal(6, result.Details.Count);
Assert.True(result.Details["ERROR"].ToString().StartsWith("Connection string is invalid for ProviderName=System.Data.SqlClient : "));
Assert.Equal("MyServer", result.Details["Data Source"]);
Assert.Equal("MyDatabase", result.Details["Initial Catalog"]);
Assert.Equal("MyUsername", result.Details["User Id"]);
Assert.Equal("########", result.Details["Password"]);
Assert.Equal("BadValue", result.Details["SomeUnknownKey"]);
}
