private static void updateDoc() { Console.WriteLine("开始更新"); Console.WriteLine("----------------------------------"); //Console.ReadKey(); try { string markdownPath = ConfigurationManager.AppSettings["markdownPath"]; string dbSource = ConfigurationManager.AppSettings["dbSource"]; ContentProvider contentPrvd = new ContentProvider(); List <UpdateMeta> contentUpdateMetaSet = contentPrvd.Acquire(markdownPath); using (SQLiteConnection conn = new SQLiteConnection(dbSource)) { using (SQLiteCommand cmd = new SQLiteCommand()) { cmd.Connection = conn; conn.Open(); _sqliteHelper = new SQLiteHelper(cmd); int count = 0; foreach (var updateMeta in contentUpdateMetaSet) { _sqliteHelper.Update("BODY", updateMeta.updates, updateMeta.limits); count++; if (count % 10 == 0) { Console.WriteLine("----------------------------------"); Console.WriteLine(string.Format("已更新 {0} 条记录", count)); } } conn.Close(); } } Console.WriteLine("----------------------------------"); Console.WriteLine("结束更新"); Console.ReadKey(); } catch (Exception ex) { Console.WriteLine(string.Format("error: {0}", ex)); Console.ReadKey(); //throw; } }