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);
}
