public static void Main(string[] args)
{
//File.OpenRead()
var fullPath = ChoPath.GetFullPath("Emp.csv");
using (var choCsvReader = new ChoCSVReader <EmployeeRec>("D:\\sourcecontrol\\repos\\ChoETLTests\\ConsoleApp1\\Emp.csv").WithFirstLineHeader()) {
foreach (var employeeRec in choCsvReader.AsEnumerable( ))
{
Console.WriteLine(employeeRec.DumpAsJson());
}
}
}
public static void POCOSortUsingSqlite()
{
using (var dr = new ChoCSVReader <Address>(@"Test.txt").WithDelimiter("\t").NotifyAfter(10000))
{
dr.RowsLoaded += delegate(object sender, ChoRowsLoadedEventArgs e)
{
Console.WriteLine();
Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
};
using (var dw = new ChoCSVWriter <Address>(Console.Out))
dw.Write(dr.AsEnumerable().StageOnSQLite().OrderByDescending(x => x.City));
}
}
public static void SortUsingSqlServer()
{
using (var dr = new ChoCSVReader(@"Test.txt").WithDelimiter("\t").NotifyAfter(10000))
{
dr.RowsLoaded += delegate(object sender, ChoRowsLoadedEventArgs e)
{
Console.WriteLine();
Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
};
using (var dw = new ChoCSVWriter(Console.Out))
dw.Write(dr.AsEnumerable().StageOnSqlServer("ORDER BY Column4"));
}
}
public static void POCOSortUsingSqlServerUsingBcp()
{
long?rowsLoaded = null;
using (var dr = new ChoCSVReader <Address>(FileNameTestTXT).WithDelimiter("\t").NotifyAfter(10000))
{
dr.RowsLoaded += delegate(object sender, ChoRowsLoadedEventArgs e)
{
rowsLoaded = e.RowsLoaded;
Console.WriteLine();
Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
};
using (var sw = new StreamWriter(FileNamePOCOSortUsingSqlServerUsingBcpTestTXT))
using (var dw = new ChoCSVWriter <Address>(sw))
dw.Write(dr.AsEnumerable().StageOnSqlServerUsingBcp().OrderByDescending(x => x.City).OrderBy(x => x.Id1));
}
Assert.Multiple(() => { Assert.AreEqual(rowsLoaded, 101, "Rows loaded"); FileAssert.AreEqual(FileNamePOCOSortUsingSqlServerUsingBcpExpectedTXT, FileNamePOCOSortUsingSqlServerUsingBcpTestTXT); });
}
public static void SortUsingSqlServer()
{
long?rowsLoaded = null;
using (var dr = new ChoCSVReader(FileNameTestTXT).WithDelimiter("\t").NotifyAfter(10000))
{
dr.RowsLoaded += delegate(object sender, ChoRowsLoadedEventArgs e)
{
rowsLoaded = e.RowsLoaded;
Console.WriteLine();
Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
};
using (var sw = new StreamWriter(FileNameSortUsingSqlServerTestTXT))
using (var dw = new ChoCSVWriter(sw))
dw.Write(dr.AsEnumerable().StageOnSqlServer("ORDER BY Column4"));
}
Assert.Multiple(() => { Assert.AreEqual(rowsLoaded, 101, "Rows loaded"); FileAssert.AreEqual(FileNameSortUsingSqlServerExpectedTXT, FileNameSortUsingSqlServerTestTXT); });
}