using System;

using System.Collections.Generic;

using System.Globalization;

using System.IO;

using System.Linq;

using CsvHelper;

using CsvHelper.Configuration;

​

public class Program

{

    public static void Main()

    {

        var csvContent = @"employee,emp city,state,emp address

""abc"",""efg"",""lkj"",""building name""

""wer"",""sdf"",""qwe"",""afj Building, near cross""";

​

        List<Employee> employees;

        using (var reader = new StringReader(csvContent))

        using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))

        {

            csv.Context.RegisterClassMap<EmployeeMap>();

            var records = csv.GetRecords<Employee>();

            employees = records.ToList();

        }

​

        foreach (var employee in employees)

        {

            Console.WriteLine(System.Text.Json.JsonSerializer.Serialize(employee));

        }

    }

}

​

public class EmployeeMap : ClassMap<Employee>

{

    public EmployeeMap()

    {

        Map(e => e.Name).Name("employee");

        Map(e => e.City).Name("emp city");

        Map(e => e.State).Name("state");

        Map(e => e.Address).Name("emp address");

    }

}

​

public class Employee

{

    public string Name { get; set; }

​

    public string City { get; set; }

​

    public string State { get; set; }

​

    public string Address { get; set; }

}