public void Import()
{
IDocumentFormatDefinition<State> definition = GetDefinition();
using (var reader = new StreamReader("Data\\states.csv", Encoding.GetEncoding(1252)))
{
List<State> allStates = definition.Import(reader, 1);
List<State> membersOfEu = allStates.Where(x => x.EU_MEMBER != null && x.EU_MEMBER.IsMember).OrderBy(x => x.EU_MEMBER.Year).ThenBy(x => x.NAME_ENG).ToList();
Console.WriteLine("Members of EU: " + membersOfEu.Count);
foreach (var euCountry in membersOfEu)
{
Console.WriteLine(euCountry.NAME_ENG + " (" + euCountry.EU_MEMBER.Year + ")");
}
Assert.AreEqual(27, membersOfEu.Count);
}
}