public void TestLoadingFormatThenFile() { FixedWidthFormatFile formatFile = CreateFormatFile(); string tempFileToCreate = Path.Combine(TestContext.CurrentContext.TestDirectory, "unitTestFixedWidthFile.txt"); StreamWriter streamWriter = File.CreateText(tempFileToCreate); try { streamWriter.WriteLine("002644099999Akerman Frank FM 380512004040120090501"); streamWriter.WriteLine("002705600000SHAW LENA LC 852251978100119941031"); streamWriter.Flush(); streamWriter.Close(); DataTable dataTable = formatFile.GetDataTableFromFlatFile(new FileInfo(tempFileToCreate)); Assert.AreEqual(dataTable.Rows.Count, 2); Assert.AreEqual("0026440", dataTable.Rows[0]["gmc"]); Assert.AreEqual("99999", dataTable.Rows[0]["gp_code"]); Assert.AreEqual("Akerman", dataTable.Rows[0]["surname"]); Assert.AreEqual("Frank", dataTable.Rows[0]["forename"]); Assert.AreEqual("FM", dataTable.Rows[0]["initials"]); Assert.AreEqual("38051", dataTable.Rows[0]["practice_code"]); Assert.AreEqual(new DateTime(2004, 4, 1), dataTable.Rows[0]["date_into_practice"]); Assert.AreEqual(new DateTime(2009, 5, 1), dataTable.Rows[0]["date_out_of_practice"]); } finally { File.Delete(tempFileToCreate); } }