public static void BcpDataFile()
{
string connectionstring = @"Data Source=(localdb)\v11.0;Initial Catalog=TestDb;Integrated Security=True";
//using (var db = new NerdDinners(connectionstring))
//{
// //db.Database.CreateIfNotExists();
// db.Database.ExecuteSqlCommand("TRUNCATE TABLE Series");
//}
DateTime st = DateTime.Now;
Console.WriteLine("Starting..." + st);
Assert.Fail(@"Testfile C:\Personal\LabCorpTest\bin\Debug\20170202_CUST_CIF.IN not available. Include in project.");
using (var dr = new ChoCSVReader(@"C:\Personal\LabCorpTest\bin\Debug\20170202_CUST_CIF.IN").NotifyAfter(10000))
{
dr.RowsLoaded += delegate(object sender, ChoRowsLoadedEventArgs e)
{
Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
};
dr.Loop();
//foreach (var item in dr.Take(100))
//{
// Console.WriteLine(item.ToStringEx());
//}
}
//using (SqlBulkCopy bcp = new SqlBulkCopy(connectionstring))
//{
// using (var r = new ChoCSVReader<Series>(@"C:\Users\raj\Desktop\Building consents by territorial authority and selected wards (Monthly).csv").WithFirstLineHeader().NotifyAfter(10000))
// {
// r.RowsLoaded += delegate (object sender, ChoRowsLoadedEventArgs e)
// {
// Console.WriteLine(e.RowsLoaded.ToString("#,##0") + " rows loaded.");
// };
// using (var dr = r.AsDataReader())
// {
// bcp.DestinationTableName = "dbo.Series";
// bcp.EnableStreaming = true;
// bcp.BatchSize = 10000;
// bcp.BulkCopyTimeout = 0;
// //bcp.NotifyAfter = 10000;
// //bcp.SqlRowsCopied += delegate (object sender, SqlRowsCopiedEventArgs e)
// //{
// // Console.WriteLine(e.RowsCopied.ToString("#,##0") + " rows copied.");
// //};
// bcp.WriteToServer(dr);
// }
// }
//}
Console.WriteLine("Completed." + (DateTime.Now - st));
Assert.Fail("Provide correct test. Avoid Console.ReadLine() to prevent hanging.");
Console.ReadLine();
}