public async Task GetVersions_EntityFrameworkConnectionString()
{
string connectionString = $"metadata = res://*/ProfilePreferences.csdl|res://*/ProfilePreferences.ssdl|res://*/ProfilePreferences.msl;provider=System.Data.SqlClient;provider connection string=\"Data Source={ Constants.LatestSqlServerHostname },1433;initial catalog=SomeDb;user id=user;password=pass;MultipleActiveResultSets=True;App=EntityFramework\"";
IVersionResolver resolver = new SqlServerVersionResolver(new StaticConnectionStringProvider(connectionString), 10000, 10000);
var versions = await resolver.GetVersions().ConfigureAwait(false);
Assert.Equal(1, versions.Count());
}
public async Task GetVersions_ConnectionStringNotFound()
{
IVersionResolver resolver = new SqlServerVersionResolver(new DummyNotFoundConnectionStringProvider(), 10000, 10000);
await Assert.ThrowsAsync <ConnectionStringNotFoundException>(async() =>
{
var value = await resolver.GetVersions().ConfigureAwait(false);
});
}
public async Task GetVersions_SpecificPort()
{
string connectionString = $"Data Source={ Constants.LatestSqlServerHostname },1433;Initial Catalog=DBTests;Integrated Security=True;";
IVersionResolver resolver = new SqlServerVersionResolver(new StaticConnectionStringProvider(connectionString), 10000, 10000);
var versions = await resolver.GetVersions().ConfigureAwait(false);
Assert.Equal(1, versions.Count());
Assert.True(versions.First() >= DependencyVersion.Parse("12.0.0"), "The version should be greater than 12.0.0");
}
public async Task GetVersions_WrongPort()
{
string connectionString = "metadata = res://*/ProfilePreferences.csdl|res://*/ProfilePreferences.ssdl|res://*/ProfilePreferences.msl;provider=System.Data.SqlClient;provider connection string=\"Data Source=10.149.194.64,65535;initial catalog=NosProfilePreferencesManagerV2_TST;user id=userProfileSettingsDB;password=userProfileSettings;MultipleActiveResultSets=True;App=EntityFramework\"";
IVersionResolver resolver = new SqlServerVersionResolver(new StaticConnectionStringProvider(connectionString), 10000, 10000);
await Assert.ThrowsAsync <DependencyNotReachableException>(async() =>
{
var value = await resolver.GetVersions().ConfigureAwait(false);
});
}
