{"id":127,"date":"2024-12-22T16:36:28","date_gmt":"2024-12-22T08:36:28","guid":{"rendered":"https:\/\/www.opengm.top\/?p=127"},"modified":"2024-12-22T16:36:28","modified_gmt":"2024-12-22T08:36:28","slug":"%e7%bd%91%e7%ab%99%e6%90%ad%e5%bb%ba%e5%ae%9e%e5%bd%95-2","status":"publish","type":"post","link":"https:\/\/www.opengm.top\/?p=127","title":{"rendered":"\u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55-2"},"content":{"rendered":"\n<p><br>\n      <title>\u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55-2<\/title><br>\n      <meta charset=\"utf-8\"><br>\n      <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"><\/p>\n\n\n\n<link rel=\"stylesheet\" href=\"file:\/\/\/c:\\Users\\wang\\.vscode\\extensions\\shd101wyy.markdown-preview-enhanced-0.8.15\\crossnote\\dependencies\\katex\\katex.min.css\">\n\n\n\n<style>\n      code[class*=language-],pre[class*=language-]{color:#333;background:0 0;font-family:Consolas,\"Liberation Mono\",Menlo,Courier,monospace;text-align:left;white-space:pre;word-spacing:normal;word-break:normal;word-wrap:normal;line-height:1.4;-moz-tab-size:8;-o-tab-size:8;tab-size:8;-webkit-hyphens:none;-moz-hyphens:none;-ms-hyphens:none;hyphens:none}pre[class*=language-]{padding:.8em;overflow:auto;border-radius:3px;background:#f5f5f5}:not(pre)>code[class*=language-]{padding:.1em;border-radius:.3em;white-space:normal;background:#f5f5f5}.token.blockquote,.token.comment{color:#969896}.token.cdata{color:#183691}.token.doctype,.token.macro.property,.token.punctuation,.token.variable{color:#333}.token.builtin,.token.important,.token.keyword,.token.operator,.token.rule{color:#a71d5d}.token.attr-value,.token.regex,.token.string,.token.url{color:#183691}.token.atrule,.token.boolean,.token.code,.token.command,.token.constant,.token.entity,.token.number,.token.property,.token.symbol{color:#0086b3}.token.prolog,.token.selector,.token.tag{color:#63a35c}.token.attr-name,.token.class,.token.class-name,.token.function,.token.id,.token.namespace,.token.pseudo-class,.token.pseudo-element,.token.url-reference .token.variable{color:#795da3}.token.entity{cursor:help}.token.title,.token.title .token.punctuation{font-weight:700;color:#1d3e81}.token.list{color:#ed6a43}.token.inserted{background-color:#eaffea;color:#55a532}.token.deleted{background-color:#ffecec;color:#bd2c00}.token.bold{font-weight:700}.token.italic{font-style:italic}.language-json .token.property{color:#183691}.language-markup .token.tag .token.punctuation{color:#333}.language-css .token.function,code.language-css{color:#0086b3}.language-yaml .token.atrule{color:#63a35c}code.language-yaml{color:#183691}.language-ruby .token.function{color:#333}.language-markdown .token.url{color:#795da3}.language-makefile .token.symbol{color:#795da3}.language-makefile .token.variable{color:#183691}.language-makefile .token.builtin{color:#0086b3}.language-bash .token.keyword{color:#0086b3}pre[data-line]{position:relative;padding:1em 0 1em 3em}pre[data-line] .line-highlight-wrapper{position:absolute;top:0;left:0;background-color:transparent;display:block;width:100%}pre[data-line] .line-highlight{position:absolute;left:0;right:0;padding:inherit 0;margin-top:1em;background:hsla(24,20%,50%,.08);background:linear-gradient(to right,hsla(24,20%,50%,.1) 70%,hsla(24,20%,50%,0));pointer-events:none;line-height:inherit;white-space:pre}pre[data-line] .line-highlight:before,pre[data-line] .line-highlight[data-end]:after{content:attr(data-start);position:absolute;top:.4em;left:.6em;min-width:1em;padding:0 .5em;background-color:hsla(24,20%,50%,.4);color:#f4f1ef;font:bold 65%\/1.5 sans-serif;text-align:center;vertical-align:.3em;border-radius:999px;text-shadow:none;box-shadow:0 1px #fff}pre[data-line] .line-highlight[data-end]:after{content:attr(data-end);top:auto;bottom:.4em}html body{font-family:'Helvetica Neue',Helvetica,'Segoe UI',Arial,freesans,sans-serif;font-size:16px;line-height:1.6;color:#333;background-color:#fff;overflow:initial;box-sizing:border-box;word-wrap:break-word}html body>:first-child{margin-top:0}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{line-height:1.2;margin-top:1em;margin-bottom:16px;color:#000}html body h1{font-size:2.25em;font-weight:300;padding-bottom:.3em}html body h2{font-size:1.75em;font-weight:400;padding-bottom:.3em}html body h3{font-size:1.5em;font-weight:500}html body h4{font-size:1.25em;font-weight:600}html body h5{font-size:1.1em;font-weight:600}html body h6{font-size:1em;font-weight:600}html body h1,html body h2,html body h3,html body h4,html body h5{font-weight:600}html body h5{font-size:1em}html body h6{color:#5c5c5c}html body strong{color:#000}html body del{color:#5c5c5c}html body a:not([href]){color:inherit;text-decoration:none}html body a{color:#08c;text-decoration:none}html body a:hover{color:#00a3f5;text-decoration:none}html body img{max-width:100%}html body>p{margin-top:0;margin-bottom:16px;word-wrap:break-word}html body>ol,html body>ul{margin-bottom:16px}html body ol,html body ul{padding-left:2em}html body ol.no-list,html body ul.no-list{padding:0;list-style-type:none}html body ol ol,html body ol ul,html body ul ol,html body ul ul{margin-top:0;margin-bottom:0}html body li{margin-bottom:0}html body li.task-list-item{list-style:none}html body li>p{margin-top:0;margin-bottom:0}html body .task-list-item-checkbox{margin:0 .2em .25em -1.8em;vertical-align:middle}html body .task-list-item-checkbox:hover{cursor:pointer}html body blockquote{margin:16px 0;font-size:inherit;padding:0 15px;color:#5c5c5c;background-color:#f0f0f0;border-left:4px solid #d6d6d6}html body blockquote>:first-child{margin-top:0}html body blockquote>:last-child{margin-bottom:0}html body hr{height:4px;margin:32px 0;background-color:#d6d6d6;border:0 none}html body table{margin:10px 0 15px 0;border-collapse:collapse;border-spacing:0;display:block;width:100%;overflow:auto;word-break:normal;word-break:keep-all}html body table th{font-weight:700;color:#000}html body table td,html body table th{border:1px solid #d6d6d6;padding:6px 13px}html body dl{padding:0}html body dl dt{padding:0;margin-top:16px;font-size:1em;font-style:italic;font-weight:700}html body dl dd{padding:0 16px;margin-bottom:16px}html body code{font-family:Menlo,Monaco,Consolas,'Courier New',monospace;font-size:.85em;color:#000;background-color:#f0f0f0;border-radius:3px;padding:.2em 0}html body code::after,html body code::before{letter-spacing:-.2em;content:'\\00a0'}html body pre>code{padding:0;margin:0;word-break:normal;white-space:pre;background:0 0;border:0}html body .highlight{margin-bottom:16px}html body .highlight pre,html body pre{padding:1em;overflow:auto;line-height:1.45;border:#d6d6d6;border-radius:3px}html body .highlight pre{margin-bottom:0;word-break:normal}html body pre code,html body pre tt{display:inline;max-width:initial;padding:0;margin:0;overflow:initial;line-height:inherit;word-wrap:normal;background-color:transparent;border:0}html body pre code:after,html body pre code:before,html body pre tt:after,html body pre tt:before{content:normal}html body blockquote,html body dl,html body ol,html body p,html body pre,html body ul{margin-top:0;margin-bottom:16px}html body kbd{color:#000;border:1px solid #d6d6d6;border-bottom:2px solid #c7c7c7;padding:2px 4px;background-color:#f0f0f0;border-radius:3px}@media print{html body{background-color:#fff}html body h1,html body h2,html body h3,html body h4,html body h5,html body h6{color:#000;page-break-after:avoid}html body blockquote{color:#5c5c5c}html body pre{page-break-inside:avoid}html body table{display:table}html body img{display:block;max-width:100%;max-height:100%}html body code,html body pre{word-wrap:break-word;white-space:pre}}.markdown-preview{width:100%;height:100%;box-sizing:border-box}.markdown-preview ul{list-style:disc}.markdown-preview ul ul{list-style:circle}.markdown-preview ul ul ul{list-style:square}.markdown-preview ol{list-style:decimal}.markdown-preview ol ol,.markdown-preview ul ol{list-style-type:lower-roman}.markdown-preview ol ol ol,.markdown-preview ol ul ol,.markdown-preview ul ol ol,.markdown-preview ul ul ol{list-style-type:lower-alpha}.markdown-preview .newpage,.markdown-preview .pagebreak{page-break-before:always}.markdown-preview pre.line-numbers{position:relative;padding-left:3.8em;counter-reset:linenumber}.markdown-preview pre.line-numbers>code{position:relative}.markdown-preview pre.line-numbers .line-numbers-rows{position:absolute;pointer-events:none;top:1em;font-size:100%;left:0;width:3em;letter-spacing:-1px;border-right:1px solid #999;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none}.markdown-preview pre.line-numbers .line-numbers-rows>span{pointer-events:none;display:block;counter-increment:linenumber}.markdown-preview pre.line-numbers .line-numbers-rows>span:before{content:counter(linenumber);color:#999;display:block;padding-right:.8em;text-align:right}.markdown-preview .mathjax-exps .MathJax_Display{text-align:center!important}.markdown-preview:not([data-for=preview]) .code-chunk .code-chunk-btn-group{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .status{display:none}.markdown-preview:not([data-for=preview]) .code-chunk .output-div{margin-bottom:16px}.markdown-preview .md-toc{padding:0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link div,.markdown-preview .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}.markdown-preview .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}.scrollbar-style::-webkit-scrollbar{width:8px}.scrollbar-style::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}.scrollbar-style::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode]){position:relative;width:100%;height:100%;top:0;left:0;margin:0;padding:0;overflow:auto}html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{position:relative;top:0;min-height:100vh}@media screen and (min-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em calc(50% - 457px + 2em)}}@media screen and (max-width:914px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode]) .markdown-preview{font-size:14px!important;padding:1em}}@media print{html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{display:none}}html body[for=html-export]:not([data-presentation-mode]) #sidebar-toc-btn{position:fixed;bottom:8px;left:8px;font-size:28px;cursor:pointer;color:inherit;z-index:99;width:32px;text-align:center;opacity:.4}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] #sidebar-toc-btn{opacity:1}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc{position:fixed;top:0;left:0;width:300px;height:100%;padding:32px 0 48px 0;font-size:14px;box-shadow:0 0 4px rgba(150,150,150,.33);box-sizing:border-box;overflow:auto;background-color:inherit}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar{width:8px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-track{border-radius:10px;background-color:transparent}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc::-webkit-scrollbar-thumb{border-radius:5px;background-color:rgba(150,150,150,.66);border:4px solid rgba(150,150,150,.66);background-clip:content-box}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc a{text-decoration:none}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc{padding:0 16px}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link{display:inline;padding:.25rem 0}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link div,html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper .md-toc-link p{display:inline}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .md-sidebar-toc .md-toc .md-toc-link-wrapper.highlighted .md-toc-link{font-weight:800}html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{left:300px;width:calc(100% - 300px);padding:2em calc(50% - 457px - 300px \/ 2);margin:0;box-sizing:border-box}@media screen and (max-width:1274px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{padding:2em}}@media screen and (max-width:450px){html body[for=html-export]:not([data-presentation-mode])[html-show-sidebar-toc] .markdown-preview{width:100%}}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .markdown-preview{left:50%;transform:translateX(-50%)}html body[for=html-export]:not([data-presentation-mode]):not([html-show-sidebar-toc]) .md-sidebar-toc{display:none}<br \/>\n\/* Please visit the URL below for more information: *\/<br \/>\n\/*   https:\/\/shd101wyy.github.io\/markdown-preview-enhanced\/#\/customize-css *\/<\/p>\n<\/style>\n\n\n\n<p>      <!-- The content below will be included at the end of the <head> element. --><script type=\"text\/javascript\"><br \/>\n  document.addEventListener(\"DOMContentLoaded\", function () {<br \/>\n    \/\/ your code here<br \/>\n  });<br \/>\n<\/script><\/p>\n\n\n\n<div class=\"crossnote markdown-preview  \">\n<h1 id=\"\u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55\u6570\u636e\u5e93\u63a5\u5165\">\u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55\u2014\u2014\u2014\u2014\u6570\u636e\u5e93\u63a5\u5165 <\/h1>\n<h2 id=\"mysql\u63a5\u5165\">MySQL\u63a5\u5165 <\/h2>\n<ol>\n<li>\u4f7f\u7528NuGet\u83b7\u53d6MySQL\u5f00\u53d1\u5e93mysql.data<\/li>\n<li>\u521b\u5efaMySQL\u670d\u52a1<\/li>\n<\/ol>\n<pre data-role=\"codeBlock\" data-info=\"csharp\" class=\"language-csharp csharp\"><code>  <span class=\"token keyword keyword-public\">public<\/span> <span class=\"token keyword keyword-class\">class<\/span> <span class=\"token class-name\">DbService<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token type-list\"><span class=\"token class-name\">IDbService<\/span><\/span>\n    <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword keyword-private\">private<\/span> <span class=\"token keyword keyword-readonly\">readonly<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-string\">string<\/span><\/span> _connectionString<span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword keyword-private\">private<\/span> <span class=\"token keyword keyword-readonly\">readonly<\/span> <span class=\"token class-name\">ILogger<span class=\"token punctuation\">&lt;<\/span>DbService<span class=\"token punctuation\">&gt;<\/span><\/span> _logger<span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token keyword keyword-public\">public<\/span> <span class=\"token function\">DbService<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\">IConfiguration<\/span> configuration<span class=\"token punctuation\">,<\/span> <span class=\"token class-name\">ILogger<span class=\"token punctuation\">&lt;<\/span>DbService<span class=\"token punctuation\">&gt;<\/span><\/span> logger<span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">{<\/span>\n            _connectionString <span class=\"token operator\">=<\/span> configuration<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetConnectionString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"DefaultConnection\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            _logger <span class=\"token operator\">=<\/span> logger<span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ \u83b7\u53d6\u6570\u636e\u5e93\u8fde\u63a5<\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token keyword keyword-private\">private<\/span> <span class=\"token keyword keyword-async\">async<\/span> <span class=\"token return-type class-name\">Task<span class=\"token punctuation\">&lt;<\/span>MySqlConnection<span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">GetConnectionAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">{<\/span>\n            <span class=\"token keyword keyword-try\">try<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> connection <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">MySqlConnection<\/span><span class=\"token punctuation\">(<\/span>_connectionString<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-await\">await<\/span> connection<span class=\"token punctuation\">.<\/span><span class=\"token function\">OpenAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-return\">return<\/span> connection<span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n            <span class=\"token keyword keyword-catch\">catch<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\">Exception<\/span> ex<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                _logger<span class=\"token punctuation\">.<\/span><span class=\"token function\">LogError<\/span><span class=\"token punctuation\">(<\/span>ex<span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\"<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-throw\">throw<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">Exception<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\"<\/span><span class=\"token punctuation\">,<\/span> ex<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ \u6267\u884c\u67e5\u8be2\u5e76\u8fd4\u56de\u7ed3\u679c\u96c6<\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token keyword keyword-public\">public<\/span> <span class=\"token keyword keyword-async\">async<\/span> <span class=\"token return-type class-name\">Task<span class=\"token punctuation\">&lt;<\/span>IEnumerable<span class=\"token punctuation\">&lt;<\/span>T<span class=\"token punctuation\">&gt;<\/span><span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token generic-method\"><span class=\"token function\">QueryAsync<\/span><span class=\"token generic class-name\"><span class=\"token punctuation\">&lt;<\/span>T<span class=\"token punctuation\">&gt;<\/span><\/span><\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\"><span class=\"token keyword keyword-string\">string<\/span><\/span> sql<span class=\"token punctuation\">,<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-object\">object<\/span><\/span> param <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-null\">null<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">{<\/span>\n            <span class=\"token keyword keyword-using\">using<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> connection <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-await\">await<\/span> <span class=\"token function\">GetConnectionAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token keyword keyword-try\">try<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> command <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">MySqlCommand<\/span><span class=\"token punctuation\">(<\/span>sql<span class=\"token punctuation\">,<\/span> connection<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-if\">if<\/span> <span class=\"token punctuation\">(<\/span>param <span class=\"token operator\">!=<\/span> <span class=\"token keyword keyword-null\">null<\/span><span class=\"token punctuation\">)<\/span>\n                <span class=\"token punctuation\">{<\/span>\n                    <span class=\"token keyword keyword-foreach\">foreach<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> prop <span class=\"token keyword keyword-in\">in<\/span> param<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetType<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">GetProperties<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token punctuation\">{<\/span>\n                        command<span class=\"token punctuation\">.<\/span>Parameters<span class=\"token punctuation\">.<\/span><span class=\"token function\">AddWithValue<\/span><span class=\"token punctuation\">(<\/span><span class=\"token interpolation-string\"><span class=\"token string\">$\"@<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token expression language-csharp\">prop<span class=\"token punctuation\">.<\/span>Name<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">,<\/span> prop<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetValue<\/span><span class=\"token punctuation\">(<\/span>param<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">??<\/span> DBNull<span class=\"token punctuation\">.<\/span>Value<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                    <span class=\"token punctuation\">}<\/span>\n                <span class=\"token punctuation\">}<\/span>\n\n                <span class=\"token keyword keyword-using\">using<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> reader <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-await\">await<\/span> command<span class=\"token punctuation\">.<\/span><span class=\"token function\">ExecuteReaderAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> list <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">List<span class=\"token punctuation\">&lt;<\/span>T<span class=\"token punctuation\">&gt;<\/span><\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> properties <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-typeof\">typeof<\/span><span class=\"token punctuation\">(<\/span><span class=\"token type-expression class-name\">T<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">GetProperties<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token punctuation\">.<\/span><span class=\"token function\">Select<\/span><span class=\"token punctuation\">(<\/span>p <span class=\"token operator\">=&gt;<\/span> <span class=\"token keyword keyword-new\">new<\/span>\n                    <span class=\"token punctuation\">{<\/span>\n                        Property <span class=\"token operator\">=<\/span> p<span class=\"token punctuation\">,<\/span>\n                        ColumnAttr <span class=\"token operator\">=<\/span> p<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetCustomAttributes<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword keyword-typeof\">typeof<\/span><span class=\"token punctuation\">(<\/span><span class=\"token type-expression class-name\">ColumnAttribute<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token boolean\">false<\/span><span class=\"token punctuation\">)<\/span>\n                            <span class=\"token punctuation\">.<\/span><span class=\"token function\">FirstOrDefault<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword keyword-as\">as<\/span> <span class=\"token class-name\">ColumnAttribute<\/span>\n                    <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token punctuation\">.<\/span><span class=\"token function\">ToList<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n                <span class=\"token keyword keyword-while\">while<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token keyword keyword-await\">await<\/span> reader<span class=\"token punctuation\">.<\/span><span class=\"token function\">ReadAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n                <span class=\"token punctuation\">{<\/span>\n                    <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> item <span class=\"token operator\">=<\/span> Activator<span class=\"token punctuation\">.<\/span><span class=\"token generic-method\"><span class=\"token function\">CreateInstance<\/span><span class=\"token generic class-name\"><span class=\"token punctuation\">&lt;<\/span>T<span class=\"token punctuation\">&gt;<\/span><\/span><\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                    <span class=\"token keyword keyword-foreach\">foreach<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> prop <span class=\"token keyword keyword-in\">in<\/span> properties<span class=\"token punctuation\">)<\/span>\n                    <span class=\"token punctuation\">{<\/span>\n                        <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> columnName <span class=\"token operator\">=<\/span> prop<span class=\"token punctuation\">.<\/span>ColumnAttr<span class=\"token punctuation\">?.<\/span>Name <span class=\"token operator\">??<\/span> prop<span class=\"token punctuation\">.<\/span>Property<span class=\"token punctuation\">.<\/span>Name<span class=\"token punctuation\">.<\/span><span class=\"token function\">ToLower<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                        <span class=\"token keyword keyword-if\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token operator\">!<\/span>reader<span class=\"token punctuation\">.<\/span><span class=\"token function\">IsDBNull<\/span><span class=\"token punctuation\">(<\/span>reader<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetOrdinal<\/span><span class=\"token punctuation\">(<\/span>columnName<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n                        <span class=\"token punctuation\">{<\/span>\n                            prop<span class=\"token punctuation\">.<\/span>Property<span class=\"token punctuation\">.<\/span><span class=\"token function\">SetValue<\/span><span class=\"token punctuation\">(<\/span>item<span class=\"token punctuation\">,<\/span> reader<span class=\"token punctuation\">[<\/span>columnName<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                        <span class=\"token punctuation\">}<\/span>\n                    <span class=\"token punctuation\">}<\/span>\n                    list<span class=\"token punctuation\">.<\/span><span class=\"token function\">Add<\/span><span class=\"token punctuation\">(<\/span>item<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token punctuation\">}<\/span>\n\n                <span class=\"token keyword keyword-return\">return<\/span> list<span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n            <span class=\"token keyword keyword-catch\">catch<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\">Exception<\/span> ex<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                _logger<span class=\"token punctuation\">.<\/span><span class=\"token function\">LogError<\/span><span class=\"token punctuation\">(<\/span>ex<span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"\u6267\u884c\u67e5\u8be2\u65f6\u53d1\u751f\u9519\u8bef: {Sql}\"<\/span><span class=\"token punctuation\">,<\/span> sql<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-throw\">throw<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">Exception<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6267\u884c\u67e5\u8be2\u65f6\u53d1\u751f\u9519\u8bef\"<\/span><span class=\"token punctuation\">,<\/span> ex<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ \u6267\u884c\u975e\u67e5\u8be2SQL\u8bed\u53e5<\/span>\n        <span class=\"token doc-comment comment\">\/\/\/ <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>summary<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/span>\n        <span class=\"token keyword keyword-public\">public<\/span> <span class=\"token keyword keyword-async\">async<\/span> <span class=\"token return-type class-name\">Task<span class=\"token punctuation\">&lt;<\/span><span class=\"token keyword keyword-int\">int<\/span><span class=\"token punctuation\">&gt;<\/span><\/span> <span class=\"token function\">ExecuteAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\"><span class=\"token keyword keyword-string\">string<\/span><\/span> sql<span class=\"token punctuation\">,<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-object\">object<\/span><\/span> param <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-null\">null<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">{<\/span>\n            <span class=\"token keyword keyword-using\">using<\/span> <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> connection <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-await\">await<\/span> <span class=\"token function\">GetConnectionAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token keyword keyword-try\">try<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                <span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> command <span class=\"token operator\">=<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">MySqlCommand<\/span><span class=\"token punctuation\">(<\/span>sql<span class=\"token punctuation\">,<\/span> connection<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-if\">if<\/span> <span class=\"token punctuation\">(<\/span>param <span class=\"token operator\">!=<\/span> <span class=\"token keyword keyword-null\">null<\/span><span class=\"token punctuation\">)<\/span>\n                <span class=\"token punctuation\">{<\/span>\n                    <span class=\"token keyword keyword-foreach\">foreach<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\"><span class=\"token keyword keyword-var\">var<\/span><\/span> prop <span class=\"token keyword keyword-in\">in<\/span> param<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetType<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">GetProperties<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token punctuation\">{<\/span>\n                        command<span class=\"token punctuation\">.<\/span>Parameters<span class=\"token punctuation\">.<\/span><span class=\"token function\">AddWithValue<\/span><span class=\"token punctuation\">(<\/span><span class=\"token interpolation-string\"><span class=\"token string\">$\"@<\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token expression language-csharp\">prop<span class=\"token punctuation\">.<\/span>Name<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">,<\/span> prop<span class=\"token punctuation\">.<\/span><span class=\"token function\">GetValue<\/span><span class=\"token punctuation\">(<\/span>param<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">??<\/span> DBNull<span class=\"token punctuation\">.<\/span>Value<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                    <span class=\"token punctuation\">}<\/span>\n                <span class=\"token punctuation\">}<\/span>\n\n                <span class=\"token keyword keyword-return\">return<\/span> <span class=\"token keyword keyword-await\">await<\/span> command<span class=\"token punctuation\">.<\/span><span class=\"token function\">ExecuteNonQueryAsync<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n            <span class=\"token keyword keyword-catch\">catch<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\">Exception<\/span> ex<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">{<\/span>\n                _logger<span class=\"token punctuation\">.<\/span><span class=\"token function\">LogError<\/span><span class=\"token punctuation\">(<\/span>ex<span class=\"token punctuation\">,<\/span> <span class=\"token string\">\"\u6267\u884c\u975e\u67e5\u8be2\u547d\u4ee4\u65f6\u53d1\u751f\u9519\u8bef: {Sql}\"<\/span><span class=\"token punctuation\">,<\/span> sql<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n                <span class=\"token keyword keyword-throw\">throw<\/span> <span class=\"token keyword keyword-new\">new<\/span> <span class=\"token constructor-invocation class-name\">Exception<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6267\u884c\u975e\u67e5\u8be2\u547d\u4ee4\u65f6\u53d1\u751f\u9519\u8bef\"<\/span><span class=\"token punctuation\">,<\/span> ex<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token punctuation\">}<\/span>\n        <span class=\"token punctuation\">}<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<\/code><\/pre>\n<p><\/p><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55-2 \u7f51\u7ad9\u642d\u5efa\u5b9e\u5f55\u2014\u2014\u2014\u2014\u6570\u636e\u5e93\u63a5\u5165 MySQL\u63a5\u5165 \u4f7f\u7528NuGet\u83b7\u53d6MySQL\u5f00\u53d1\u5e93mysql [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[11],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-csharp","tag-csharp"],"_links":{"self":[{"href":"https:\/\/www.opengm.top\/index.php?rest_route=\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.opengm.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.opengm.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.opengm.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.opengm.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127"}],"version-history":[{"count":0,"href":"https:\/\/www.opengm.top\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.opengm.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.opengm.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.opengm.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}