public void RunFlatFiles_FlatFileDataReader_ByName()
{
var reader = new StringReader(data);
var schema = GetSchema();
var csvReader = new SeparatedValueReader(reader, schema, new SeparatedValueOptions()
{
IsFirstRecordSchema = true
});
var dataReader = new FlatFileDataReader(csvReader);
var people = new List <Person>();
while (dataReader.Read())
{
var person = new Person()
{
FirstName = dataReader.GetString("FirstName"),
LastName = dataReader.GetString("LastName"),
Age = dataReader.GetInt32("Age"),
Street1 = dataReader.GetString("Street1"),
Street2 = dataReader.GetString("Street2"),
City = dataReader.GetString("City"),
State = dataReader.GetString("State"),
Zip = dataReader.GetString("Zip"),
FavoriteColor = dataReader.GetString("FavoriteColor"),
FavoriteFood = dataReader.GetString("FavoriteFood"),
FavoriteSport = dataReader.GetString("FavoriteSport"),
CreatedOn = dataReader.GetDateTime("CreatedOn"),
IsActive = dataReader.GetBoolean("IsActive")
};
people.Add(person);
}
}
public void RunFlatFiles_FlatFileDataReader_ByPosition()
{
var reader = new StringReader(data);
var schema = GetSchema();
var csvReader = new SeparatedValueReader(reader, schema, new SeparatedValueOptions()
{
IsFirstRecordSchema = true
});
var dataReader = new FlatFileDataReader(csvReader);
var people = new List <Person>();
while (dataReader.Read())
{
var person = new Person()
{
FirstName = dataReader.GetString(0),
LastName = dataReader.GetString(1),
Age = dataReader.GetInt32(2),
Street1 = dataReader.GetString(3),
Street2 = dataReader.GetString(4),
City = dataReader.GetString(5),
State = dataReader.GetString(6),
Zip = dataReader.GetString(7),
FavoriteColor = dataReader.GetString(8),
FavoriteFood = dataReader.GetString(9),
FavoriteSport = dataReader.GetString(10),
CreatedOn = dataReader.GetDateTime(11),
IsActive = dataReader.GetBoolean(12)
};
people.Add(person);
}
}
public void ShouldGetRecordsFromReader()
{
FlatFileDataReader dataReader = GetFlatFileReader();
Assert.IsTrue(dataReader.Read(), "The first record could not be read.");
Assert.AreEqual(1, dataReader.GetInt32("Id"), "The wrong 'Id' was retrieved for 'Bob'.");
Assert.AreEqual("Bob", dataReader.GetString("Name"), "The wrong 'Name' was retrieved for 'Bob'.");
Assert.AreEqual(new DateTime(2018, 07, 03), dataReader.GetDateTime("CreatedOn"), "The wrong 'CreatedOn' was retrieved for 'Bob'.");
Assert.IsTrue(dataReader.GetBoolean("IsActive"), "The wrong 'IsActive' was retrieved for 'Bob'");
Assert.AreEqual(10, dataReader.GetNullableInt32("VisitCount"), "The wrong 'VisitCount' was retrieved for 'Bob'.");
Assert.IsTrue(dataReader.Read(), "The second record could not be read.");
Assert.AreEqual(2, dataReader.GetInt32("Id"), "The wrong 'Id' was retrieved for 'Susan'.");
Assert.AreEqual("Susan", dataReader.GetString("Name"), "The wrong 'Name' was retrieved for 'Susan'.");
Assert.AreEqual(new DateTime(2018, 07, 04), dataReader.GetDateTime("CreatedOn"), "The wrong 'CreatedOn' was retrieved for 'Susan'.");
Assert.IsFalse(dataReader.GetBoolean("IsActive"), "The wrong 'IsActive' was retrieved for 'Susan'");
Assert.AreEqual(null, dataReader.GetNullableInt32("VisitCount"), "The wrong 'VisitCount' was retrieved for 'Susan'.");
Assert.IsFalse(dataReader.Read(), "Too many records were read.");
}