Rename CSV column headings?

DigitalReach · August 27, 2018, 5:56am

When I use myObjectList.ToCsv() is there a way to rename the column headings?

I want the csv to be the same as my PostgreSQL columns names. ORMLite changes PropertyName to property_name.

At the moment the headings appear like PropertyName in the CSV but I want them to be property_name.

Is there any example of this?

mythz · August 27, 2018, 6:03am

When returning typed POCOs you would rename properties by using [DataMember(Name="NewName")] which is the standard way for all Serializers.

CSV also allows specifying custom headers in code, see:

github.com

ServiceStack/ServiceStack.Text/blob/master/tests/ServiceStack.Text.Tests/CsvTests/CustomHeaderTests.cs

using System;
using System.Collections.Generic;
using NUnit.Framework;
using ServiceStack.Text.Tests.Support;

namespace ServiceStack.Text.Tests.CsvTests
{
    [TestFixture]
    public class CustomHeaderTests
    {
        [OneTimeTearDown]
        public void TestFixtureTearDown()
        {
            CsvConfig<TableItem>.Reset();
        }

        [Test]
        public void Can_serialize_custom_headers_map()
        {
            CsvConfig<TableItem>.CustomHeadersMap = new Dictionary<string, string> {

This file has been truncated. show original

DigitalReach · August 27, 2018, 6:25am

CsvConfig<MyObject>.CustomHeadersMap is Ideal, thanks.