C# importing csv file into SQL database using FileHelpers

Question

i'm trying to import a .csv file using the great FileHelpers library. Doing some research most of the time i read that i should use BulkCopy to import the result into an SQL database table.

Could you please help me how to accomplish this? So far i have this:

public void ImportCSV()
        {
            string path = @"C:\...\...\...\TestCSV\";
            var engine = new FileHelperEngine<Customer>();
            var result = engine.ReadFile(path + "test3.csv");

            engine.WriteFile(path + "FileOut.csv", result);
        }

and a mapping class:

public class Customer
{
    public string Feld1;
    public string Feld2;
    public string Feld3;
    public string Feld4;
}

this works but i don't know how instead of writing the result in a new .csv file i can use an SQL table (i know this has been discussed before but i can't find a solution that's working for me so far) Thanks in advance for your help

MySQL (is that what you mean by dbms?) – BrianF. Oct 22 '19 at 11:38 — BrianF., Oct 22 '19 at 11:38
any help would be appreciated. – BrianF. Oct 23 '19 at 10:55 — BrianF., Oct 23 '19 at 10:55

score 1 · Accepted Answer · answered Nov 15 '19 at 23:48

1

You don't directly read it into SQL. You read it into a DataTable via the FileHelpers routines then use that DataTable to populate the database using whichever .NET provider you need to.

answered Nov 15 '19 at 23:48

netniV

2,328
1
15
24

C# importing csv file into SQL database using FileHelpers

1 Answers1