private static void Main(string[] args) { var ctaDataFiles = Directory.GetFiles(@"C:\Projects\CTAData"); foreach (var ctaDataFile in ctaDataFiles) { if (!ctaDataFile.EndsWith(".txt")) { continue; } var ctaDataFileName = new FileInfo(ctaDataFile).Name; switch (ctaDataFileName) { case "agency.txt": var agencyValues = CsvParseFile <Agency>(ctaDataFile, new AgencyClassMap()) as List <Agency>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Agency>(agencyValues); agencyValues = null; break; case "calendar.txt": var calendarValues = CsvParseFile <Calendar>(ctaDataFile, new CalendarClassMap()) as List <Calendar>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Calendar>(calendarValues); calendarValues = null; break; case "calendar_dates.txt": var calendarDatesValues = CsvParseFile <CalendarDate>(ctaDataFile, new CalendarDatesClassMap()) as List <CalendarDate>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, CalendarDate>(calendarDatesValues); calendarDatesValues = null; break; case "frequencies.txt": var frequenciesValues = CsvParseFile <Frequency>(ctaDataFile, new FrequenciesClassMap()) as List <Frequency>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Frequency>(frequenciesValues); frequenciesValues = null; break; case "routes.txt": var routesValues = CsvParseFile <Route>(ctaDataFile, new RoutesClassMap()) as List <Route>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Route>(routesValues); routesValues = null; break; case "shapes.txt": var shapesValues = CsvParseFile <Shape>(ctaDataFile, new ShapesClassMap()) as List <Shape>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Shape>(shapesValues); shapesValues = null; break; case "stop_times.txt": var stopTimesValues = CsvParseFile <StopTime>(ctaDataFile, new StopTimesClassMap()) as List <StopTime>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, StopTime>(stopTimesValues); stopTimesValues = null; break; case "stops.txt": var stopsValues = CsvParseFile <Stop>(ctaDataFile, new StopsClassMap()) as List <Stop>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Stop>(stopsValues); stopsValues = null; break; case "transfers.txt": var transfersvalues = CsvParseFile <Transfer>(ctaDataFile, new TransfersClassMap()) as List <Transfer>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Transfer>(transfersvalues); transfersvalues = null; break; case "trips.txt": var tripsvalues = CsvParseFile <Trip>(ctaDataFile, new TripsClassMap()) as List <Trip>; DbUtilities.BulkInsertAndThrowaway <CTADataDbContext, Trip>(tripsvalues); tripsvalues = null; break; default: continue; } } }