public void ShouldSetColumnName() { // Arrange var dataTable = new DataTable(); dataTable.Columns.Add("foo", typeof(int)); dataTable.Columns.Add("bar", typeof(string)); var dataReader = DataReaderHelper.ToProtoDataReader(dataTable.CreateDataReader()); // Act var schemaTable = dataReader.GetSchemaTable(); // Assert Assert.Equal(dataTable.Columns[1].ColumnName, schemaTable.Rows[1]["ColumnName"]); }
public void ShouldReturnCorrespondingValues() { // Arrange var value = "foo"; var dataReader = DataReaderHelper.CreateDataReader(value: value); dataReader.Read(); var result = new object[1]; // Act dataReader.GetValues(result); // Assert Assert.Equal(new object[] { value }, result); }
public void ShouldChangeColumns() { // Act var dataSet = new DataSet(); dataSet.Tables.Add(new DataTable()); dataSet.Tables.Add(new DataTable()); dataSet.Tables[0].Columns.Add("foo", typeof(string)); dataSet.Tables[1].Columns.Add("bar", typeof(string)); var dataReader = DataReaderHelper.ToProtoDataReader(dataSet.CreateDataReader()); // Act dataReader.NextResult(); // Assert dataReader.Read(); Assert.Equal(dataSet.Tables[1].Columns[0].ColumnName, dataReader.GetName(0)); }
public void ShouldReturnCorrespondingValuesWithSmallerArray() { // Arrange var dataTable = new DataTable(); dataTable.Columns.Add("foo", typeof(int)); dataTable.Columns.Add("bar", typeof(int)); dataTable.Rows.Add(1, 2); var dataReader = DataReaderHelper.ToProtoDataReader(dataTable.CreateDataReader()); dataReader.Read(); var result = new object[1]; // Act dataReader.GetValues(result); // Assert Assert.Equal(new[] { dataTable.Rows[0][0] }, result); }
public void ShouldReadRemainingRecords() { // Act var dataSet = new DataSet(); dataSet.Tables.Add(new DataTable()); dataSet.Tables.Add(new DataTable()); dataSet.Tables[0].Columns.Add("foo", typeof(string)); dataSet.Tables[1].Columns.Add("bar", typeof(string)); dataSet.Tables[0].Rows.Add("baz"); dataSet.Tables[1].Rows.Add("qux"); var dataReader = DataReaderHelper.ToProtoDataReader(dataSet.CreateDataReader()); // Act dataReader.NextResult(); // Assert dataReader.Read(); Assert.Equal(dataSet.Tables[1].Rows[0][0], dataReader.GetValue(0)); }