private static void BulkInsert(SQLiteDbContext db) { Stopwatch sw = new Stopwatch(); var user = db.Query <User>(x => x.Id > 0).Take(1).FirstOrDefault(); var dataTable = db.SqlQueryDataTable("select Name,Gender,Age,OpTime from Users LIMIT 1"); DataTable dtNew = dataTable.Copy(); dtNew.Clear(); //清楚数据 for (var i = 0; i < 100000; i++) { dtNew.Rows.Add(dataTable.Rows[0].ItemArray); //添加数据行 } sw.Reset(); sw.Start(); db.BulkInsert("Users", dtNew); sw.Stop(); Console.WriteLine("BulkInsert DataTable 耗时:" + sw.ElapsedMilliseconds); //var user = db.Query<User>(x => x.Id > 0).Take(1).FirstOrDefault(); var newList = new List <User>(); for (var i = 0; i < 100000; i++) { newList.Add(user); } sw.Reset(); sw.Start(); db.BulkInsert <User>("Users", newList); sw.Stop(); Console.WriteLine("BulkInsert List 耗时:" + sw.ElapsedMilliseconds); }