{"id":513,"date":"2018-01-11T11:08:47","date_gmt":"2018-01-11T03:08:47","guid":{"rendered":"http:\/\/www.ji-zhi.net\/?p=513"},"modified":"2019-09-26T17:31:32","modified_gmt":"2019-09-26T17:31:32","slug":"net%e7%bc%96%e7%a8%8b%e4%b8%ad%e8%a7%a3%e5%86%b3sqlite%e6%96%87%e4%bb%b6%e6%97%a0%e6%b3%95%e9%87%8a%e6%94%be%e7%9a%84%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/www.ji-zhi.net\/?p=513","title":{"rendered":".Net\u7f16\u7a0b\u4e2d\u89e3\u51b3SQLite\u6587\u4ef6\u65e0\u6cd5\u91ca\u653e\u7684\u95ee\u9898"},"content":{"rendered":"<p>.net\u7f16\u7a0b\u65f6\uff0c\u9047\u5230\u5df2\u8fde\u63a5\u8fc7\u7684SQLite\u6587\u4ef6\u65e0\u6cd5\u91ca\u653e\u7684\u95ee\u9898\u3002SQLiteconnection\u7ecf\u8fc7Close()\u548cDispose()\uff0c\u4ecd\u7136\u62a5\u201c\u6b63\u7531\u53e6\u4e00\u8fdb\u7a0b\u4f7f\u7528\uff0c\u56e0\u6b64\u8be5\u8fdb\u7a0b\u65e0\u6cd5\u8bbf\u95ee\u6b64\u6587\u4ef6\u201d\u3002<\/p>\n<p>\u6000\u7591\u662f\u56e0\u4e3a\u867d\u7136Dispose\u4e86\uff0c\u4f46\u662fGC\u8fd8\u6ca1\u6709\u8fdb\u884c\u56de\u6536\uff0c\u5bfc\u81f4\u88ab\u9501\u5b9a\u3002<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\u662f\u663e\u5f0f\u56de\u6536\uff1a<\/p>\n<pre class=\"lang:c# decode:true \">GC.Collect();  \nGC.WaitForPendingFinalizers();<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>.net\u7f16\u7a0b\u65f6\uff0c\u9047\u5230\u5df2\u8fde\u63a5\u8fc7\u7684SQLite\u6587\u4ef6\u65e0\u6cd5\u91ca\u653e\u7684\u95ee\u9898\u3002SQLiteconnection\u7ecf\u8fc7Close()\u548cDispose()\uff0c\u4ecd\u7136\u62a5\u201c\u6b63\u7531\u53e6\u4e00\u8fdb\u7a0b\u4f7f\u7528\uff0c\u56e0\u6b64\u8be5\u8fdb\u7a0b\u65e0\u6cd5\u8bbf\u95ee\u6b64\u6587\u4ef6\u201d\u3002 \u6000\u7591\u662f\u56e0\u4e3a\u867d\u7136Dispose\u4e86\uff0c\u4f46\u662fGC\u8fd8\u6ca1\u6709\u8fdb\u884c\u56de\u6536\uff0c\u5bfc\u81f4\u88ab\u9501\u5b9a\u3002 \u89e3\u51b3\u65b9\u6cd5\u662f\u663e\u5f0f\u56de\u6536\uff1a GC.Collect(); GC.WaitForPendingFinalizers(); &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[13,42,56],"class_list":["post-513","post","type-post","status-publish","format-standard","hentry","category-windows","tag-net","tag-sqlite","tag-56"],"_links":{"self":[{"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/posts\/513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=513"}],"version-history":[{"count":1,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":542,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions\/542"}],"wp:attachment":[{"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ji-zhi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}