Dapper批量添加

最新推荐文章于 2024-06-25 09:09:50 发布

转载最新推荐文章于 2024-06-25 09:09:50 发布 · 164 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/25miao/p/7206960.html

本文介绍了一个从文件中读取数据并将其转换为列表的过程，随后使用C#的SqlConnection将这些数据批量插入到指定的数据库表中。文章通过具体的代码示例展示了如何实现这一过程。

Public void Add()
{
      List<PPQuery> lists = GetDataByFile(tempFilePath);
     private static readonly string sqlconnection = "Data Source=.;Initial Catalog=xxxx;Persist Security Info=True;User ID=sa;Password=123";
     using (var connection = new System.Data.SqlClient.SqlConnection(sqlconnection))
           {
             resultData = connection.Execute("Insert into [PPQuery] values (@ID,@Name,@Time,@Company)", lists);
          }
}

   public List<PPQuery> GetDataByFile(string path)
        {
            var file = File.Open(path, FileMode.Open);
            List<string> txt = new List<string>();
            using (var stream = new StreamReader(file, System.Text.Encoding.GetEncoding("utf-8")))
            {
                while (!stream.EndOfStream)
                {
                    txt.Add(stream.ReadLine());
                }
            }
            file.Close();
            List<PPQuery> models = new List<PPQuery>();
            //循环list
            foreach (string item in txt)
            {
                string[] tempstr = item.Split(',');
                PPQuery model = new PPQuery();
                model.ID = tempstr[0];
                model.Name = tempstr[1];
                model.Time =Convert.ToDateTime(tempstr[2]);
                model.Company = tempstr[3];
                models.Add(model);
            }
            return models;
        }