public void TwoDataRowsTest()
        {
            var tempFile = Path.GetTempFileName();

            using (var writer = new StreamWriter(File.OpenWrite(tempFile)))
            {
                writer.WriteLine("col1,col2,col3");
                writer.WriteLine("row1-val1,row1-val2,row1-val3");
                writer.WriteLine("row2-val1,row2-val2,row2-val3");
                writer.Close();
            }
            using (var reader = new DelimitedFileReader(tempFile, ','))
            {
                var values = reader.ReadValues();
                Assert.IsNotNull(values);
                Assert.AreEqual(3, values.Count);
                Assert.AreEqual("row1-val1", values["col1"]);
                Assert.AreEqual("row1-val2", values["col2"]);
                Assert.AreEqual("row1-val3", values["col3"]);
                //
                values = reader.ReadValues();
                Assert.IsNotNull(values);
                Assert.AreEqual(3, values.Count);
                Assert.AreEqual("row2-val1", values["col1"]);
                Assert.AreEqual("row2-val2", values["col2"]);
                Assert.AreEqual("row2-val3", values["col3"]);
                //
                values = reader.ReadValues();
                Assert.IsNull(values);
            }
            File.Delete(tempFile);
        }
        public void DataRowWithExtraColumnsTest()
        {
            var tempFile = Path.GetTempFileName();

            using (var writer = new StreamWriter(File.OpenWrite(tempFile)))
            {
                writer.WriteLine("col1,col2");
                writer.WriteLine("val1,val2,val3");
                writer.Close();
            }
            using (var reader = new DelimitedFileReader(tempFile, ','))
            {
                var values = reader.ReadValues();
                Assert.IsNotNull(values);
                Assert.AreEqual(2, values.Count);
                Assert.AreEqual("val1", values["col1"]);
                Assert.AreEqual("val2", values["col2"]);
                Assert.IsFalse(values.ContainsKey("col3"));
            }
            File.Delete(tempFile);
        }