read csv file and save it to database

In the code below, it will open the CSV file and read the data row by row.

 

 foreach (string path in Directory.EnumerateFiles(@"C:\ipub\root", "*.csv"))
 {
   string[] lines = System.IO.File.ReadAllLines(path);
   foreach (string line in lines)
 {
   Console.WriteLine(line);

 }

 }

 

how to change this code, so that after it opens the CSV file and then read row by row after that save it to database.

 

Or there have another way to do it 

 

thank you

I using visual studio 2019, c#