Cinchoo | Application framework for .NET | Application Framework library

when writing the CSV file it does not have the values red and small

Example:

imput jsonFile:

I need to bring in a number of .CSV files into unique keyed SQL Tables (Table names and column names match from source to target). I started looking at libs like Cinchoo-ETL, but I need to do an "Upsert" Meaning Update if record is present insert if it's not present. I'm not sure if Cinchoo-ETL or some other lib has this feature built in.

For example lets say the SQL Server Customer table has some records in it, Cust# is a primary Key

Cust# Name

1 Bob

2 Jack

The CSV file looks something like this:

Cust#,Name

2,Jill

3,Roger

When the ETL program runs it needs to update Cust# 2 from Jack to Jill and insert a new cust# 3 record for Roger.

Speed reusability is important as there will be 80 or so different tables, some of the tables can have several million records in them.

Any ideas for a fast easy way to do this? Keep in mind I'm not a daily developer so examples would be awesome.

Thanks!

I am trying to convert a JSON file ( a Microsoft.Graph.Event ) to a CSV file. I'm using Cinchoo ETL to do this. Here is the URL I'm referring to:

https://www.codeproject.com/Articles/1193650/Cinchoo-ETL-Quick-Start-Converting-JSON-to-CSV-Fil

Here is my code:

I want to serialize a list of strings in C#? I have previously successfully used an open-source library Cinchoo ETL for similar tasks, but I am stuck in this particular scenario. I do not want to use POCO since my source data structure is dynamic. I would much rather read the data from a csv and serialize it.

My source data in csv format: