且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我想使用实体框架将数据从CSV文件导入SQL数据库

更新时间:2023-01-21 20:07:09

var readcsv = File.ReadAllText(filepath);
string[] csvfilerecord = readcsv.Split('\n');

foreach (var row in csvfilerecord)
{
  if (!string.IsNullOrEmpty(row))
  {
    var cells = row.Split(','))
    var card = new Cards
      {
         number = cells[0], // number is in first cell
         cvv = cells[1],   // cvv is in second cell
         // ...
      };
  }
}