CsvWriter. First record ends up on the same line as the header

[norgie]

Hi.
I'm trying to use CsvWriter to produce a csv-file. When I open the generated file the first record is placed on the same line as the header, like so:

Produkt,Område,UtcDato,Pris_1,Pris_2,XYZ123,ABC,2021-09-19T22:00:00,98.84000000,160.80000000
XYZ123,ABC,2021-09-19T22:15:00,98.84000000,160.80000000
XYZ123,ABC,2021-09-19T22:30:00,98.84000000,160.80000000

and it should of course look like this

Produkt,Område,UtcDato,Pris_1,Pris_2
XYZ123,ABC,2021-09-19T22:00:00,98.84000000,160.80000000
XYZ123,ABC,2021-09-19T22:15:00,98.84000000,160.80000000
XYZ123,ABC,2021-09-19T22:30:00,98.84000000,160.80000000

The CsvWriter instance is configured like this

public static class CsvHelperConfigurationProvider
{
    public static CsvConfiguration CsvHelperConfiguration => new CsvConfiguration(CultureInfo.InvariantCulture) 
                                                              { 
                                                                 HasHeaderRecord = true, 
                                                                 Delimiter = "," 
                                                              };
}

And the code producing the csv looks like this:

fileName = string.Format(FileNameTemplate, fileName, $"{period.LocalValidFrom:dd-MM-yyyy}_{period.LocalValidTo:dd-MM-yyyy}");
var ms = new MemoryStream();
using (var sr = new StreamReader(ms))
{
    using (var sw = new StreamWriter(ms))
    {
       using (var csvWriter = new CsvWriter(sw, CsvHelperConfigurationProvider.CsvHelperConfiguration))
       {
           csvWriter.Context.RegisterClassMap<ProductMap>();
           csvWriter.WriteHeader<Product>();
           csvWriter.WriteRecords(products.Cast<Product>());
           csvWriter.Flush();
           ms.Position = 0;
           return new CsvFile(fileName, sr.ReadToEnd());
       }
   }
}

The Product class and its Map looks like this:

   public class Product : ICsvProduct
    {
        public string Name { get; set; }
        public string Area { get; set; }
        public DateTime UtcDateTime { get; set; }
        public decimal? Price1 { get; set; }
        public decimal? Price2 { get; set; }
    }

    public class ProductMap : ClassMap<Product>
    {
        public ElspotPriceProductMap()
        {
            Map(sp => sp.Name).Index(0).Name("Produkt");
            Map(sp => sp.Area).Index(1).Name("Område");
            Map(sp => sp.UtcDateTime).Index(2).Name("UtcDato").TypeConverterOption.Format("s");
            Map(sp => sp.Price1).Index(3).Name("Pris_1");
            Map(sp => sp.Price2).Index(4).Name("Pris_2");
        }
    }

It's probably just something "silly" I've forgotten but I can't figure out what so any help would be more than welcome.
TIA

[JoshClose]

WriteHeader doesn't add a newline. You need to call NextRecord for that to happen. Based on your example, you don't need to call WriteHeader at all. WriteRecords will do that for you.

[norgie]

Look at that. Works like a charm. Thanks for your help and thank you for a great product, @JoshClose

[JoshClose]

No problem!