public void Test_Csv_Access_Csv() { DirectoryUtil.ClearDirectory(this.resultPath); using (var csvReader = new CsvAdapter()) using (var accessWriter = new AccessAdapter()) using (var accessReader = new AccessAdapter()) using (var csvWriter = new CsvAdapter()) { csvReader.Enclosure = ""; csvReader.FileName = this.testDataPath + @"StringData.csv"; csvReader.AutoDetectEncoding(); var csvData = csvReader.ReadAllData(); accessWriter.FileName = Path.Combine(this.resultPath, "cd-Daten.mdb"); accessWriter.TableName = "Tabelle1"; accessWriter.CreateNewFile(); accessWriter.Connect(); accessWriter.WriteAllData(csvData); accessWriter.Disconnect(); accessReader.FileName = accessWriter.FileName; accessReader.TableName = accessWriter.TableName; accessReader.Connect(); var accessData = accessReader.ReadAllData(); accessReader.Disconnect(); csvWriter.Encoding = csvReader.Encoding; csvWriter.Enclosure = csvReader.Enclosure; csvWriter.FileName = this.resultPath + @"cd-Daten_AccessRoundtrip.csv"; csvWriter.WriteAllData(accessData); if (!FileUtil.CompareFiles(csvReader.FileName, csvWriter.FileName)) { throw new Exception("Original and copied file do not match"); } } }
public void TestInitialize() { DirectoryUtil.CreateDirectoryIfNotExists(this.resultPath); DirectoryUtil.ClearDirectory(this.resultPath); }