public override void ExecuteCommand(CancellationToken token)
{
var file = DialogManager.ShowSelectFileDialog();
if (file == null)
{
return;
}
var ddlManager = new DDLManager();
var bulkdInsertManager = new BulkInsertManager();
String connString = ConnectionManager.GetConnectionStringForCurrentWindow();
Console.WriteLine("Start time" + DateTime.Now);
ExcelStreamReader.Execute(file.FullName, reader =>
reader.ForEachSheet(sheet =>
{
var schema = sheet.GetSchema();
ddlManager.CreateTable(schema.TableName, schema, connString);
bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString);
})
);
}
public void TestMethod1()
{
List <Author> AuthorList = new List <Author>();
AuthorList.Add(new Author("Mahesh Chand", 35, "A Prorammer's Guide to ADO.NET", true, new DateTime(2003, 7, 10)));
AuthorList.Add(new Author("Neel Beniwal", 18, "Graphics Development with C#", false, new DateTime(2010, 2, 22)));
AuthorList.Add(new Author("Praveen Kumar", 28, "Mastering WCF", true, new DateTime(2012, 01, 01)));
AuthorList.Add(new Author("Mahesh Chand", 35, "Graphics Programming with GDI+", true, new DateTime(2008, 01, 20)));
AuthorList.Add(new Author("Raj Kumar", 30, "Building Creative Systems", false, new DateTime(2011, 6, 3)));
BulkInsertManager.ConvertToDataTable(AuthorList);
}
public static void BulkInsertEntities(List<EF_CalendarDate> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("ExceptionDate");
insertManager.AddColumn("ExceptionType");
insertManager.AddColumn("CalendarId_Id");
foreach (EF_CalendarDate e in entities)
{
insertManager.AddRow(e.ExceptionDate, (int)e.ExceptionType, e.CalendarId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_CalendarDate> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("ExceptionDate");
insertManager.AddColumn("ExceptionType");
insertManager.AddColumn("CalendarId_Id");
foreach (EF_CalendarDate e in entities)
{
insertManager.AddRow(e.ExceptionDate, (int)e.ExceptionType, e.CalendarId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_Shape> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("ShapePointLatitude");
insertManager.AddColumn("ShapePointLongitude");
insertManager.AddColumn("ShapePointSequence");
insertManager.AddColumn("ShapeDistanceTravelled");
foreach (EF_Shape e in entities)
{
insertManager.AddRow(e.OriginalId, e.ShapePointLatitude, e.ShapePointLongitude, e.ShapePointSequence, e.ShapeDistanceTravelled);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_Agency> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("AgencyName");
insertManager.AddColumn("AgencyUrl");
insertManager.AddColumn("AgencyTimeZone");
insertManager.AddColumn("AgencyLanguage");
insertManager.AddColumn("AgencyPhoneNumber");
foreach (EF_Agency e in entities)
{
insertManager.AddRow(e.OriginalId, e.AgencyName, e.AgencyUrl, e.AgencyTimeZone, e.AgencyLanguage, e.AgencyPhoneNumber);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Shape> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("ShapePointLatitude");
insertManager.AddColumn("ShapePointLongitude");
insertManager.AddColumn("ShapePointSequence");
insertManager.AddColumn("ShapeDistanceTravelled");
foreach (EF_Shape e in entities)
{
insertManager.AddRow(e.OriginalId, e.ShapePointLatitude, e.ShapePointLongitude, e.ShapePointSequence, e.ShapeDistanceTravelled);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Stop> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("StopName");
insertManager.AddColumn("StopLatitude");
insertManager.AddColumn("StopLongitude");
insertManager.AddColumn("LocationType");
insertManager.AddColumn("WheelchairBoarding");
foreach (EF_Stop e in entities)
{
insertManager.AddRow(e.OriginalId, e.StopName, e.StopLatitude, e.StopLongitude, (int)e.LocationType, (int)e.WheelchairBoarding);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Agency> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("AgencyName");
insertManager.AddColumn("AgencyUrl");
insertManager.AddColumn("AgencyTimeZone");
insertManager.AddColumn("AgencyLanguage");
insertManager.AddColumn("AgencyPhoneNumber");
foreach (EF_Agency e in entities)
{
insertManager.AddRow(e.OriginalId, e.AgencyName, e.AgencyUrl, e.AgencyTimeZone, e.AgencyLanguage, e.AgencyPhoneNumber);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_StopTime> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("ArrivalTime");
insertManager.AddColumn("DepartureTime");
insertManager.AddColumn("StopSequence");
insertManager.AddColumn("ShapeDistanceTraveled");
insertManager.AddColumn("TripId_Id");
insertManager.AddColumn("StopId_Id");
foreach (EF_StopTime e in entities)
{
insertManager.AddRow(e.ArrivalTime, e.DepartureTime, e.StopSequence, e.ShapeDistanceTraveled, e.TripId.Id, e.StopId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Route> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("RouteShortName");
insertManager.AddColumn("RouteDescription");
insertManager.AddColumn("RouteType");
insertManager.AddColumn("RouteColor");
insertManager.AddColumn("RouteTextColor");
insertManager.AddColumn("AgencyId_Id");
foreach (EF_Route e in entities)
{
insertManager.AddRow(e.OriginalId, e.RouteShortName, e.RouteDescription, (int)e.RouteType, e.RouteColor, e.RouteTextColor, e.AgencyId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Trip> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("TripHeadsign");
insertManager.AddColumn("BlockId");
insertManager.AddColumn("DirectionId");
insertManager.AddColumn("WheelchairAccessible");
insertManager.AddColumn("RouteId_Id");
insertManager.AddColumn("ServiceId_Id");
insertManager.AddColumn("ShapeId_Id");
foreach (EF_Trip e in entities)
{
insertManager.AddRow(e.OriginalId, e.TripHeadsign, e.BlockId, (int)e.DirectionId, (int)e.WheelchairAccessible, e.RouteId.Id, e.ServiceId.Id, e.ShapeId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List <EF_Calendar> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("Monday");
insertManager.AddColumn("Tuesday");
insertManager.AddColumn("Wednesday");
insertManager.AddColumn("Thursday");
insertManager.AddColumn("Friday");
insertManager.AddColumn("Saturday");
insertManager.AddColumn("Sunday");
insertManager.AddColumn("StartDate");
insertManager.AddColumn("EndDate");
foreach (EF_Calendar e in entities)
{
insertManager.AddRow(e.OriginalId, e.Monday, e.Tuesday, e.Wednesday, e.Thursday, e.Friday, e.Saturday, e.Sunday, e.StartDate, e.EndDate);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_StopTime> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("ArrivalTime");
insertManager.AddColumn("DepartureTime");
insertManager.AddColumn("StopSequence");
insertManager.AddColumn("ShapeDistanceTraveled");
insertManager.AddColumn("TripId_Id");
insertManager.AddColumn("StopId_Id");
foreach (EF_StopTime e in entities)
{
insertManager.AddRow(e.ArrivalTime, e.DepartureTime, e.StopSequence, e.ShapeDistanceTraveled, e.TripId.Id, e.StopId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_Trip> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("TripHeadsign");
insertManager.AddColumn("BlockId");
insertManager.AddColumn("DirectionId");
insertManager.AddColumn("WheelchairAccessible");
insertManager.AddColumn("RouteId_Id");
insertManager.AddColumn("ServiceId_Id");
insertManager.AddColumn("ShapeId_Id");
foreach (EF_Trip e in entities)
{
insertManager.AddRow(e.OriginalId, e.TripHeadsign, e.BlockId, (int)e.DirectionId, (int)e.WheelchairAccessible, e.RouteId.Id, e.ServiceId.Id, e.ShapeId.Id);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_Stop> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("StopName");
insertManager.AddColumn("StopLatitude");
insertManager.AddColumn("StopLongitude");
insertManager.AddColumn("LocationType");
insertManager.AddColumn("WheelchairBoarding");
foreach (EF_Stop e in entities)
{
insertManager.AddRow(e.OriginalId, e.StopName, e.StopLatitude, e.StopLongitude, (int)e.LocationType, (int)e.WheelchairBoarding);
}
insertManager.DoBulkInsert();
}
public static void BulkInsertEntities(List<EF_Route> entities)
{
var insertManager = new BulkInsertManager(MethodBase.GetCurrentMethod().DeclaringType.Name);
insertManager.AddColumn("OriginalId");
insertManager.AddColumn("RouteShortName");
insertManager.AddColumn("RouteDescription");
insertManager.AddColumn("RouteType");
insertManager.AddColumn("RouteColor");
insertManager.AddColumn("RouteTextColor");
insertManager.AddColumn("AgencyId_Id");
foreach (EF_Route e in entities)
{
insertManager.AddRow(e.OriginalId, e.RouteShortName, e.RouteDescription, (int)e.RouteType, e.RouteColor, e.RouteTextColor, e.AgencyId.Id);
}
insertManager.DoBulkInsert();
}
