public override void GenerateCsv() { _logger("Starting Opportunities A10 CSV creation."); var opportunityItems = _db.up_CourseInstanceA10CodesForCsvExport(); using (Stream stream = File.Open(Constants.O_Opportunity_A10_CsvFilename, FileMode.OpenOrCreate, FileAccess.Write, FileShare.Read)) { using (TextWriter writer = new StreamWriter(stream)) { var csv = new CsvWriter(writer); csv.WriteField <string>("OPPORTUNITY_ID"); csv.WriteField <string>("A10_CODE"); csv.NextRecord(); foreach (var opportunityItem in opportunityItems.ToList()) { csv.WriteField(opportunityItem.OPPORTUNITY_ID); csv.WriteField(opportunityItem.A10_CODE); csv.NextRecord(); } } } }