public void GetVersions_gets_all_versions_from_specified_database_table() { // Arrange string[] expectedVersions = new[] { "1.0", "1.5", "2.0" }; try { DbVersionProviderTestUtils.CreateAndFillTable(_TableName, _ColumnName, expectedVersions); var dbVersionProvider = new DbVersionProvider( new List<DbVersionTableInfo> { new DbVersionTableInfo { TableName = _TableName, ColumnName = _ColumnName } }); // Act List<string> currentVersions = dbVersionProvider.GetVersions(_DbName, _SqlServerName).ToList(); // Assert Assert.AreEqual(expectedVersions.Length, currentVersions.Count()); foreach (var expectedVersion in expectedVersions) { Assert.IsTrue(currentVersions.Contains(expectedVersion)); } } finally { DbVersionProviderTestUtils.DropTableIfExists(_TableName); } }
public void SetUp() { _dbVersionProvider = new DbVersionProvider(_versionTableInfos); }
public void GetVersions_returns_empty_list_when_specified_version_table_was_not_found() { try { // Arrange DbVersionProviderTestUtils.CreateAndFillTable(_TableName, _ColumnName, new[] { "1.2" }); var dbVersionProvider = new DbVersionProvider( new List<DbVersionTableInfo> { new DbVersionTableInfo { TableName = "OtherTableName", ColumnName = "OtherColumnName" } }); // Act var versions = dbVersionProvider.GetVersions(_DbName, _SqlServerName); // Assert Assert.IsFalse(versions.Any()); } finally { DbVersionProviderTestUtils.DropTableIfExists(_TableName); } }