public void StubDataReader_IndexAccessors_Read_Success() { using (var reader = new StubDataReader(new StubResultSet("abc", "def").AddRow(3, "nice"))) { Assert.IsTrue(reader.Read(), "First call to Read() should have had data"); Assert.AreEqual(3, reader[0], "The first column (by index) was not correct"); Assert.AreEqual("nice", reader["def"], "The second column (by name) was not correct"); Assert.IsFalse(reader.Read(), "Second call to Read() should not have had data"); } }
public void NullUtils_GetBoolean_NotNull_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(true)); reader.Read(); Assert.IsTrue(NullUtils.GetBoolean(reader, "unit_test"), "GetBoolean(true) should have returned true"); }
public void NullUtils_GetDateTimeOrNull_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.IsNull(NullUtils.GetDateTimeOrNull(reader, "unit_test"), "GetDateTime(null) should have returned null"); }
public void NullUtils_GetDateTime_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(new DateTime(2004, 12, 13))); reader.Read(); Assert.AreEqual(new DateTime(2004, 12, 13), NullUtils.GetDateTime(reader, "unit_test"), "GetDateTime(value) should have returned a value"); }
public void NullUtils_GetDateTime_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(default(DateTime), NullUtils.GetDateTime(reader, "unit_test"), "GetDateTime(null) should not have returned a default DateTime"); }
public void NullUtils_GetStringOrNull_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow("123")); reader.Read(); Assert.AreEqual("123", NullUtils.GetStringOrNull(reader, "unit_test"), "GetStringOrNull(value) did not return the expected value"); }
public void NullUtils_GetString_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(String.Empty, NullUtils.GetString(reader, "unit_test"), "GetString(null) should have returned an empty string"); }
public void NullUtils_GetInt64_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(5L)); reader.Read(); Assert.AreEqual(5L, NullUtils.GetInt64(reader, "unit_test"), "GetInt64(value) did not return the expected value"); }
public void NullUtils_GetInt64_Null_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(DBNull.Value)); reader.Read(); Assert.AreEqual(default(long), NullUtils.GetInt64(reader, "unit_test"), "GetInt64(null) should have returned the default long value"); }
public void NullUtils_GetInt16OrNull_Value_Success() { var reader = new StubDataReader(new StubResultSet("unit_test").AddRow((short)17)); reader.Read(); Assert.AreEqual((short)17, NullUtils.GetInt16OrNull(reader, "unit_test").Value, "GetInt16OrNull(value) did not return the expected value"); }
public void StubDataReader_GetFieldType_Success() { using (var reader = new StubDataReader(new StubResultSet("more", "fun").AddRow(8, "yowza"))) { reader.Read(); Assert.AreEqual(typeof(int), reader.GetFieldType(0)); Assert.AreEqual(typeof(string), reader.GetFieldType(1)); } }
public void NullUtils_GetGuidOrNull_Value_Success() { var guid = Guid.NewGuid(); var reader = new StubDataReader(new StubResultSet("unit_test").AddRow(guid)); reader.Read(); Assert.AreEqual(guid, NullUtils.GetGuidOrNull(reader, "unit_test").Value, "GetGuidOrNull(value) did not return the expected value"); }
public void StubDataReader_IndexAccessors_EOF_Failure() { using (var reader = new StubDataReader(new StubResultSet())) { Assert.IsFalse(reader.Read(), "Read() should not have had data"); try { var column = reader[0]; Assert.Fail("Index accessor should have thrown an exception (EOF)"); } catch (InvalidOperationException) { } } }
public void IsDBNull_NotNull_Test() { StubResultSetCollection stubResultSets = new StubResultSetCollection(); stubResultSets.Add(CreateIsDBNullResultSet()); StubDataReader target = new StubDataReader(stubResultSets); target.Read(); int i = 2; bool expected = false; bool actual; actual = target.IsDBNull(i); Assert.AreEqual(expected, actual); }