private static void Main(string[] args) { using (var pipe = new DataCommandPipeline <DataTable>()) { var csvReader = new CsvReaderCommand(); csvReader.Adapter.FileName = @"C:\Develop\c#\mixed\SimpleETL\SimpleETL.Test\TestData\Master Works of Art.csv"; csvReader.Adapter.Separator = ","; csvReader.Adapter.Enclosure = "\""; csvReader.Adapter.TableName = "MasterWorksofArt"; csvReader.Adapter.FieldDefinitions.Add(new FieldDefinition("Artist", "Artist", typeof(string))); csvReader.Adapter.FieldDefinitions.Add(new FieldDefinition("Title", "Title", typeof(string))); csvReader.Adapter.FieldDefinitions.Add(new FieldDefinition("Year (Approximate)", "Year_Approximate", typeof(float), new StringToNumberAutoConverter())); csvReader.Adapter.FieldDefinitions.Add(new FieldDefinition("Movement", "Movement", typeof(string))); csvReader.Adapter.FieldDefinitions.Add(new FieldDefinition("Total Height (cm)", "Total_Height_cm", typeof(float), new StringToNumberAutoConverter())); pipe.Commands.Add(csvReader); var dbWriter = new DbWriterCommand(); var connInfo = new SqLiteConnectionInfo(); connInfo.Database = @"C:\Develop\c#\mixed\SimpleETL\SimpleETL.Test\TestData\result.sqlite"; dbWriter.Adapter.ConnectionInfo = connInfo; pipe.Commands.Add(dbWriter); DataCommandPipeline <DataTable> .Save(@"C:\Temp\pipe.xml", pipe); pipe.Execute(); Console.WriteLine("Finished"); Console.ReadLine(); } }
public static void Save(string fileName, DataCommandPipeline <TData> pipeline) { var serializer = new XmlSerializerHelper <DataCommandPipeline <TData> >(); serializer.Save(fileName, pipeline); }