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