public void TestFirstColumnIsId()
{
//Read a test excel file as a byte array
FileStream fileStream = new FileStream(testFilePath, FileMode.Open, FileAccess.Read);
ExcelFile file = new ExcelFile(fileStream, dynamicProvider);
//verify the types were created successfully.
Assert.AreEqual("100024", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(0).Id );
Assert.AreEqual("101707", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(1).Id);
Assert.AreEqual("101708", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(2).Id);
Assert.AreEqual("101713", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(3).Id);
}
public void TestInstanceDataCreation()
{
//Read a test excel file as a byte array
FileStream fileStream = new FileStream(testFilePath, FileMode.Open, FileAccess.Read);
ExcelFile file = new ExcelFile(fileStream, dynamicProvider);
//verify the first instance was created
//need to use the translated property name
Assert.AreEqual("KELLER", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(0)["_LastName"]);
Assert.AreEqual("RHONDA", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(0)["_FirstName"]);
Assert.AreEqual("513826", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(0)["_Customer__"]);
Assert.AreEqual("100024", file.GetInstances(ModelContext.Current.GetModelType("Data")).ElementAt(0)["_Location__"]);
}