public override void GenerateCsv() { _logger("Starting Venues CSV creation."); var venueItems = _db.up_VenueListForCsvExport(); using (Stream stream = File.Open(Constants.C_Venues_CsvFilename, FileMode.OpenOrCreate, FileAccess.Write, FileShare.Read)) { using (TextWriter writer = new StreamWriter(stream)) { var csv = new CsvWriter(writer); csv.WriteField <string>("PROVIDER_ID"); csv.WriteField <string>("VENUE_ID"); csv.WriteField <string>("VENUE_NAME"); csv.WriteField <string>("PROV_VENUE_ID"); csv.WriteField <string>("PHONE"); csv.WriteField <string>("ADDRESS_1"); csv.WriteField <string>("ADDRESS_2"); csv.WriteField <string>("TOWN"); csv.WriteField <string>("COUNTY"); csv.WriteField <string>("POSTCODE"); csv.WriteField <string>("EMAIL"); csv.WriteField <string>("WEBSITE"); csv.WriteField <string>("FAX"); csv.WriteField <string>("FACILITIES"); csv.WriteField <string>("DATE_CREATED"); csv.WriteField <string>("DATE_UPDATED"); csv.WriteField <string>("STATUS"); csv.WriteField <string>("UPDATED_BY"); csv.WriteField <string>("CREATED_BY"); csv.WriteField <string>("XMIN"); csv.WriteField <string>("XMAX"); csv.WriteField <string>("YMIN"); csv.WriteField <string>("YMAX"); csv.WriteField <string>("X_COORD"); csv.WriteField <string>("Y_COORD"); csv.WriteField <string>("SEARCH_REGION"); csv.WriteField <string>("SYS_DATA_SOURCE"); csv.WriteField <string>("DATE_UPDATED_COPY_OVER"); csv.WriteField <string>("DATE_CREATED_COPY_OVER"); csv.NextRecord(); foreach (var venueItem in venueItems.ToList()) { csv.WriteField(venueItem.PROVIDER_ID); csv.WriteField(venueItem.VENUE_ID); csv.WriteField(venueItem.VENUE_NAME); csv.WriteField(venueItem.PROV_VENUE_ID); csv.WriteField(venueItem.PHONE); csv.WriteField(venueItem.ADDRESS_1); csv.WriteField(venueItem.ADDRESS_2); csv.WriteField(venueItem.TOWN); csv.WriteField(venueItem.COUNTY); csv.WriteField(venueItem.POSTCODE); csv.WriteField(venueItem.EMAIL); csv.WriteField(venueItem.WEBSITE); csv.WriteField(venueItem.FAX); csv.WriteField(venueItem.FACILITIES); csv.WriteField(venueItem.DATE_CREATED); csv.WriteField(venueItem.DATE_UPDATE); csv.WriteField(venueItem.STATUS); csv.WriteField(venueItem.UPDATED_BY); csv.WriteField(venueItem.CREATED_BY); csv.WriteField(venueItem.XMIN); csv.WriteField(venueItem.XMAX); csv.WriteField(venueItem.YMIN); csv.WriteField(venueItem.YMAX); csv.WriteField(venueItem.X_COORD); csv.WriteField(venueItem.Y_COORD); csv.WriteField(venueItem.SEARCH_REGION); csv.WriteField(venueItem.SYS_DATA_SOURCE); csv.WriteField(venueItem.DATE_UPDATED_COPY_OVER); csv.WriteField(venueItem.DATE_CREATED_COPY_OVER); csv.NextRecord(); } } } }