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));
}