public void GetOrdinalWhenTheOrdinalCannotBeFound() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Columns.Add("Direction", typeof(string)); table.Columns.Add("Count", typeof(int)); table.Columns.Add("Sum", typeof(int)); IDataReader reader = new TableDataReader(table); Assert.AreEqual(0, reader.GetOrdinal("NotAColumn")); }
public void FieldCount() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Columns.Add("Direction", typeof(string)); table.Columns.Add("Count", typeof(int)); table.Columns.Add("Sum", typeof(int)); IDataReader reader = new TableDataReader(table); Assert.AreEqual(4, reader.FieldCount); }
public void GetOrdinal() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Columns.Add("Direction", typeof(string)); table.Columns.Add("Count", typeof(int)); table.Columns.Add("Sum", typeof(int)); IDataReader reader = new TableDataReader(table); Assert.AreEqual(0, reader.GetOrdinal("State")); Assert.AreEqual(1, reader.GetOrdinal("Direction")); Assert.AreEqual(2, reader.GetOrdinal("Count")); Assert.AreEqual(3, reader.GetOrdinal("Sum")); }
public void ClosingFunctionality() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Rows.Add(new object[]{"TX"}); table.Rows.Add(new object[]{"MO"}); table.Rows.Add(new object[]{"AR"}); TableDataReader reader = new TableDataReader(table); Assert.IsFalse(reader.IsClosed); reader.Close(); Assert.IsTrue(reader.IsClosed); reader = new TableDataReader(table); reader.Dispose(); Assert.IsTrue(reader.IsClosed); }
public void GetValue() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Columns.Add("Direction", typeof(string)); table.Columns.Add("Count", typeof(int)); table.Columns.Add("Sum", typeof(int)); table.Rows.Add(new object[]{"TX", "North", 1, 2}); IDataReader reader = new TableDataReader(table); reader.Read(); Assert.AreEqual("TX", (string)reader.GetValue(0)); Assert.AreEqual("North", (string)reader.GetValue(1)); Assert.AreEqual(1, (int)reader.GetValue(2)); Assert.AreEqual(2, (int)reader.GetValue(3)); }
public void ReadWithTwoRows() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Rows.Add(new object[]{"TX"}); table.Rows.Add(new object[]{"MO"}); TableDataReader reader = new TableDataReader(table); // One row, so it should return true the first time, and false the second Assert.IsTrue(reader.Read()); Assert.IsTrue(reader.Read()); Assert.IsFalse(reader.Read()); }
public void ReadWithNoRows() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); TableDataReader reader = new TableDataReader(table); // No rows, so it should return false Assert.IsFalse(reader.Read()); }
public void ReadingAClosedReaderThrowsAnException() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Rows.Add(new object[]{"TX"}); table.Rows.Add(new object[]{"MO"}); table.Rows.Add(new object[]{"AR"}); TableDataReader reader = new TableDataReader(table); Assert.IsFalse(reader.IsClosed); reader.Close(); Assert.IsTrue(reader.IsClosed); reader.Read(); }
public void IsDBNull() { DataTable table = new DataTable(); table.Columns.Add("State", typeof(string)); table.Columns.Add("Direction", typeof(string)); table.Columns.Add("Count", typeof(int)); table.Columns.Add("Sum", typeof(int)); table.Rows.Add(new object[]{DBNull.Value, "North", DBNull.Value, 2}); IDataReader reader = new TableDataReader(table); reader.Read(); Assert.IsTrue(reader.IsDBNull(0)); Assert.IsFalse(reader.IsDBNull(1)); Assert.IsTrue(reader.IsDBNull(2)); Assert.IsFalse(reader.IsDBNull(3)); }