public static string GetTableSql(IEnumerable <string> filePaths, string tableName, char csvDelimiter = ',', int headerOffsetRows = 1) { var readers = new List <IDataReader>(); var readerFacs = new List <Func <DataReaderInfo> >(); foreach (var filePath in filePaths) { var readerFac = new Func <DataReaderInfo>(() => { var r = new DataReaderInfo { DataReader = DataReaderFactories.Default(filePath, true, csvDelimiter), FilePath = filePath }; readers.Add(r.DataReader); return(r); }); readerFacs.Add(readerFac); } var rr = CreateTableSql.FromDataReader_Smart(tableName, readerFacs); foreach (var dataReader in readers) { dataReader.Dispose(); } return(rr); }
public static string GetTableSql(string filePath, string destinationTableName) { var readerFacs = new List <Func <DataReaderInfo> >(); var readerFac = new Func <DataReaderInfo>( () => new DataReaderInfo { DataReader = DataReaderFactories.Default(filePath), FilePath = filePath }); readerFacs.Add(readerFac); var outputText = CreateTableSql.FromDataReader_Smart(destinationTableName, readerFacs); return(outputText); }