Dapper使用

公司的项目使用了Dapper做数据库连接处理,感觉不错,自己研究一下怎么用。

在网上找了找资料对Dapper都比较推崇。主要是两个方面,一个是连接速度很快,一个是代码开源且简单,只有一个SqlMapper.cs文件,是一个轻型的ORM类。

从这篇博客里面找到它的一些介绍和使用方式,但奈何英文太差,只好自己再做个笔记。http://www.cnblogs.com/yipu/archive/2012/11/21/2780199.html

首先从GitHub上获取Dapper:https://github.com/SamSaffron/dapper-dot-net

下载完了以后,打开工程,有下面的目录

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUsAAAHXCAIAAAC6ce/xAAAfoUlEQVR4nO2dP4/cRpqH+5MsoM0WEOBAvcnG8zFWUX+TuWyA9iaXCAvsJRLgSDAO6sCHBfZ0q8DwXnI6Rx0c4LHsiwzcZGNAAC/gv/eteqtY7GF3ky+fB4RhsfmnyOGPVaxmPb358s9/ffGqGpzGUrJNJiamc0+b8oTfFEPCmZhmMpFwJibP00UT/qGqbsX/S968NZZ/+bH68D5Xqtv76v7jQMlLllnD9PJjVYnzb0zvrcet+/RH6T8c03wmO+HxQ3Wd8McCUgmvr7Cq6vP25qG54N48VG/eGnkeTPiLV9WH+CJ7W91n+wjq5bsV3zyoT3MZONtkHEV30u7Dg1Ln5H00x5zeVvdV9abbWjvdijPVbaT7u6i93Bubrf9wL7iNzngyEl5V1dff//TFVz8+e/3pi69+/Pr7n+or4EkJf1vd31cv9NXz4aF6+UrNbK4Yq8aor7/bfHarqrrv91VvMLj6b+/7hN/GyxQGZurpg3lneVvdt6eoO1d1VruSVw/Vh+gYje1U6Sh2e7HujLfdackmPPh/pvlMdsKfvf509+3Pfz/+dPftz89efzIT/vnz58+fP//6668lCQ+Sef+xudSa+d3VI8L5QtThZvWeqjS6xkLyJvCxepFK+CsVoYtNZsJv7+3oBlmK72Jqelvd63vWmwd96mTCu/tIu2Sf8AR9SRJ3AabrTnbCTb755pvPnz938b67u/vjH/8oZ+Zb6R+q6ra+ht7rVKenfMIHKq7ogrPrSSsh/RyrbVx/+qF4/gvR6SCfUJqFdaiCYpi1YnAgmYTLZ295T7y9F/uNEt4tqRI+VIfHNwimOUzJOlxO9dV5d3d3d3dXV913d3eyX60w4aoWfV/df4yq4rfVB/HPrhKL82w212UeXkat/VS1nEn4m/v2kn3fb6F+br8tni+fsfstP+SK1J0xs2IPGi+phN/eq1iGp7or4VQJT99Dma445RL++PgoE17nuc75zc3N4d27sQnv6vC+fa4rt5cfqzdvw272HlFFxPVbqqO+u/o/6Fr0hdhUnPBu47LNb7bqZWiN+VH7tgvP8MNzVCUGoU2V35ySzzVWwrsjGtFK51F8ltO4hHepPrx7V4f55Dq8DmRw2X2Q13T0ANlPooaU27crkPcD3bxhQt63t5K31X13R9D9W+MSbrVdS2IZHJEZ78JNvcgnvP6j3DcJ7zojqcMdTCNa6U9N+EP1sqvD76Nu24fq5XsjId3VJqewr+iVqvEGe9qCizXuS2/2KMIpH2jfPPRbKJn/Qdynbu8T3XvWFDTvU/eppyS8bknFX78FlXPpczgJn980oqct00offuNFXiKiUpWXXV9j6NpbJudF+xVRWCuaVWV9zb1vmgypBqT6PjzqTK66+k3W4eL+dCsWNudnuuvyf5u+Lz1qJJvf5Oc3mPn2QS4jb0zyT5aCvvSZTyPeaauzXf9dg562mGD1ru6qKw0z4fWUDHDVVOlh2qNLrX/Cr7fzvn/0bfP6pFOWCmdhXTpimrR3eiDh8pFErNK/08b34cucShP+4pWKbh3y+tuyOM++p8slXGZs3hPvtM12GpHwF69U5Zyqrt1Pl0w4E9MTp3EJZ2JiWtZEwpmYPE+bL//812Q/KQAsHBIO4BkSDuCZooR/9913U+3v/z799//82z+Z01S7AICOooT/7ne/myrkP/zHP//vf/1r7I0g4QDnoCjhv/nNb54/f35yyFOVNnU4wLkpTfjhcDg55DNO+HG/3ewO19gzwEUoTXhVVSeHnIQDXIsRCa+q6ssvv3z+/PnDw0N++YApEn7Ybbb7/W6z2Ww2m+3+WFU6niqqh2a5epVmaTm/ntf/UywD4IoRCf/uu++eP39+OIyu8iZK+KaJ8HG/rRNpJ/yw26i5bXoPIuvd0tTh4JzShJ8c72rCOrzPZzrhckH5T1Fhi2qbhINzRvSlnxbvaj4JN5riJBycU5Tw3/72tyfHu3pKwrsGeTLh4pF8uJUun9T7Fj8JB8cUJfwp8a7Ol/AmwZvNZrPd7XR9bvW09fP7VDfz6GkDp3h/L91unAOsBX8JP+636mszAg5rxl/CVWuceMPK8ZhwAGgh4QCeIeEAniHhAJ4h4QCeweIE4BlPFqfDrvANVPG6K4Bv5m9x6geFDcX3cgnvvnHnnXaYOTO3OAXDSPKByid84kEm4nVYhq/AfJm3xakfY1ICCQcImbnFSQ35DOZHjfc24ca4cS1sspVPwaYiaVRUgoQKKnBFtcsempb97tAvkh32BjABs7c4NWGQ170eT9LfBDIJ13O18imxqUgaFZXLqsNNV9Rh16W5PpygRDQC4Gwsw+LUVHFd+lTiZJBGJjy3KWM4usROuO2Kklsz/79eje59mJ6lWJyqvoY1Ytnl5OkJzwkngtLYCc8vm/z/qr2PkXOYktlbnPrWq6rxVNO6fwDuEh7bncpa6baYdVQrPXZFDSX8uN9bUmiApzNvi5PqgpKXfranLWF36oVNhT1t6YQH34crFZTRaTZch5d/6Q8wCt5LB/AMCQfwDAkH8AwJB/AMCQfwDAkH8AwJB/AMCQfwzNktTn/40+8Lp5N3AQApzm5x+sOffh87m2JIOMA5OLvF6WkJly+tzuGVTmtwSP/uqVHaaLDZJhqGpt68D0alATyRKS1OX3//0xdf/fjs9acvvvrx6+9/qmd2CT+8e3dzc3Nzc3N49+7x8fHm5qb7bz7hQQKumvLjfrvZ7fSQMJ3wRPEC/0w/pEYOVeGHUmFyprQ4PXv96e7bn/9+/Onu25+fvf5Uz6wTXsf7l19+eXx8vP/hhxtNacKtGZel3r2WQpyScP2JcsGQcJiSs1uc6oTf3Nz85z/+IZvlp9ThwRxjFFf9aTxSKzW/sqRLYmFrUNnuoEalPjHhwViz2TyPgBOmtDg9e/1JTvVMM+Gn1+FSfbSTyZDjOOPB2qn5pnRJL5woT5/x1HO42kCU8HbZ5G6ozWEKprQ41cF+fHyME/4vf/mLbKU/rQ7vr/2oFg+WT5nQ2n/a0qVMVRzqYxrL49Pq8CEtDMDpTGlxyiS8C/nNzc2//+1vo/rSw7pQiBaiZI1PuJGjwoS3Gd897TncLgQJh2mY0uKUaaU/5dsy3Zdu9EoFqqaoks3MN6VLxQkP7C7lCRd2KtEgb/efrNgBRnN2i9OU34dHXtRmdq9qar/NCh+FU/Mz3XXm0dj9Aonvw4Ov1KLvBDK9fsQbJuLs76Vf9q3VVDgxHMJKcTbyhIQDKEg4gGecJRwAFCQcwDMkHMAzJBzAMyQcwDNYnAA8g8UJwDNYnEZxdYuTPfQ9XST9umxmXCw4BYvTKK5rcZLLdlvIF0nuWA2zgZWAxWkUV7U4GT9kPlikbscMV1spWJwWZHEyK+F8keod44xZL1icFmVxau4B4RD1dJHaNcj3WsHipFiExak5atGSSRep2TFt9NWCxWmhFqeuHZIvUrdjZbmB9YDFaTkWJ7FWcKtLFynsSyfkawOL05IsTnIH6dLKIgU7NrsPwTNYnAA842zkCQkHUJBwAM84SzgAKEg4gGdIOIBnSDiAZ0g4gGewOAF4BosTgGewOI1iQotTvz2xOX58FCYGi9MoprI4dVvbbrdqBE03CGUGtzPwABanUUxpcapHuifW5iU8mAYsTleyOLUmi37taBQYLXV4OlicrmJx6reTGudNwmESsDgpLmNxkstRh8NZweJ0eYtT0OXe3qBUYXgOh2nA4nQNi5P+QD//h3MBngIWp+tYnOQH1lMH9TdMAxYnAM84G3lCwgEUJBzAM84SDgAKEg7gGRIO4BkSDuAZEg7gGSxOAJ7B4gTgGSxOo7i6xcke+p4uUjyobQZnES4IFqdRXNfiJOd2PyaeL1L4++Gke21gcRrFVS1Oamh8YZG6HctxebAisDgtyOJkVsL5ItVb1fmHNYHFaVEWp+Z2ZG/KKlK7BvleK1icFIuwODVHLVoy6SI1W6WNvlqwOC3U4tS1Q/JF6nasLDewHrA4Lcfi1HWfqyXyRQr70gn52sDitCSLk9xBurTqS/ao7U9zfV1gcQLwjLORJyQcQEHCATzjLOEAoCDhAJ4h4QCeIeEAniHhAJ7B4gTgGSxOAJ7B4jSK81qc1MK8WwpTgMVpFGe1OPGr4TA9WJxGcU6LEwmHM4DFaTYWJ9VKv/rzCDgBi9NcLE7hbqjNYQqwOCmuaXEKlyfiMAFYnGZjcQqXJ+EwAVic5mNxaveP3BymA4vTnCxOgz9qBDASLE4AnnE28oSEAyhIOIBnnCUcABQkHMAzJBzAMyQcwDMkHMAzWJwAPIPFCcAzWJxGcXWLkz30PV2keFDbDM4iXBAsTqO4rsVJjpPpfkw8X6Tw98NJ99rA4jSKq1qc1ND4wiJ1O2a42krB4rQgi5NZCeeLVO8YZ8x6weK0KItTcw+wN2UVqV2DfK8VLE6KRVicmqMWLZl0kZod00ZfLVicFmpx6toh+SJ1O1aWG1gPWJyWY3Hqus/VevkihX3phHxtYHFaksVJ7iBdWvUlu96x2X0InsHiBOAZZyNPSDiAgoQDeMZZwgFAQcIBPEPCATxDwgE8Q8IBPIPFCcAzWJxmQz+gjO/2YDKwOI1laBD3yZBwOANYnMYQFOCwG/+Kd0l6SThMBhancibxnJFwuChYnIotTrkh21IlIUajbrb7/U5sXCy23R+DHYWj3M3SAowDi1OxxSmZcD2aW21c7j9+xtY7CnRMRmkBRoPFSZGzOKUSHs7vVg9uH3bCLbdT6igARoPFqdziVKhU68JMwuH6YHEasjj1DWwtT6m6vvSold7840kJt0oLMBosTkMWJ5Hwqkr0qWV62sKES49atg43SwswEixOAJ5xNvKEhAMoSDiAZ5wlHAAUJBzAMyQcwDMkHMAzJBzAM1icADyDxWk24HiBM4DFaSwzsTjVZ0aPhDmoXzIPzls0jk6XX79zrxbmt0qXDBanMczI4tS+u247KjJbMH/n+LjfbrdblXBy7QMsTuXMyuJUL6OHxZya8HpYjEw1CXcDFqeFWpzapeXg0tMS3g57CxI+pycjOB0sTgu1OFmjyVPP4aFDI3z+js+F+pjafMlgcVIsx+IU3Sl2hxPqcLlcocIGlgUWp4VanOJ1ZcdbYcKDLnezVU7Clw0Wp4VanMIMC3WM8anA7EsPitueifDYYHlgcVqoxcnuoUh8Hx50GA4mXBwQ8V44WJwAPONs5AkJB1CQcADPOEs4AChIOIBnSDiAZ0g4gGdIOIBnsDgBeAaL02zA4gRnAIvTWK5vcRrwMQEIsDiNYUYWpyrzhvkUGwcnYHEqZ1YWp4qEQwlYnBZqcaqshMfHEpykoADWKQRfYHFaqMWpihJuHYtRYQe3SILtHCxOiuVYnKow4fax1HNl+QJx04Yh4L7B4rRQi1NlJDwZ1fpOmOqol5+CN7A4LcfiFNhmjFZ6dCzH/T7cl2qlR5+CN7A4LcfiNJBwu9/M7nXcRF1/5NspWJwAPONs5AkJB1CQcADPOEs4AChIOIBnSDiAZ0g4gGdIOIBnsDgBeAaL02zA4gRnAIvTWNZjcbJGpBzUT5QHJRgomH6tXy3MsJezgcVpDOuyOLWvx9sajMx2zIId99vtdqsSTq4vABanctZmcaqX1ONdTk14PfJGppqEXwYsTlicUjuRopj249MS3o6sCxJ+1mcMqMHihMUphTVgPfUcHmo6wufv+HSrj6nNzwYWJwUWJ0F0M6obASPr8GB/JZYcmBAsTlicrD5zu3iy460w4UGXu9kqJ+FnBIuTfG62AiYakfrrHvcWp3CmlMOM70sPzkh7ssPTBxODxSnVXScXWKfFKVHb29+HZwsmPtAdFvGfFSYGixOAZ5yNPCHhAAoSDuAZZwkHAAUJB/AMCQfwDAkH8AwJB/AMFicAz2BxOjM+R07x7eNiwOJUzkmFKU145v3cGTKYcGs0y3QGKF55LQeLUznlFVfRQI5TNz4HihJ+NgOUuGtO4t1xDRanckh4R1nCz2SAUmsv67xdASxOxRYn+2IaUjU1K8mZu51x3aeOVBTDON7DbrPdH5r5srFrjoaLhq2LGlANeo0bykFhor+CkcrN7qAHwk5lgCofFw9YnEZYnIKnx/6yzaqaTK+DDpnYqYxiUAzzeEX+62CGuzIOUH643Qa2ipSRKipML8kx82UNdp/IABVcEyQ8DxYnRc7ilKnDM5oHM+H9Wt0FnW2tyFnqeAO1YfT/5gH2R7/dH2uLRVxRFpzAXeYZWC7fZnwqAxR1+BiwOJVbnCZMeLOouZy9O/t4CxJuH6DO9sEST6WOqC/NNv01gVH4yQxQqpA8hw+Axanf/pDFacqEV8f9drvbbeW62YTbxzuUcPsA277p9ubXtdXTRqrELVKd13Thu7BOY4Cyn3fABItTqrtOLhD1dPWlGVI1RX1SGztMg61083gHE24eoE5mf4DduvEjcqpx1C1vPE/EhzOZAarfAPX3AFicrgbVD1wAZyNPlpPw+ZUIXELCr4DZrgU4B84SDgAKEg7gGRIO4BkSDuAZEg7gGSxOAJ7B4nRmwjfGfDCvbx8hAxanck4qTGnCM+/nzpDBhNeHc0WLU+o3V1NFige1XftymwgsTuWUV1zmkvnVl1UrFiX8ehYnOfe43+oxC3aR5I5dqaGwOJVDwjvKEn4ti9NROgQKi9TtOCm1WChYnLA4yWJUur0cBGkpFiezEs4Xqd6qw14TLE5YnDxanJrblL0pq0jtGs7yjcVpo8Hi5Mni1Jyu6C9hFanZqrc2OhYnLE7eLU5dOyRfJN2YWk6PyCBYnPrtY3FyYnE6tt3naol8kcK+dDchx+KU6q6TC2BxSjWOuuWN54n4cC5mcZI7sP+sYZHitr+T5joWp6uBxQkugLORJ8tJ+PxKBC4h4VcAixNcDGcJBwAFCQfwDAkH8AwJB/AMCQfwDBYnAM9gcToz4RtjPpjXt4+QAYtTOScVpjThmfdzZ8hgwuvDSSmTjDM5yuKkFp77uboyWJzKKa+4zCXzqy+rVixK+NksTrzwOwIsTuWQ8I6yhJ/J4kTCx4DFCYuTLEaVHVs2D4uTKuJy7opXAosTFqeFWZzC3VCbZ8HipMDitACLU7g8Ec+BxQmL09IsTuHyJDwHFqd++1icFmJx6o4j/ZQALVicUt11cgEsTqnGUbe88TwRH85kFqeujMR7CCxOV4P2JVwAZyNPlpPw+ZUIXELCrwAWJ7gYzhIOAAoSDuAZEg7gGRIO4BkSDuAZLE4AnsHidGZ8jn6a17ePkAGLUzknFaY04Zn3c2fIYMLrw7mixcl2BKSLFA9qu/blNhFYnMopr7jMJfOrL6tWLEr49SxOcrzNsf0x8XyRwt8PX87fYgAsTuWQ8I6yhF/L4nSUDoHCInU79jZcDYsTFidZjEo3gYOxZUuxOJmVcL5I9Y4d9ppgccLi5NHi1NwD7E1ZRWrXcJZvLE4bDRYnTxan5nRFfwmrSM2OvbXRsThhcfJuceraIfki6cbUcnpEBsHi1G8fi5MTi9Ox7T5X6+WLFPaluwk5FqdUd51cIOrp6kuDxWmOFie5A/vPGhYp2HHcz7pUsDhdDSxOcAGcjTxZTsLnVyJwCQm/Alic4GI4SzgAKEg4gGdIOIBnSDiAZ0g4gGewOAF4BovTeUgOeuo/5tsyuABYnMrJvEJrLkvC4fpgcSpHFeZpph8SDhcCi1M50e2GhMPsweJ0msVJt8LjkgRDuJXmqbQ8CdeQMRcgBRan0yxOMltWSVTCbc1TojyGREluLPIuAeTA4qQotDjFD+FhSWwNS06Z0pTHbDX0n0feJYAsWJxOsziJjJslmSzh3fIJ7xJAFixOJ1qc+tlmSQoSniqPJVGqjknvEkAOLE7jLE7hmp2sLChJSR1ulseWKOW9SwBJsDgBeMbZyBMSDqAg4QCecZZwAFCQcADPkHAAz5BwAM+QcADPYHEC8AwWp/OA4wXmARancuZvcapLqPerfyE4OJnR4Dp9jtWPc+qFeWt2IWBxKmf+Fqf2dffg53pP/NXuZrSL+fPFsBSwOJUzf4tTvVndfjg14e2AVRK+bLA4ebI4SWNEvNiYhLej4IKEz+NxCUaAxcmTxUmrMOr/TT2Hh2KN8Pk7PkHqY2rzhYDFSbFwi1PYytjsDifU4YHLxsoyDfbFgMXJk8UpdlfIjrfChAdd7marnIQvBixOsnt86RanMMNNWE/sSw+K0J6esJQwa7A4ebI42d0Wie/Dg6/UBhMuika8lwMWJwDPOBt5QsIBFCQcwDPOEg4AChIO4BkSDuAZEg7gGRIO4BksTgCeweJ0Jk4aPq5ehbVW531wGAkWp1GYI7pTS/YDtBMv3kaQcJgaLE7lyGEqx/02XxCVcCVRKDoAEg7TgMWpGHNEdhI74cXFJ+EwDVicyi1OqQpYeySaVcyEB4WPBrOpEWliVKs9JKy85LBesDiVW5y6TIWDPVUWrYQb+SxNeGb7Y0oOawWLkyJrcdI7jW8R6p92K90SuWUTntr+SSWHFYLFqdziJGmTOjbh3b+envATSw7rAotTscVJdZ+rylRteEQdLt0rJa30YPtDJQfA4jTG4qRKE3yH15Rvb9fhAr3hoPxmT5u9/YKSA2Bxmhi+zYKZ4WzkCQkHUJDwSSHhMDOcJRwAFCQcwDMkHMAzJBzAMyQcwDNYnAA8g8XpTGBxglmAxWkUy7U41WdSr9xvzTjP0eg1fczyHflRxwiXBYtTOYu2OLVv5tsj4cb+tHjzc+byuMj1PMHiVMyyLU71nvUvj5+a8PpMBHcuEj5PsDitxOLUblqOoz0t4e2dLmybzOVJChRYnFZicdKWjFAvoZ/DQ+dG+Pxt6m36j6nN5wQWJ4Vfi1O4v83ucEIdLpdLtMxpsM8LLE4rsTjFWgvZ8VaY8KDL3WyVk/B5gcVJtoGt24QTi1P4URPWE/vSg+Nq96//RDAHsDitxOJk92gkvg8Pmg2DCReFJN4zA4vTpNBEhZnhbOQJCQdQkPBJIeEwM5wlHAAUJBzAMyQcwDMkHMAzJBzAM1icADyDxQnAM1icBhiQGU3GhJal7hPrzVpeLF0ZWJwKOcmsOOJNm6ksS/34GDk2hTdxVgsWp0IukvCJLEvR6iR8vWBxKnQhxUGKVwxKJJrG3ZDwZEN/OsuS+ADLEmBxKnQhBUGyVjRiGNyPBswx4Vj2UyxL/bLmzrAsrQ0sToq0C0kHyV6xnisDFFiPMt1c01iWgg+svdFgXxdYnApdSFHCkzGRveIJ70JCYfhky1L8UbwjEr4usDgVupDiVnq04nG/D10rqpUefZo+0pMtS0I1JRrkWJbWCxanQhdS8nF3o6JubUs34hOPyJNZluz+PCxLawWLE4BnnI08IeEAChIO4BlnCQcABQkH8AwJB/AMCQfwDAkH8AwWJwDPYHEC8MzMLU6xqujyb10Gb4yeUhD5AuoQzSGLpeVo1vCE1NKIfPH0K+4D49TBGTO3OBkysotfmBMkPLBJDC9rJPLkhLeriB8eP/EwYIHM3OIUjqnWV6u8uNVAs812f+h+nVuO3Yjny60GCzeel2BcybDpJTCqqEhFObWGuASfxQk373D2R4fdZrPd9iNWxVL5Aevgg5lbnGyngr5EdSCMKi1UKOlIxrVidzvY9rvqCxOOIbXXzSQ842vpttneiSLnTKYGthLe3KL6NoTy12RuF+CFmVucjGrGrHnCS1hfw9v9MTlfXuXd43L45Cr3HA3JDNa1WuRq3kCTvfu4C+PJCe+aIP0u1c5NXRX4YuYWp3wdbo2a1g6V/l+J+UbVHmQqLEwgYonWjQSMVRhqY4FwL/IpZLc/rZUuuveChFOHr4iZW5yChHeZ6prDsvsorsPFPxLzbanSmITbtbH+VQKj2tYLhB/oO5FYrjzhZg9cc7fgOXw9zNziZPelq5j2pJ63U8/nZrs3evINC5N5Dk92Dii7i7VAuBej187uS4/6C9Phj3snk8uDH2ZucbKdpuGn2/0+qMObOZu4XR7Or4KLflTCrXVlkc3Gh7lAsJf4+XqqhKttUH/7x5nFKe8y5ZKG1eFu5AkJBxCQcADPuEs4AAhIOIBnSDiAZ0g4gGdIOIBnsDgBeAaLE4BnZm5xCt6ivsJL1Mab8WcphfV9/UH9fnhQgoGCaXGUWpiXAtbEzC1O8e+HX2uoRPTrwkWU/15a+/vHwRvpY38/vN/adrtVCSfX62TmFqfoyr7aTwxeJOGH436rx5WdlPDjfrvdH2WqSfhqmbnFKb6yxRzDGVp/qgZrZudX1kgrsbBK27ChTZcoND1kHaftcR33W2loOCHhdb51qnNiOHDNzC1OmYQf9zt5/cox4+0aw/NlCsSWjbGjQZCsFY0YBvejTLr6j/uMp57D1WaCgvXbMett3UgA/8zc4mQmvL9Co1oxWF6F1phvDz83s6iDZK9oO6fkfSXdzSWXbDM+vg4P9mftjAb7upi5xSm6srvrU/YV6/pvXMKNq70s4cmYyF5xuw2SGvsWCKJEx1thwi1zk+GxIOErYuYWp7gvXcgNlb4lbOGWze/b61VVHXbmbaLbd+hvClc87vfqsV9vyvg0faRdWE/sSw/OUHtk+hTCGpi5xUlXSurS7D/a7naqDt/FHWqp+ZnuuvAcGB1a0ebsLj7diE/0diVqe/v78OArtcGEi30T75XhzOKUquuu9iUbwHVxNvKEhAMoSDiAZ5wlHAAUJBzAMyQcwDMkHMAzJBzAMyQcwDMkHMAzJBzAMyQcwDMkHMAzJBzAMyQcwDMkHMAzJBzAMyQcwDMkHMAzJBzAMyQcwDP/D+atNxkaeAtAAAAAAElFTkSuQmCC" alt="" />

当然这么多都是分版本表示,其实这么多文件就取三个文件就可以了,一个SqlMapper.cs,一个是Database.cs,再加一个扩展属性的类IgnorePropertyAttribute.cs。我用的是.Net4.0 所以我取的 4.0下面的文件,放入我的工程修改其命名空间为我的即可。

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAP8AAABhCAIAAACWBuCuAAAKzUlEQVR4nO2dQYvcRhbH+5M02GCDmYZstjWXOYVE6+S0hj2PDxs5mUAgx3wAHxs0E3JYGJwdY/CAl4UhgRE5xMEZ0ofQ49MkJzEXK3bwIXNok4H2ssvbQ7VKr15VSWpJ3dWW3p/HMFOqKpWmf/X0qlql6r18+fvLl7/v3nv8p3f/Tmz33mNoj+LQ6wVR+XRW+9XrDP0sFhXTz+qumH5Wd4Xof+9DYkw/q91i+lndlUv6t/Y2S9pSm8HqrBzTPyshpp+1JDVM//n5efnM9eiPQ6+H5HzKXrTHC2OUFgVpgqG1UdCjwhcRh55SncyunoJVQ03SP5lMNjY2jIe+/uXFW49+vfLw+VuPfv36lxciUdIfHR/7vu/7fnR8PJvNfN+XP/Ppz2iJAtc9IA69XhAECpwq/ZbmRYHhSBx6nufJyuJQ/h4Fa9DVW6LG6J9MJtevX+/3+8ajVx4+H/3024/xi9FPv115+FwkCvoF+hcXF7PZLHn2zFdVln5TwmolTo8wher0x6HnhbGlNH853ZiaoX8ymVy7dq3f79voN0rQ7/v+09NTHOpU8f0kBQUaaR5xNAs3itIBxybYB88z0wAkPXscerKSavQL9nFpNUsUcPTTjBqgH6Of4/uxiUQj/dV9f5YSh0FKRxYniA6RlihOx4yhmj1bhJW1J+PfFvcrFRD6s3pkaXKpTH9Tyuh/+70PiZWhn6CfT/9sNtPpv39wgCOfer4/o0Lz/iS/ArQhXRuTemGc68LxoZT/xX0/zse+f9mqRf/5+fnGxkZflTFnDv2yA/i+/8OTJwvN+VAfmrlKnbrF6TcgVpL+lP9gUfrJ1FDaeZXGcNzfmOr6/pLKiXzqzHiqcz4pIIgVFITjeLxMujK3EgXGLmRvjwS54pyP4Tq0sQSrrlZEv1FNzvcrQGSHvCBQfH+gD25t6TlDZ+PVmMchlvl+Mi1aSD+ugP1+Y3JM/wqfdODVLSwql/SvVkw/iwrTHxBj+lntVnfoZ7GomH5Wd4Xo9wNiTD+r3WL6Wd0V08/qrtzQP5lMGqxtPB5vb2+LZyUePHjQYM2sdssN/Tdu3GiqA4zHY/lA6Gg0aqTO5UpdAsByKDf09/v9wWDQSAeQXh+jb78DKE8cuJnmZ/rXRs7oj6KosAMY10MS6Y5/NBr5vm+pEj0FvVIK+Tu1dZQz+gGgsAMY10MS4aUwo9FIoF+K/pU+Lsn0r6Nc0g8Au7u7g8FgOp1Wrso3aXt725LdSL++XhGvbSELaiusgfSyaMsLY6Uj6AVNj5ayliOX9E8mk8FgEEXWj9i4KgBrZ2fHSP94PLZUaYx8yHpFvFagqTWQZM2xvSDfJFYoTP8dYkulvxB9sKwIk8Lo37p1S3p9O/qgjnp1ZAFAj4caWQNpot9cUKTysHgVckZ/IfqQSz9Gf5GJTiXyQYn59BsXly+0BtJCvxXy2PBuLFbTckP/1atXC9GH3Min6hx/Cfr1yAevz6q4BtIW+WgF4zAsXkfGakZu6C+Dfr6qfr1Vhn7IG/VWXQOZLfPVXv5AqjMOq1nLkBv630yxM26bmP7yYvrbpoz+P/t3iDH9qpj+tonpZ3VXTD+ru0L0/+UOMaaf1W4x/azuiulndVdu6G92ZSOLVU1u6G9wZeNiMj9YNj9kesZYF895tkdu6G9wZaOU/pxzcRlEPKFfeXmy8lp+pr89wvR/RMz5ykajbHwz/axF5Yx+KLGy0ah69NOghiOfLssl/VBpZSPhm/xSRD/dAYt9f5flkv4yy7t01fL9xgechVT6LcAz/a2SM/qroQ816dfmfPBj9Rz5dE3O6K+Gfo4aHPXSPUTZ97dUbugvubJx2SKvN0Eve1DXbTH9LZUb+tcBfSA+XtJPFpsz/e2VG/pdyvhOE8jopxuICuBlKX7NQovUPfpZrFRMP6u7YvpZ3RWi/+ZHxHbvPR7uAxtbW43pZ+uuYfo/Jsb0s7XbmH627lpG//Dmx8SWR3/wjfsrZ2NzQ//lf+p2gEI10s4xwF3XnxDb8swN/QDw6nVxB7ABLfTl919s7W0KOxh/BQBbe5vyZ04HkJtbjE8KGiDpP5wCABwemaqawm3XnyJbNXNG/+ffFXQAMO3ZKA8J9P/2z78ejL/68vsvvv05kj1BmI3+MYL+cFrg2jH9yRSSM+Xo7TMApv9NNmf0D/cLOgCY9myUh7b2Nm/+493Lyz/wzaHY9x9BsgismP7xGSRqIHQ4hcMzpv8NNpf0D/dh/ym8eg3v3DfnsUXzAvHPHn1K0F/U95P0TCnQCv0ncDdB7v8EYAq3TxD9R5BoMZUoqMdatnTcEnmuLLPW00jm+e0IAHjEUsJc0h98A69ew+ffWfPoOxfJQxV9/z4MTwxw4C5xN7HSL8rSlDTzYZKiqWbLzlUifYxGF/NTkMxqs5Vg7IjendjyzRn9+egPEf141zp56LNHn+K4/9+n/zLeJWw295EJDPcVgsmflH4xADhDedSyuuuVBYdaPYb0E3IRc7hJZr2d0sStQB+dsxnN5ZxPDvrDIvovL/8QHUCYoH/RZsxd/iL0i6OHMgSSmY8gkZ4Y+eCF6TeNIsrTL/NzHyhjbuj/7/8K0B/mRj7D3FFBnh1BkmR/yjCDTATl0Z/61yxo0W4C4g6QRTjpGcukkxjM0IWOIDE2+wyGR3Cojiuc47Xm5ob+QvSHlfkuMhycZHygkANP4xjpv32WgavE/elLiZJE9f1JVrkMym3pOUNnnGHu11FmUcNd+XdS6r/RcXND/1qbPaKoYDYfzL55HQzTv0OM6a9vTP86G9OvGdPfGWP62bpriP73d4gx/WzttgL6zTMvLFYrxPSzuiumn9Vd1aW/zt5b5KnMHKt8ChYrR3Xpr7P74tbe5qyEmH7WklSX/jq7L9ajn2wx4fzVyqI96ktus9dBG1qr76ShXEQcekp1Mrt98xlaTX6TtG0K1uG/uFo1QH+Zzef0NYqA6I+Oj8V+E9Hx8Ww2831f/synH79/3PVnF4deLwgC8l5oTL+lefSl0Wltnuf10JYCvewF64b8OFW+Zj2/SfjE5kpbrwbohxK7L+prFCGlX6B/cXExm82SZ8/I/itl6TclrFbi9AhTqE6/2FbDUtpUlXk/svwmyRNHQVdfzN4M/VBp90VBv+/7T09PcahTxfeTFBRo4DAgiMzhgSkdcCyBffA8M+UlPXscerKSavSnKGel6U6TOqxG553fJFGr2jc6pox+7/0dYuXpL9yCTn9SHyz0V/f9WUocBmgLrl4WBvQMt3pbOmYM1WyNjrP2ZLDZ4n6lAkJ/Vo8sTS7VRL/squaqTE1KS3SWfZX+T4iVpL/M7ov6Ki1I6b9/cIAjn3q+X9lmV2WN5FeANqRrY1IvjHNdOD6Uwra478f5FvH96lWjO6C9SfNauxv3NEJ/md0Xc+iXHcD3/R+ePFlozof60MxV6tQtTr81kjZeonpIwBYsSr9pr1QV2RLjG3n/ym+SPDEOjLqluvSX3H0xJ/KpM+OpzvmgTxXH6drNv1y6EklHgbEL2dsjQa4452O4Dj1wV06m/C+MERNpEp3z6WAHqEt/nd0Xm5zvV4DIDnlBoPj+QB/c2tJzhs7GqzGPQyzz/WQOspB+XIE5Mz6BvbXKlwhaPNW5EKgu/XW02icdbOA6nihlOZRL+lcrpp9FxfQz/d0Vov+DT4i1i34Wi+r/TR0xCd6nO64AAAAASUVORK5CYII=" alt="" /> aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAATkAAACLCAIAAACV9nlsAAAOiUlEQVR4nO2dzYsbRxqH+y8R2OCAsWBsq33xaWMrTk4b2LOHzaaTOEsgx/wBcxT0OOSwYJJ1CHjAYcE44GYPScgO6YORc5r1SfgS+ePmg0wMyrJL7aGl6req3qpuqaXqD/0eXsJMq7pUM+lnqtRS/RyE7/xV1uGXPwgAQCMJ4CoArQCuAtAO4CoA7cCrq5dvXipZWx0GAG3Et6vzEnTN1UkcBmE8cT0cJT4HBFpJEL7zsaw1XH3y5En5xtVcncRhQKj38lYH4zBRwFWwGSq5Oh6Pz507xz50//HzvbtPT915tnf36f3Hz7OD0tXkwYPhcDgcDpMHD+bz+XA4lP91u5pf00lUq6/KYJKoylDgKijF+q6Ox+M33nij1+uxj56682z08MXPk+ejhy9O3XmWHcxczUR9+fLlfD6f/vrrUKWsq9wBjxh/OOAq2DJrujoej8+cOdPr9WyusmSuDofDXx49oovedeZV7QhZky7bZI8mUdnjYjFZK6ta0lhZxtLBqGtccyR52yQKwjiOrE9hH488nETyRDKdk6Ogq6zjKhXVMa/Syg6yrq4/r+ZHJnG0vFLzCziTZnlG8XF6vZOew4Bb4NLXq9QSbiSKq3QU2YmO8ZCul8dpZ2EYZg2g6i6wsquaqG5X5/O56erXt2/TNXC1edUxn2ntFf2Y43QOyxW0LVBV/8w/IXQk2rya/znIXeXHw87k+eNhPEmiMJ6ovwfQVVZz9cmTJ+fOneupsC0drkpdh8Phv376aaX7wIoU8mqexKGcgvJWq7vKXPDFriq2siPZmKuyvWppAlV3gqrv2dhwrIGrvGej3gcmL9zoiz+61qWvKQuOKxNkEnHCqwtXeTw/zI6khKu28ShrYNJzGOZ/B+RKGHSbIHz7Y1nN/iyE4y3N/KEwipR5NTJv2diOO25Q0QbWyVCuUPWRlJlX2fFw95aUZ1OGBDqOb1c9fsawzPIVgNbg1VW/wFXQKeAqAO2gw64C0CngKgDtAK4C0A6C8O0bsuAqAI0lGLx9QxZcBaCxeHJ1PB5vsLc0Ta9fv559SvGbb77ZYM8ANBZPrp49e3ZTuqZpKjfljEajjfS5XfDRIrAJPLna6/X6/f5GdJUzKhXVPrsqn0ys521VuAo2gT9XkyQp1JVNftEwJ9XRaDQcDi1dkv1iXp3BJy7AhvHnqhCiUFc2+UWDbkwfjUaZqKVc9bonG66CDePVVSHE4eFhv9+fzWZrdzXkuH79uqU566qZzMLuaFk77SVUQiOMHDVtpxCzvQcAA6+ujsfjfr+fJNYLkt31Srlx4wbrapqmli7ZNbCWzMKnpVRLe9GyoOwnYgIG5fDnaqGowpImIaGivvvuu3JGtYsqLMFIxrZ1PvesStoL5yp/YnYUN59AAV7vA7tFFU5XqairvFXDZhEVurpSugrXp81Vq5LZ3xQYC6wEg2s3ZG3P1dOnTxeKKpxr4HXfUy3hqjUtpULai3UNbJw4iWM2gwIAFU+ulhHVzboffijjqnDdW1ov7UU20e4tcfeR2JtXAGh4crWdYKIDDSIYXPtIFlxVgaugQcBVB3AVNAi4CkA7gKsAtAO4CkA7gKsAtAO4CkA78OTqZjNcANhBPLm6wQyX1eA/Lr94iNuVZoJ3bUAj8OTqBjNcJObOuOJziJ+aq8o/uqz8y3BwFTQCf66WyXBhsdkIV8FO4c9VUSLDhaWaq/ryFmtg0FKCi9c+ktXMDBfNRu2LIleTSN39hnkVtBSvrpaJhjCpNK+yW+IyVFctesJV0BSCi9c+lFV7hgtLJVeN+8B02yjWwKBF+HN1PVEdbPDekrJQxrwKGklw8a0PZdWe4bJttABSEnCoZj7AVdA8PLnaBFGFNn9KV7XIMrgKGoknV+uETR0VuavqneKlnvIsRAuCZrADrgLQCeAqAO0ArgLQDnRXB7cECoVqYMFVFKodBVdRqHYUXEWh2lGeXI2+q/9HRaFaXZ5cff2fqroW4u1XdjQT6XH9/+dQu1bBxbc+kLU9V4UQr34v1tWmX8YXP35++ealrG6nXwkhLt+8JP9r0/VI3Sp7UPlngauoWsqfq599X6CrEOL+4+d7d5+euvNs7+7T+4+fS/2kqH/6+x9vp1998ePn//x3Ir3NyuFqrtaxEKLAtEIV4SqqlvLn6uBWga5CiFN3no0evvh58nz08EX2byXLhy7fvHTtb1dev/6NTpIl51VFrXti6pxd4SqqmeXV1cEtcesX8ep38Yev+Ta2V6GZkJ/e/UQTdeV5VTtyT0yXvWVHUtn7TOxzDeTpqXGcbbx/wiy/5bnTE2bA2qNsD6gdLK+uRt+JV7+Lz763tjl15xmtrcyr5MjRVOxnB49zE2h7W4NcG3rcbMzN4akQR/esY0s1gYtWAajdKX+uukUdEFfn87np6qd3P6GvV//x6Ft2BjaLdVXaYs5aWvvCBvRbs3E2ScqnyzSmKGYeL+dzUnoPqF2t4OLwA1nbvg/sEHVQ5Orr179lumaVuVrmqXVXj5X17UIVMn1pK2RXA/qtpbFss/CNs5EZG/dTwNgdL0+u/vd/BaIOnGvggfPVrLvM+8CLK56Ikc2Huor2BmK66DA/zja+J46O9WGk5NXswTRfKmejoo8enfA9oHazPLlaKOqggo3uUt5fVWct+dB0ms+Ei3XsTOxbGhzNRDrNuzxw9nYgWy71Zm5BEVfpo9YeUDtZwYXhB7LweWAUqrEFV1GodhRcRaHaUXAVhWpHwVUUqh0FV1GodlRwYRjJgqsoVGMLrqJQ7ShPriLDBYWqWJ5c7VKGy44W+XAVPu1YS3lyVdSU4SI3vni+tugHG5t2WdPPM69QcLXu8udqXRkuB1N+S/dWK992Rz/r6+V5Cyy6J6YzZhtQusoOgZVchdibKn+uDmrKcKnZVb8DKBRj/0RMT8TB1LoFF642try6Oqgjw0VTRSakHJ3k227S7FshhOAbC3U/zSLDhZyuncu66jiR799YQrNPJPvMN//MRDojPwjZr7cY2DE3BrWHfW3Axg5efYR01+7yaz0TB/k1Fcqrq7VkuFBXUzU2SbmAspdw6lZS5XJnM1wsmSzsGtg8sbh/ctz2RKbnixOXP10+i6qKslEy2tfC0M86Qs5VrUPk11Qpf67WleGSu6qlLtgvXDbAgeqhbV6nyClUwl+dJfuX39qfyLaaTckfnQPtV6F+7XBVS34rTMZwuYr8mmoVXLgayepkhssGXWXuglpSV+gamB50u8reZc1dtTyRI/xpeiL2T/K7vqkuCxcHt1VXkV9ToTy5WmOGS8k1sO6quUYlL/m015B6JksZV539Mxkx9ieyuZrd8k1nJLNGXVLKDtdwlRkhWe3zmTjIr6lWnlytK8NFf3+VJKTo95YMVwfOez/5s1gyhAtddfXPZcQ4wor1n5e8UlW+Vt9WlUfoWVqEjXVe5UYof9u2TBzk11Sp4MLV92Xt1ueB3Uuy+mqDc0gt71ehtlS75erRzHIbtkm1MVdxH7VbtVuu0lVWM0UdbMjVbPWI13hdqh1zFYVqbcFVFKodFZy/+r6swy9/4O/GAgDqBq4C0A7gKgDtwJOr4/F4Sz0DsCN4cvXs2bNd1zWJgjCe1D0K0F08udrr9fr9fkVdCzNcLCRRsCBKqjy/G7gKtos/V5MkKdTVzHCRlMlw4UiiXNFJHG7P1pVcncQhHdVW/4iAjuDPVSFEoa5mhoukzF5zhkkceprt4CrYLl5dFUIcHh72+/3ZbOZub1Imw4WDzqv0YBjHi6VxbtgkDvXVciYSs4o22ip9kqfMzyUtl4RhmH+djSN/dDkwMgb9r4HemPkJQFfw6up4PO73+0livYrM/auSNedVIa9neu0mkTwwiUN5nUdLE3LBs4t/ea48zsyFbJ9JRP1Su+XmVTo5y+PqGNRnVOTFDN1pgvNX/iJrq64Wiiq4XAhJYYaLm8WEs7iSNSUcM6t2+ctvsz8A1BSuT31drOjHuErn4Hy2tCjILLrNUYHu4M/VQlGF01U2w2VF5LzGeTWJQ3mZ53bYXM2/DfIptIyr+VqVd5URrbyr5qhAd/Dk6unTpwtFFc418Joot37l1V3g1SQOlTUwtWo5L8a6aexcbayBjT8Gxho41zKJuL8X6gJbnhjHE25UoDt4crWMqFuCLGttLwv1+zJhFCnzasS8QWvcbrKtq817S2RU+YzuuDtkc5U2NhbRMLVzeHK1tWCCAk0BrrqBq6ApwFU3cBU0BbgKQDuAqwC0A7gKQDuAqwC0A7gKQDvw5GrXQyEA2DqeXG1JhksS7eIbNHhfqh0E56+8J2vnM1w0V8nHAxt0LdMPTW5kZHC1HfhztQ0ZLsRVsh01+7bWfSv2HAltnAXnrtcANIJg78p7snY+w0W6yqZJ1Igz86XANbjaEby6KpqS4SL0bd15foqxv811Itm+FoRxslicRkneislh4XfcaMtZGs4S588YxhNGLXJE7y1Rz10tp4YdG3fMzJ3hf2MImqmCV1cbleGiXGhlXbVlspAwpOzp9J2nliwYPjjGCGcpyFIjcROWGJr83PI5NWxjPrzGzJ2x/Mb4HkApgr0335O1Kxkumor5t0WuWjNZ6APs1658CWYu1J+90NXyMTTlc2rYxkZMDJ87Y/uNcT2AcvhztUEZLoWu2mS1ZrKs6yobHLOqq8qTOGNoVsqp4RvnbRYPurNWETSzOTy52rwMFzWYRXdVOZo9srww2UyWUq4yWTB8cIwRzlJwH3jZhT2GxsyuKM6pYRvz4TVG7gyCZraAJ1cbluFi3LsxXFXbuPN+Rdl5lcmCYYNjmHAWkvOivr9qrMnN3thzS+TU8L0x96DMm0UImtkCnlxtNO5V3GbAHAKqAlfhKmgHcBWugnYAVwFoB3AVgHYQ7L35Z1lwFYDGAlcBaAdwFYB2sLKrVfaLaztjHLX2UwDQVVZ2tUoay+Wbl+Yl6Jqr9EM8lofxdg4o5P/XZ0AUKwULFwAAAABJRU5ErkJggg==" alt="" />

这个时候我们就可以测试了

Dapper使用
 class Program
{
static string _strConn = "Data Source=192.168.11.128;Initial Catalog=PD_ShopDB;uid=sa;password=123;";
static string _strSQL = "SELECT BrandID,BrandName,IsEnable,BrandEnName,BigLogo,SmllLogo,BrandStory,BrandLink,IsDelete,CreateDate FROM Brands WITH(NOLOCK)"; static void Main(string[] args)
{
using (SqlConnection connection = new SqlConnection(_strConn))
{
connection.Open();
var brand = connection.Query<Brands>(_strSQL).ToList();
foreach (var item in brand)
{
Console.Write(item.BrandID + " " + item.BrandName);
}
} Console.ReadKey();
}
}
Dapper使用

测试结果

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAACRCAIAAAAn2xZNAAAgAElEQVR4nO2995vc1mGvf/Zv+95YpERqJVKyJdnJTXFs2cm9T2Jb1SqWRNmmJPre3NiSrE5KFDu319md3jsw6L0DAwym97LP9wfMzM4uixodJhu8z/vwwWAAzNlZfs45KOcsMKrdOF2JEqUgavhhZTcv7WaFnQzvSbOeNLuT4Xez/G5O2M2Ju1lhJ8vvZHhPht/J8DsZbifL7eYEHyQHC2oIM8KYEcb0CG5EMCOKGTHSTNClFFNOc5UMX80J9ZzYyAr1FFtOUKUYbkQxLYyqoYIchMQgLIYKUqigRFAljKoRVI2gahRTo9h4OVyQw4gSQdUopkUxLY7rccJIkMUEZSUpK0FZCcpMUGbSkbaSdClJl1JMKcXYKcZOT3ReJmkrQZoJohjHjRiux3AthmvRieNlTItgWgRTY7gWJ4oJyk6x5Sxfy4tNSG7Bag/R+4g+RIwhYgxRY4gaQ6Q4Qot7SHEPKe7BxljI2IP0ffP6aGpO2zc7Y2bGtKM6SqujlDpKqaPkVGWUUEZJZbwwVp5RGcWnyqO4PIodNCqPotIoKg2j4jAqDiPiMCwOw8IwxA+D/CDI94NcP8D1AmzXz3Z9TNfHdBy9VHt339Yu2dolWztka4dsTvU4EjPiTQ/eOOQ23tjCGltY3XETva21qRtI9bCFyvqd3ShUpltuotUtrLaN1z14c4do7lItL93xM10/2w1y/SA/CPHDkDAMC8OwOIyIo4g4ikj3WvE/wvCMABZrMcoO42YA0XzQOOHbKXYrSW8m6K0kvZ1itlPsdordStGbCWozQW3Eya0EuZWkt5O0J814s7wfkoIFNYyoYUQNIUqoIEdQNYbrcaKYoq0Ma2f5cl6oQmI9L9ayXCXNWEmyGCe0GK5GETlSkMIFMVwQIwUxUpAco4h8qzFUiWNqAteShJ6kimnazDClLFvKMlbmgGaaMTO06bxM72umGDNFm0nSSBBaHFdjmBJDlSg68ymoMqPzoWqCMFK0mWHLOaEKiY2C0kK0Lqb3MaOPF4dYcYibQ9wc4eYIN/dwcw8z9zBzDzX3UHMPMfcQc69Q3CsUR/saI3giNOOBKsBRu31dkLlVdVwX7NcI2iilHawXDunUETP1QlwexaWhY1QcRMV+ROxHhF6Y74a4bojththucGKA6czYnupnWvvSY31000c3fVTTRzZ9ZGPqriOx787trR8Qrx206sFu7w5WHW/jLBD1XaLhIxt+qhmgWwGmE2K7Ya4b4XtRoR8VBzFxGJfGdaJTUd5j5f8I4zOCKGlFCCuIGoGC6stLO1nek2a3U7QT5s04OQ32RoxYi2KrEXQtgq5H8c04sZkgPEl6N8P58kIQlsMFJVyQQ+PESjFUSeBaiixmGCvH2ZBQRaQaItUgoZxj7QxjpikjRWpJXI1jcgyRYoh4QFSKoVIclePY2ASmJHElSWgpSs9QRpYx82wJ4suQUIZ4G+LtPGfnuVKes/KslWOtHGvmWCvLmlnGdP7N0GaGLmYoI03qSUJNYEoclWKodOhz49PPReU4JidwNU0ZWcbK82VIrCFyE1NbuNElin2i2CfNAWkOSWtIWSPKGpHWHmXtkaU9srRHWnv42BFuOVXACJ0RmVo84K0VwYG6QN83P7NwuHaY1BFZ/YAZ/fYVxNSUOkopo5QyTCqDpDJIyv2E2I+L/bjYiwndWaN8Z1+uE+U6Ea4THts+INsOs62xTCvMtEJMc9YgfdgAdauNGeuH9JO1OxlwpGrOlkGqEaSbYaYZZlsRrhPlOzGhGxd7CamflPtJZZBShmllXFfe5rv67qp/cWerexDGimGsGER0P6R48+Ik5Mw42HFyI0ZsxIj1GL4WxVbDyEoYXgkX1iPoZozYTpKeFO3NcAFICCNyBJHDiByGxTAsRApiHJWTuJom9SxThDgLFiqoXEPlGiJVCkIZ4kp51szRRobUUoSSxOQkJiUxKYmJCUxMoOLkpZTE5CQup3A5RSgZUs3Qeo428mwR4kxYKCFiGZEqiFhGhHJBKBcEGxZKMF+CeAvi9s1zZp41c0wxxxRztJGhtAyppnB55nMnn+WIyylcSRFqmlAzpJ5jihBXgsUKItcwtUnobbLYpcwebQ5oa0CXho5MaUSX9pjSHm3v0fYeXdqjJjqZJ609YuIk/+Nm/1bRg30BpHjAwlRjDzb2CsZ4YVboruZn1fduqR2GOXWYVQcZZZBRBmm5n5L7KbmXlGYUu1MTQmdqXOjEhfYB+QPG+HaMa80aHducGmG/hkxjX7oevrMRun5gY7YZ45pxvhUX2kmhk5S6KbmXlvsZZZBRB1l1mNOGOW2U00d5fS+vH/yu7on6X9zcRBBE9BBqBBHVDyu+vLSbE3ay/LbTmCfpQ834WhRdDSNrYXQjRmwnyZ00482ygbwQKkgRVIlhagxVoogURcQ4KiVxJU2qWUrPs8UCb6FSGVdquFrH5RomVRDRRvgSzBUhtpij9SypZkk1QyoZQk7jYzOEnCHkLKlkSTVLqXlayzM6xBZhvojwFiLamFTB5Qqu1HC5hskVTK5gUgWTyqhoo6KNiDYi2IhQQoRSgbcmmjBbhBgjT+s5Ss2Syvj4hOKUwfmsHK3laD3P6HnGgFmzwJdQsYLJNVxrkHqTLrZpq8tafdbqs6UBZw85e8iVh1x5xJf3uPIeV9njynuso73H2JPY23u0vUdNHDf4h5ypC/DbiTneoWrAzD20eEDkazipMkYFYyxsjGB9BOlDSB/mtUFeG+TVfk7tZ5XeITNy95BpuZuWO2OlTlrqpMVOWuykxE5KbN/WpKPQTgqtsfytNg+ZOCTXiN/VhONk95TYSovtjNzJyt2c0sur/bzah7QBrA9hfQgbw4IxKhRHX+cL/E/otBlwQq4HES1QUP2Q7MtL3ry4kxUurfg/ubzyyeXlTy4tf3xp6eNLSx9/ufjRlwsfXVz4+MvFTy4tfXp5+bMrq+evrl5bD0QQOUEYSdJIEloSV5K44rS6OdrJpImJNiFXKK1O6XVKrRNqlZAruFTGxBIqWAhvFlgDZnWY0SFay9MqRKt5WoUoFaJUiNFgRodZo8AVEd5EBQsTS7hsE3KFVKqUVqO0OqXVKbVGqVVSrRJKlVAqhFwm5DIuOdozljDBQgUT4c0CXyxwRoE1CqwBswbMGgXWKHAGwpsIbyK8hQoWKpQwycblCqHWKL1BGy222GbNDmf1eLvHlwa8PRDsoVAeCeWRUBkJ1T2hMpZ3LI/dj/0k+bf1UEVAHeoOTCoC4mt42zri9lXGuNYYYbMnFMURWhw5VxYRY1DQB7Deh/U+rPVgrQfNqs7azTsqB8wp3Zzczcmdg7anZh2lr7Q1NSPeajMt3NGM0MyIzYzYyorOEdo5uZ1XupDahdUerPcKeh8xBogxQItD1Bw5Xwhufq1v8htr/sV1Kn0QQo0wVgyhRhDVgwUtUFADsOKDlOsLK+k8ms4jt4hmIDQDoctbweXNwPJm4MurNz0JIk1bWdbK0maWNrK0nqMNiDGuvzQHAAAvX/7gBDj2OUnr9dXX5sBvIrQ2CaRcJqbB402ELyKcUWB1J/AwoxUYvcDpCFdEeRMVLFwq4ZJNyGVSrdJajdZqjN5wpPU6rdWdlZRWpdSq8xGkWiGVCqmUSblCymVSLhNymZBtXCrhYgkTS5hgYU6YxRLuKJWcGsGpKUi1Smk1Wm8wRpMttjmzw1kdrtTlSz2+1BfsvmAPhPJQKA+FylCsjMTKSJiRL+/LOdojdmrwD3Pg3Io9YibSU0v7UjOSt9UaEdaInJFwNCdah8WnmlOHs2LmECsO0eIQLQ5QY4DoAwRafgA89i40zvkB1e4hIbULqZ0DKp38rHInL7fvYMsxJ90q9+8nwF+d56ZrslLzgOJdlZrb50+BEzc9UjMvtfJyG1I6kNqB1W5B6yJ6H9H7qDHAigO8uP9V3Ok7/Paiq8fA4x8gM7+gv4y4OQIRwowQpQhhRXAzjJlhrBjCikHU2PWHur1ep/sVdns9jzewFUdyXDnP2xBXgrgSxFkwbyEbZ+bAmQW5TCrEhyfB8S9o1miuvT4HXouxRoM16oxep/UarVUppULKZUK2CamEixYmWJhQRPkiyhfefwg88CmCSyVCskm5vPybOfCbMK3VGL3O6vX4xVPg5M1E4eZDYJbfrRoNVq87MnqdmSyzeo3e/d0c+O2KFvn1HADgt8uT6oBSq87BqUn1QWs1Wq8xep3RG6zR5IotzmzzVocvddbPzIH5paTdF+y+aA/SVx8D4LHzxFCqjqTqSAr/YQ48dp4cidWRWL192vcDH/zDHDi3Oht7e8TaI8Yerb45N/2RXgzcJu1jrRFl3XE9eciD9cLhGsHRfw6Ac4vj/4hjjn0pY8UBWlh5ADz2PtxH9N5htaldR1jrwlrngGoHVjtwbvF74PS7uQ6sdGClfUjokPKtcn86Ab53gYPklmP+kFIzLzWvvgLAK7G81Nw5f2ryQ5z6Y7qZl5o7F06BEws7zu5KC1basNouaB1E76J6DzOcmyYDwhwQ5pCwhrf99sKXHwfzq+E71blfKbp6HDz+IXrLL2jf3AvgFt7I3Xn7OwridDlOV2J0OUY52lHKjlJ2IBghKPn3H3vPfrr71vmdt7/wnLu0jWFc2S5JoiiJom2XPlhKfbCU8ngDniQBi7WCWC1IVUSsIGIZlcrBC4+AE9ciapXSaoze4IpN3mytvzEHXo/zZoszW1yxyRWbrNFwokhrVVp1mtwyKduEbBNbb86BM0tymVLKtFpl8tceBI98DNU5o8EVm1wx9vIceMnX4pGFh8CjnxZavNnizRbvOzsHwINfsuOXZosvtrhiizObnMl+8jB48EuGK8acTgZ4LcoaDce11+fAa1G22GSLTW6ss2OLNzs8uvgQOPUp2hXsnhh8ew68vVnui+WBVB5s/XYOAPBKaBzyzLXHwSOraSfwlZFUGc0273zlYM6Df5gD59bKI3aqPWJt9ZNHAJhfjTnNeyn367lzK+NWfUhNpJ1L+qURdTD/k+og9yIALwa+qgtwWPXDeXD8kkqiq8cBeMHvNAjKnx8+t2gO8MLKMfDY+4U+ZvRRvXcnEb2HaN3CncwvPQBOv5vvFLROQT3suCK4Xf4P2po6Tfu+mZvfA6f+lGnuXjgFwO+vyU1IbkKZm997NQbJzd0Lp8CJhV25BcvOEdoFtYNoHVTvYnoPM3p4cRryAemE/JY6NHL5cTC/GrlttXtvDZwD4Nzyd9gLJLlaiq8nuVqSqyXZWmKiPxAiae3pPyz/7P8t/fP7N//3x9f/9cJVCKLLJXM25B9vJDzegDdNI0oDlRuoXMeUGqbUCKUW/uJRcPJGdNIM8mZbLHU2z8yBNxKi1RGsjmC1BastmO1p5ieBrzFajVarK7+ZA78JM3qNNeqsUU98eQqcvJE0W7zZEsy24H9rDpzdsNoitngCnPoM7YilsVLgrTlw6jzalUpdqbS/frwl0hGt5Mtz4GW/829btDrCtGyTjYUDdkVs6QQ4/RnWk8o9CV8+AcArwYFUGUqV7Ktzj514BIDfZuXqSK6qFx4dL0sTxerhPrwwzfkk5NxMzuNXHwfzq/HyiLVHTGksPU71RHOi83Iab2vayR+H/Pbt/52ctjD+cwCcWxq3BkPSGhLmEEdWjoHH/lwYOM0dZvRmPRj1riNyq9DSA+D0e/kOonUQrYOot7Ggdgpqe1/lK5zNPKy0vBdOgRMLXrl17VUAXo3DTp4njt9VWoWxbURtj0NudJ2QT2+OUpObo1TpwAlU9PLjYH41enDlX8TAOQCmVfy32QvMXJZopGbc3vGRtPbyha2fv3/9r//9syf/9Ocn//xHCKLLJUsURVEUbLt0IRi6lPJ6vAFfhkHVBqo0MaWBq3VcrS+9tt/VfMnHfjoPHrrMS3Z36805cCYp2V3J7qYvn572oz5D24LFfzoPHvySHbeiRuylOfDSboMrNnizyZvcp/PgwUssb7UEqy1YrUl90RaxhRPg1Hms4xxWKnflcurVOfDQFVEOvj0H3t4q9+RyTy73MldPg/nFtN2V7NQrc+CVQFcKvj0HTp/HelK5t/XmHHgz5WwpBd+e/gAvB7rizEswv5QuS+cfAQ9dkaXKUA6dm5tfyYTPzc2vZKojuZp7dQ68Eh43404jPz5OyIl37uU58NKb5+YAAPOrCSfk09YbPPYxpn7yCDh+RWXHzbijk/BB+NJj0wMe+1Iki33SlD+cB8curb447dv7naxOObdsjShL/XB++iM4TVDuRQBePHNuZs2kF2o5/Ulw/JIybsqsIWEOicLqMfDYBxffmRzonYVJ1Bde3/+853adkCefA+C5i0sP7K/vonoXPRRyx/zidDNwctGvdRC1jajtG7+Zrjz77EnwwOdcQeXeHS+0C2rb9/l+b/zdrBNa7t0T4IEL3Djt4NS72dtUAe++OtnvN/FxyLXk8/s/xDtLZp+0BpT/HADnPrw8/drPrdgj2h5FrzwO5lejs9dQnJUTjl9RJ+tz01/N8TPnjoPHP8JGNLY6XiiN6JL60cyv5nDFcWvIZ365xy+r0wp9zJlc9PJ+McCZHHCuSabFVvrgZUkn5Kff/vj47//95P/5v4/86Z3TH/zeaclFUXBa8huFjSV82eMN+Mchr6NKHVNquFIn1Hrk4ilw8ma82ORN/rN58NCVAyFPX5nmrZu+cho8vJgq8Z/NgwcvcYLVFsxW8tIp8PDNpNkSrJZgtcVJuy1YLcHc76ILZktAFh4Cpz5DO5OE9+Sy+Pkj4MRVSQ69Mwfe2aoM5ErfSf4rgZ60H/JJtueXM5XB9m/nwJsZuTJw9tos96Rxz/ytTbsrYksPgVOfYV3R7kl2L331MTC/ki4P0lcfB29mJWL1hHNaHjo3B97ZrAzFynDzt3NgfiXlXJMLnpsDj32KD3k79/IcAPOrCXvE2SMueG4OvLNqK5/MA/BGli2NWDv30hz4dWDEOtl2tIaU2Q9/+RgAby3oHVzv4NDiMQCe3+nghvDBwwCA0x8iA9IcLL0BwPxqxBqSVvYFAF7wD0lrSFrKh/Pg+CWFNGeWrewLAID51bDlbHNwF3NI+s45/62XrCFhDklzQBRWjwEAHl4JFgdEMfM8AMcuSuOEP7wUdJr03bcBOP0+3MMMJzNv39S7qN4NXDwNwOn3oXHI3893Ua2Lah1U66D5xQcAeG6ng2odVOPfPwnAb5KI1vF/fhqAU+/l2ojaRjxnAQAPfM4hKvfeSWfBqQLO3lDbiNouTFvm7bMAnL0+eXndCfOr8ekGvgunAAAPXOAmG596L9dG1cRzABz7gseMLm70Fl8H4OHlsDkg/e8AAMCZ7H4a51ejtwt59Mrj0yqAxlaPO90oe38X2h6tnAHgUMidKuBM7uu25OjqcfD4R+iB5ZUztxzhQEsuNtO3u+vghPyht//fw//2h0ffe/uxj373xIXXnZZ82l1HdRTVUY834M3QiFxH5Toi1VCpikoVXK6EP38UnLwRM5pckbulJRfOPwIO8tZmqSM6HXirLVjTwDvtdttptwWzxRebXLGRuHgKnLyRMOqcUefgGw+BRz9FWmKpLdkdyR635K+E+nKlL5edhPfkSVylUlcspV6ZAy8HupLddfreD12VpyGfbX6dJuJTpCM45+RIRyh1RbsrYssnwNubtvTZI+DlwEAsy85C+spj4ExGtAeCnXl5DrwcGPD2gLcHfEn+9BHw4BWZK2VemgMvBQZsacBaA9b/zhw4fXwegDcytDWgrQFtZX49B45fVpzW25EyB0RR+PPD4IHPWVRpIkoTUZo3fjMHXo2hKv/nk+CBiwJu9AijR3jfBuDtxWKPKKZeAOAFb48o9gh46dih7/v1NFFMvwDAC96+c/JJmH3C+w4A7ywW+3ix73RZiWJ/0WmiX88QxQFRGHfXieIAL/YXXgfg9TRmpJ4H4Pndab9dfP9hcOyiOFnfxcZd9+RzTmPuhBzaD3ngi9Pg5GLACbzWQXfeAuCtmxo/DTOitmeyPV1IPAvAs572ZIP2fqpnIl1QWgUl/iwAAIBntychP7Hgm3nrWU8L8ZwF4OxNrYPpHdzo4oWlY+D0B0if9L0DwLnl0vBAeG4TcvWj+dnWexK8/TBPw38w5F/ZGz+4wYFWGgDgVCWBcXW8cvuQ840U30hy9UM6IZ//47nTfz77/U/efPLz1/768ksQRNsz5+S9bqfX7Xi8gd0UCUs1WKzAQhkW7AJvoaLtXHiL6nXWYD59GDz4Jbd/Tl7iP5sHD13mxVJHtNpOtnmrvX+p7NC1NDP+8hx4yeectNcYjfzoJDj+OUGrFUop07mrD4JHPoEbvNkUrJZodcTgW3PgrWkvXSr3JLu75VQTVpu3WrwVf3kOvORvC1ZbLHXTVx4D4PSJR8A45G/OgTfTkt0TSh3eanNmmzNbHLLwEHj040J7co1d+HQevBRIvjz31nqpy5e6ycunwRvJtTNzL/k7nNXhrORLc+DX/i5rdlmry1rCx/Pg+JcCY6V+PQde9PVos0ebXco7ORE4uRg2uqTRJYu95TfmwMPLEWtAmX1HstjDdP79k+B752lYrEFiFRKr116ZAy+HYYl+9wT43ucsqrZRtT1JSAfVks+Nm8c2ml94AJx6P99GtTY6zZKWfA6A53c7k/Pnzs3XAHgtieqdsVoX1TuY3sWgpWMAPL/bw+GlY+Cx96HxCfnCawC8nsKM9GzIUV18/yR44KKI6qnnpl30O4Tc6av7vzg97qI77rwFwFs3DoZ8ppc+XRiHfObUfRLa7XG8D/fSwdlryqFz8sn2nrMAnL2hdVCtg+ldDJ4N+TvLkwsf0/Dc45DfctP0biG/07WAwLn9Dv9syBNsJU7PyDhWnZA/9uHvfnD+jR9efPV/Xn3x728+C0F0yZqEvFRqNhvVSsXjDewkyTxfyfN2nrMg1syzRZgrBj6bBw9dCSsVSqM/fhg8+CUjmK2NN+bA63HBbKcunQbg0U8LLa7Y4rxnH/ySYQ3mk4fB8Ys0Y9TXXp8Dr0WcO22sUY9ffBScvB7Ta7RapZQyufXmHHhjQbRw0cRFE09fPg4e/ihXYfUaV2wkLp0CALzs74iljuh/aw68tWF1BHThIfDoJ4UWW3SupcdemgO/3nWu+bcFi//M6Vm8mZbKfTH4zhwALwe6nNlmCwsPvhZljAYD33gQPPoR3GCNFltsscX22utzxx8+BU4uxIptxmgx3rNzJ08dB49+CDUovUHpjeXX5gD43ZLepPQmuXt2Djz6AdQi9fgLc+CFnTaut3C9he+cnQO/X1DZP58EAPx+QW1hWtvpioOTiyGjhxs93Eg9P/fWDaXlPf8oAPP/nihnWTsbv/xXAPxipZTl8D8+BP7qMwoS65BYhzd/B8Dvrkl1WIo+A8Azm3VYqsMS/acTAJy4vivVYalx7ZVH303XYTn6DADPbDVguQHLDThz43vg0Xcz45eFrd+DV2Ow3CrILSS78AA49X6ug+SdfPZQo4cavZuvAfB6CjV6N193uuU91OihTncd6jkhByeXAnoX0bs3XgMAvH1jeuEN6k5uto1PyB/4nEfUDqLy7znddbXj+/w0AG9ddy7COd31C9z0lLugtK+/CgA4e11pF5S278LZd7PtaYCdYF97FTyzdfB628wCLLdgJf4MAM9sT1r73yQQtTOu7x5eChZ7uPcdAMDxSzJpDSkr63StqduFLXr5cXCgI+1c9VQ/mt/vS4+76+hsr3u2u65+dGY1Otshv313feZUfH41WhqtnJlsMN14NuRh3AzjZmRfK0JYEcLa3vXDCPvWwtW3ly6fW7n4f9Y+/7eN88kkPA15ybLqtapt2x5vYDuBO0PBsrSRofQspeUobfeTh8GDlwKSTcj4hyfB8S8odpze8V2r1enFuRNXI0qFUvAPT4Jj5zFCDr4wB17YLlNKhVIqzm32Yxdw5wkWTDBvvjwHXtopsHqB1QqMVohfPNgX/e2KXmeNBldsst6zc+B3q0YjfvEUOHk9qjnVRIVSQi/OgRe2K7RWZfQGV2zx6OJDAIA3kkKpKzjN8pjfrWjOYzb0hyed0l6P6nVKb1A7v5sD4NgXNKHUcKWKy+Hn5wB46IpfLGNiGRXLqIi/d2Jaqvn30hVUqqJS+Lk58NxWrSDVCmIV3vztHHjzqliBBOJPDwEAwDObtYLcQBTu/ZP75wvv5Vqw1MjzlUsv7Z9K/MuiniCNJFn4twfB//gITbN2mimlV88AcOYSU0oxpUu/djY8c4kppZnALyY7/o+PsQxrZ9jgLwH45Vo5w5UzXHnrk0fAg1e3uPHLLFfZ/mT/nOqZzQYkNeHswgPg9Ht5J5y9m68B8FoK1XuoLr63X9rT70POzfPUswA8+9rb0/Xv5qe30GY4ueTTOoWdt/bX/CY5uaPGvzs97Imzz5wA37vAwQr37nihDSvta9PrZ6/Gp2/N3E7j/rT/KxjfS9u9cAqcuLnr3FeTY88A8MxWE5JbcHbhezOlCujdySWGd56fXlac3BsPH+w2H7+sUqXR8pn9Nfs3L2evk50559y8mN7FoCZXQPf3OvDW7W6hjTvnAEw3m/mIyedOjnkmB/yw4oeVAKwGCmoQUQOIFkS0IKJvenyDQb9eK9er5Xq13KjXG/Vqo1bptFvdTrvZbNRqtUqlXKmUPd7AVgxN02aaKqZJLU2oKVxOE3KO0mDWGD+FKtmkXKaU/SdPKKVCKuVJbi1MMFHeRPkiwhvo+utz4PUFwRw/i5a6dAw8/F7SRMfPw+0+Mwd+tazkKTlPyjlSypMSTCsIa6C8iUslQrZJpUypVWr/QRdyXE04T7Y6D7qJpXHBlCqt153GmTPbnNXmrA5nthmjRekNUquRSpVUnKdlx+JKFZermFxBpTIq2IhQgnkL5iyILeYZI08beVrPjTXGOmNjWDPPWnmulI73HHQAAB8fSURBVOdKObaUZa0MY2ZoM00XJ1oZ1s5x5bxQhaQ6LDVguVlQWrDczAm1DGsnKTNOGDFci2JqFFUiiBJF1SimxXA9RugxXI9iWhRVx2JTNccYpsfwiYQRI4wYUYwRRpyA/3AM/H8fwM7KOFlMkMUEaSYpK0WX0kw5w1Vz07H0ShvWOpP73pNnYPTJv3oP0XsFrVfQUs8C8OxOb3qHHL7LEzJ3vkM+eTAm8QwA37vA3eEJGef2+ML3wKk/ZW55QkZqfoVyKz9zm3165xzRuuju285NBLw4IIoDwrz9szFf18A5J5l32+abP+7yFQ/D7GS4nQy3mxV2c4I3L3rzsg+SfbD8xZUFjzdwq7v+kC8Y2fUFp2u+uHxjI4omqWKS1JOEmsSVJCalcSlDKjlag1hj8sC5tf8AuVgaP7XOFWHWgBgNcp5Xp+Q8mfnjcfBXH2adJ9ghWrv26znw4g5EaxCt5kl5+4MT4IHPtnAhjfFplE+jXAbjs4SUpxSY0ZDZ59slGxdtXLSxzTNz4I2bzkPyXBHmijBnwJwBs3qBL6JiCZfLpFan9SatN2mjRRstWm+RWoNQnSa6go+HvlTQ8Yg3Z3SNBXFmnjGytJ4h1TShpHA5gUoJVEwgQgIR4o6omEDFBCrFMSmByUlcTRJaktAmA9rVGKpMYilHUTWG6wmymGJKGbac4apZoZYXG1mhlmbLCcqKEUYEVcOIEoKlACQE8kIAEgKQGISlACT684Ivx3uznDfDeTOsL8v6sqw3y/lyjrw/L0wU/ZDohyQ/JAVgKXDtFQBe+QSSApAUgKUgLIVgOVRQIogWxY0YYSaoUpIpp7laVmjk5RYkdyDVeeS7C6vOY6298cJESE0+A8AzHuf51lkPP+t6y+Ouk4dbt86CVxPO8s6FUwCc+mPmTs+6tnJS68orALwS/zbPuk6eeM1KzZzUzMstSG5DSgdWu4WdtwF4+4beR40+Wjz0uOvXetZ18Q3wgt9ZVj+YB2B+NXT3Xe7tk63IKthKkFsJajtJb6fZnQy3k+F3svxuVliPk9c86aue5FVP8ponec2TuuZJ39jN3PBmF7z5xQC0EiqsRbD1KLoewYKQGCf0OK7FUTmOynFETKBiClcypJKjNIgxYLZY4E2EtxDBcoZ/FHjTiXeOUrKElMGFNCakUT6F8CmUT6NCGhMyuJjBJccsLmVwKY2JaUxIoXwS4ZMIl0TYRIFNImwKFbKElKMUiNEhRofZIsybBW78QQXehJ3ahDUgRs/Tep7WcpSWo7Q8o8OciQg2LlcJtU6odVJrkHqT1JuE2sDkGipXEamMSGVELCNiuSCUYb4EcVaeNXOMkaF0Z5xsHBFiBT4Kc+E8E8oxoRwdytKhLB3K0cEcHcoxoTwbyrMhiHPG4UYQKQyLIVgMQUIA4gN5PpDn/Xk+AAkhWA4j6n602HKaq6bZaoK2Y4QZRvVQQQlAki8veHP8bpZz3MlwO2nWk6S3EuRmDN+I4RsxbCOGb8bwzTi+mSC2EsRWgtxKUttJypnwYzvFeFKMJ83sHJbdzbDeLO/NCv68FITVMKpHCDNG2QmmmuYbWbGVkzs52Rl5Mjs0pX9wpErqVwD8ytPLq7282tsfpnJbD49dGY9auTLtjYNT/57+TmNX7jJwZTx2Rdgfu5KT2jm5AyldyPM2AG9f0/sFfYAYA9QYfvOxK7n92+/za8H/8IErYD2KrUexjTi5laC2U4wnze6kOU+a82R4T4b3ZPmdibs5wZeTfJAUgNUgqocxI0ZacbIUI4ox3IiOO5ByFJWiiBhDxAQmJ3ElTWoZatxxzbPFPFvM03qe1rO0liXVNC4lUT5eYKMQHc3T0TwVyZGRPBnN01GIjsJsDGbjMBuHuXhhbAxmHaPwZC+IiRe4BCKkcCmNy5nxcFF9LO0saBlSddrbNC5PRpLLKVzJUnqONWHeLogVRKqicg1VGqhSRyb3CyC+DPF2nrfzvJ1jS1naTFPFJKkncDWGStGCGIa4YI72ZyhfithNYjtx1BNHPHHEE0M8ccQTxzxxzJPAdpL4bpLcTVPeDO3NMLtpZjdN76RpT5LeHmeP2k7SnjS7mxV8kOwvqEHMCONWlLSjpB3CzQCi+2B1Ny/tZAVPmt9KsZtJeiNBb8Sp9Ti5FiVWwthSsLDgy9/05RwX/LkFX37RDy8F4KVgYSlYWAoiSyFkOYQuh7GVMLYawdeiEyP4WgRfi+LrMXIjTm0m6K0U68mKXkjxI3oQM8OkHaNrSb6RFNtpsZ0WZ0eY9jJyLyv3nYVZ0+PBp9203E1LUzuz3mUU6rcei3p4IOpdx6I6Q1Cno1CTQjMttu8yEPW/0ChUsBZG1yLoRozYTJDbKWY7zXhSrCfNemaivpPhd5z+fE705SU/rAQLWhAzIrgZJcwIXoxgRgTVIuO52ZQIIsUQOY4pCVxJEmqK1JyoZyg9Q+rj8/ZJAxiB2FCOCmbIQIYIpHF/CvOnsECGCGbIUJYK5WjHcJ6ZkQ3lJg1mjg7l6AjERQt8DBHGXWJMSeLqrAlMiWNywpnsBZViiBBDhGhBiCFSAleTpJFhzBxXynFlSKhAYg0SazmhkuPKGa6U4UoZtpRhSmnaStFmgjTiuBbF1AgiByHBn+O8GXonSXqS+FYc3YgU1sPQWghaC+VXQ/nVkLMMr4UL6xFkPYptxrDNOLmZIDfj5EacXI8R6zFiLUqsRrDVCLYaJdfj5EaS2UzxW1nRk1e8sO5DTD9a9Bb0HUjdzslbGWE9ya8ludU4vRKlliPkUoRYCmMLQeS6D7q6k720lfpyM+F4aTN5aSt5eSt12ZO+4sle3cld3c1d3c1f8+aveaHrPviGv3DTjyz4kYXgxBC6FMKWIsRShFyN0etJfisjeyDVixT9WClEViJ0Pca14rwzIUQ3IfSSYi8h9hLi/sKscaE7sTPjbWaViE3lDs8qcevEEt94Vom7TiwROTSxBNuMcs0414rz7YTQTordlNRLy72M0s+og6w6mM4qkftLzCpxT2ePAGsRdD2KbcSJSUvOjROecRpwYScr7OScM3bJm5d8kOyHlQCiOWNUI7gZnk7hiGkRVI0gagRRoqgSw9Q4piUILUnoSVJPEXqK1JOEniS0BK7GMSWGSJGCEMoz/gzlS+HeFO5N4t4k5k3i3iTuSxH+DOXPUIEMFcjSgRwbzLOhPBvMs8E8G4I4ZyGYY4MQGx53gyVnHrgYpsQxJeaIKpOJ3BRnFrfxlHKwGIKEMCxGUSWO60mqmKKtNGtn2HKGr2b5WoarpNlyiik7c0ImKStOWTHSjOJGGNVDiBKAJV9e9GZYT4reSpAbMXw9gq6GkZUgvBKElgKO+WVnIQivhJCVMLoawVejxGqMWI2Rq1FiJYIvh/GlML4UxhdD+GIYX4qQKzF6Jc6uJYWNtLSZU7chfRvSt3LaRkbZSIurSWE1wS/H2aUYsxSlFsLUQpi4EcKvBZDLu9DFrcyF9cT51ZjjZyuxz1Zj59fin28kvthIfbGZ/mIrfXE78+V29pInf3kHuuKFr/qQa37kegC5HkCvB9DrAexGAL8RJG6GycUIvRLn19LyZk7bhoo7SMmHVwJULUQ3w2wrzHYiXCfCdSN8LyL0okIvyveifC/Cd2cN788J1Qmzs7ZvNcS2xt46RdTBWaICt58i6u6zRN1xiqjxRFGTKaKcWaJCk1miolwnJnTiYi8h9pNSPykPUspwOktU5i8xS9S9mwoKbMTwjTix6STcmZs1K+zmxN285M1LXkjyQpIPkn2w4ocVP6z6C6of0UOoEcKKYdyM4NbkJpwRwYsRvBjBjShuxHBjcp3WiBNGwrlgSxgJQo8TesyZCxVRQrAYyLG+DL2bIndT5E6ScNxNkbtp2pumfRnGn2P9OTaQ5/cvMjnC438DkDPTqxwuKBFnRldUi6Lj6Vadq8oRVIugWhhRwwUlVFBCBSUIywFYCsBSqKBGMD1KmHHKStB2kqmk2GqKqyaZSpKpxOnKeHAeWYoSVoQwx7NlFTQvpOzmRE9W2Epxm0lmzQltGFsOIotBZDFYWAhMDCKLQWwxhC6FieUouRKllqO042KUXIiQC2FqIUzeDJELIepmhFqIMktRbikurCSl1Yy6ntXXc/paVltJqyspeTkpLSXEhbiwEONvRrkbEeZ6iLkWpK74iYs7hQubuU9Xkx8vxz5ajn20FP1wKfrRUvSj5fgnK4lP15KfrafOb6TPb6QvbGY+385d3IG/3Clc9mFX/MQVP3ElQFwJEFcD5NUgdS1EXwszN6LsYlxcSSlrWX0jb24WSh60soPXvGTDT7X8dDvAdAJMN8B0A2w3wHaDbC/A9AJsd7xyop/p7Eu3/XTbN7Z1QKrlo1peqjmWbHrJxqxfb9bHu0/5WNu5w5SPHqy6g1f3NyPqu0TdSzZ8VDPATKZ85LsRoRcV+1FxEJPGUz7+ReZ7vHdTPoLtFLOdYjwZdjcrOJfW/bDiL6j+ghpAtACiBRB9PHsMaoTQYhArhnAzjFsRohQlSxGyFCGtCFGa3mCPkmaUsKKEGSWtGGnFKCtOWXHSihNWnDDjhBkjilG8GMWNCKYFx9eQ+N0st5vhdjPsTprdSXO7Wc6b5X053pcXnIvAQUgKwHIQVoIFNYiowYJzq08LImoQUYOoFkK1EKaPuxW4EcadjkZxsmyEMD2E6UFUC6J6EJ3uqwVRI4SbYaIUJe0YXYnRlThbT7C1OFOLMbUYU43S1QhVCZPlEGEHcTuAWQHU9CGGt6B5IM2TU7Yz0mZaWE/xqwluNcasRKmlKLUUIRfDxGKYWIxQSxFqMUovRZnlGLuc4FYS/EpCWE7wSwl+KcYvxvjFGHczxt+I8Tej/M2YcDMuLMTFhYS8lFSX09pKtriaK65kjeWMvpjWFpPaQkJdSKg3E8qNuHw9Jl2PCtcj/OUge9FHXPAgn6znPlpNf7ia+nAl+cFy4oPlxIcrqY9W05+spz/ZyH66kftsM39+C7rggS/uYl/6iEtB+kqIuRLiroT5q2H+aoS/FuGvRYXrUfF6XLqZUJbS2kquuAaVNuDyJlrdxuoevOkhmh6yvUN1dunuLt3bpbtepuel+7tUb5fu7lDdHaoz1UO29yVaMzYPize3D9g45Ba+P3/zHaZwrn3rKZw3ZqZw3kSqm2htC6t78IYHb+6QLS/V9jEdP9v7D5q/+R5Nzwx286I3J/ogOVBQg4gWQo1xK40Vw7gZJpzoOmEuRUg7QtpRquwYoyoxqhKjyjG6HKXLUcqOUeUoaUcpOzYxTpfjTDlOlWJUKU7ZjjHSjpKlKG45rWKgoPhg2QfLvv2Og+yHlcB+RaMFED2IGkG0GMIcrRBmhp2JLnBrrFNUohQm7AhhR4hShLAjZCkyfmlHCDuEl8ZiVhCzgpgVwu0QYUeocoSqRulajK3H2Waca8a4RpRtRJl6lKlH6FqYroWoapCsBoiKDy97UXsXKe0i1g5c9MDGdl7bzGkbWWUtLa+lpNWkuJoUV5LiSkJcSYorSWk1Ka2klJW0sppWVtPqakZbzWjLGW05pS2l1KWkupBUFpLqRG0hqS+kjMWMuZS1lvP2St5eytpL2dJixlrMWIuZ4kK6uJAuLqSMhZR+I6ldT6hXY/KlEP+FjzrvwT/dRj7Zgj/egD5az3+0nv94A/p4A/50s/DZFnLeg1zwYJ978M+95MUAcynMX4mK1+LytbhyPa5cT6jXE+qNhHYjod1IajdT+kLGXMyVlvP2ClxZQ2rrSH0DbW5irS28vU10PGTXQ/Y81AG3ya7jFtGZuom398Vam1hrY2zzgGhzHW2uo411tLGOONZnXdu3tobUVpHaauG2Vh1X4MphofLyXZ1uuVqorCHVdaS2gdQ3seY23vKQbQ/V3aF7XqbnY/s+buDnBwF+GBCGQWH0n1PgtGwhzAjjZoSwYqQdJe0oXY7R5ThdidPVOFONs9U4W02w1fFoc66+L1uPM7U4U40xVacZjNGVKF2O0uUYU44xlThTTTDV+NhanKnGaMdKjCpHyXKYKIVxK4gVD2oGcStEWCHCCuFWiCiFiFKIsMNEOUyWw2Q5QlYiZCVCVcJkJUJVIlQ1SlWjVDVCVSN0NUpXo3QtSteidH0sU48wtShdi9D1CFWPUNUwXQtT1TBVm53KM8o2o9z42k+Ua0e5dmQ8i3AzxDRDdCNENwJUPUDW/WTdT9R9RM1LVHfx6g5a8SBlT8HehktbcGkTMjfz5oYjZG7krQ3I2oBKm7C94VgobxTsddheh+012F7L26t5eyVvL+fKy3l7KW8v58vL+fJyvroMVVfgmuMyVF2GqktQdQmqOC7mK4v58mKuvJCzb2Ssawn9clS+GBK+CLCf+5gLPur8Lnl+l7zgpS546c999Bc+5qKfvRjgLgaFL0Pi5ahyLaHfSJs3M6Wb2dJC1l7IOZYXcuXFXHkxX16CqstwbaVQX0Uaa2hzHWut4+0NvLNJdDaJ7hbR3SJ6W2Rvm+xvk/0tsrdF9jaJ7gbR2SA663h71jWstS/aXEObq2MbB0Qaq0hjBamPLRx22RGuOS7BtSXoVquzLuYrh3R+xts63WYpX5n58etraGMDb24SrS2is012PVRvl+572YGPHfq4oY8b+fi/gNx3FUTJUpQsxSg7RpXjTCXBVBNsTba7enVfo9ozqj2j1tNrPcOxur+gV3t6patVulq5o5U76kE1561KV6t09YNq5fEuWrmjldtaua3ZE8vtmbcmhxrbPez+R/RuVa/09eq+mmOlr1UmC9W+Vh046rWBXh1otYnVfdXqQK0M1MpAqQyUSl8pj5XLfdnuOUq2M461K5burN0TSz2x1BMm8vt2p3KlLlfq8aUeV+pxpT5f6nOlPjd+eVjW0eoyZocutiijRepNUmuQWp3Q6oRaJ7S6s0xqDedBAEpvUkaLLraZYoexuqzVZUtddnqoiZOP6HOlPl8aOBNXzirYQ748FOyhUB4K9nD/rdKALw240oAbl/xWDxb+NnbHWreROaR5Wzt3kS627yRTbDNme3Zj50Mnv5Q+70zsZw/E8kAqD6XK0JkCSHas3msr30mQYKsJpppgqkm2lmTrSa6ulLsffXH9yZ8+++RPn33y6WefevrZp55+7qmf7fvDfZ9/6mfPPfn0s0/+9JknfvKrH/zjL3/w419+/8e/ePwf/vX7//Cv3//xL37wj7984ie/fOInv3rip89Mj/bk08+OD/7TZ5786TNP3NUn971jeWaK9Py39+eOL3wNnz/g/kGe++HPDhfsuxby57MFe/4r/NlzTz39nPPFPvGTXz3xk1898ZNf/uAfxz7hOF7/q8l3++xTTz/71LRUdzz4gW/gR1P/6YUf/dOLjn/t+M+u/+kESa6eZOtJtpbk6imunuLrRrX35E+fAd8Zv9//3Q9y3z/CxeW/PM68bknWmeOtnmTrerX7xE9+dU8O/pUh9H8V9/b4d1np4nJkidPlGStxuqJVuj/4x19+i0N9ZWJvzdWhjN395W0/8etvMBvyr38EF5f/8oQJM0yYYdz51wrjlmq3Hv/7f/kWh/qagfkuIf/61cddPssNuct/LwIFNQCr/oIznlwLIrpSap762/813eBbRPfrb/YtQv5Nt7+1Crh7veDictTYzfA72el4cskLyZJZf/Rvfu68+41i8JXN7K1H+0Ybg3vXvXez7fLfiK0EtZmgtlK0J816MtxOlpeKtfkfPv3d27qvs+M3De29CvnXLJ6Ly1FgPYqvx/CNOLmVpLdTzHaaFY3qw0/91Hn324V8utc9D+3Xb/m/csvvXou5uPzXYC2Crkew8XjyJLOdZgWjcvKpnzjvfqMM3Clp0+Xb7vL1X36L7W991420y3871iPoehTfiBGbCWo7zXjSnGhUvmNLPt0XfFW0vmkb++1Cfpeqx8Xl6LMRIzbixGaS2k6zzuxuUrE2/6OfOe9+uzwcasDvcoS/dEt+l093o+7y3wVnyqedLOcMOPVDimw1Hv2bf3Le/UZJuLX5nb68S9K+/kvwTVr+r1lyN+ouRx9vXvTmRR+k+AtqENGDmKGUWo/93f++S36+DrfG+7YH+Uu05LdG/dCP8F1+LheX/3qEUCOIGiGsGCGsKGnHqLJW7nz/x7/46j3vwK0t6p3e/aYZvu1n3X3lbZfvUjwXlyNIjCpHqXKcHo8kT3J1vdp74puPQrtthxncNUV3CflX7nunIwA35C4uh0iNR5g20kIzLbYyYtuoDZ762XP35ODfKOHfdIPpZrdyp3fvstLF5ciSlTsZqZN1lLtZpVesD3748xfud7lcXFzuEXm1n1N6eaWXV/p5tZ9T+8XG8Ef/5IbcxeWoAGkDx/zYodkY/fU/vfjVe7q4uPyXANaGsDaEZjQbo7/+ZzfkLi5HBeevt0FT3ZC7uBwxDoTcbcldXI4eBWNY0IfwjFbTDbmLyxHCCbmjE3K3JXdxOVIcSrgbcheXo8Y05AW3u+7iciSZDXnBDbmLy9GjYAxnhQ035C4uR4vbh9x94s3F5chQKA4Lxf2EOyH/kRtyF5cjw2y8YWMA6wOrOfyROwrNxeXIUNAHBX1Q0Puw1oe0PqT2zcbghz9//n6Xy8XF5R4BqT3HvNrLK92c3C3W+08+/ez9LpeLi8s9Iie3c3I7K7WzYisrNjNC06j1nvhWf7rYxcXlPyMZoZERGmm+nuLqKa6WZKt6ufPt/nSxi4vLf0YStB2n7Thlx0grSlgR3FTt1qn/+c/3u1wuLi73iChuhDEjjBkhVA8iaqCgyGZ9/oc/vd/lcnFxuUcEYDkASf686M8J3hy/m+Uko3LiiR/f73K5uLjcI7xZ3pvhdjLcTprxJOntJCXo5eOP/+39LpeLi8s9YjfN7KaYnSS1nSS3E8RmHOc1+9jpv7nf5XJxcblH7GaYnTTtSdHbCXIrjm/FMF4tPXDKDbmLy1HBl+V8GXYnzXiS1ExL/j/vd7lcXFzuEUFY8kOiPyd4s9xumtlJ0aJRfvDxv7vf5XJxcblHRHE9jGqhghyEpUBe9OcF2ay5V9ddXI4OSaaUoEsxwoziRgTVwqiilhrzP/rZ/S6Xi4vLPSIr1LN8Lc1VUoydpEsJytLL7dN/+7/ud7lcXFzuEbDShuRWXmpmxUZWqGf4mlHrfv/H/3q/y+Xi4nKPQI0eonULahdW2rDchuW2Ve8/8dNn7ne5XFxc7hF4cYgaA1Tvo3of0XuI1rMag6d+9tz9LpeLi8s9grCGhDnEi0NsYqk5+qE7/ZOLy5GBKu2R1h5hjQhrRJgj3BzZLXciRxeXIwRZ2iNLe6S1R1ojx3LLnZLZxeUIQZX2ppKlEVkaldvuH1dwcTlCUPaeI+mG3MXlSELbe7ST89I4527IXVyOFE7Ix5b26NKeG3IXlyMFMxtye4+298rtPTfkLi5HB6a8x5T3GHusG3IXl6PGbMjdltzF5QjClvdYe4+19xvzihtyF5ejBFveO2Sl44bcxeUI4YbcxeWIw5X3ZnVD7uJy1ODKe1zlgFU35C4uRwmuvMeX9/hpyN2W3MXliMFX9mZ1W3IXl6OG04zP6obcxeVIIVT2HN2Qu7gcTYTKnljdEyp7QnVsreuG3MXlCCFWRmJlT6zsidU90Qm525K7uBwlpOpIqu45Ojl3W3IXlyOFXB3Jk5BLtT3JDbmLyxFDru7JtX2lmhtyF5ejhVLbm+rkvO6G3MXlKKHW9tT6nlrbU+pj3ZC7uBwp1PqeVt8bR90NuYvL0UOtjaYqtZFSG9W77kSOLi5HCK02cpxGvdF1/0ySi8sRQquP9PpIc3RD7uJy9NCmCa+Pm/RG1/2rpi4uRwi9PtRrQ22iWhs2uqOn3JC7uBwZtJmET0I+fOLp5+53uVxcXO4RWm2gOlb7jvXu8Ps/ffZ+l8vFxeUe4QRbqfaUak+p9ORKr94ZPPaPv7rf5XJxcblHqDPxlichP/XjX9zvcrm4uNwj1EpPqXSVSlcud+VyVyp3ap3BI3//r/e7XC4uLvcIrdpTqz212lMqXbnSlSvdemcw/3f/cr/L5eLico/Qqj212lWdxrzSkcudWmfwsBtyF5cjg1brzeS8I1c6dTfkLi5HCaPW12s9vdbTqj2t2lWrbnfdxeVoYTb6xXrfqI+jrtd6je7g0X9wr667uBwVrObAag7MxmCa9mZ3ePrHv7zf5XJxcblHlJrDUnNoNYdWc2A1BmZj0OoNH//JM/e7XC4uLveIcmtkOzaHTuBbvdETT7uPtbq4HBXK7VG5PdqPemvU7o+e/Nnz97tcLi4u94hKezTVCXyn744nd3E5QlQ7e1Mrnb1KZ68z2HNnhnFxOTqUWntjmyOrtWe19lo9N+QuLkcIzNxDJyLmHlrcs1rulMwuLkeIiDRyDEujsDgKiyOl5k7J7OJyhHCCHXIURkHBDbmLy9HiUMLdkLu4HDXCBxMeFEayG3IXl6PEoYQH3JC7uBwxQsItIa+6IXdxOUIcSrgbcheXo8ahhAd4N+QuLkeLQwl3Q+7ictQ4lHC/G3IXlyNGYCbkfjfkLi5Hj0MJd0Pu4nLUOJRwN+QuLkeN6am4G3IXl6PJoYT7+ZHkhtzF5ShxKOE+N+QuLkcMN+QuLkecQwl3Q+7icsT4/wE18pmJCE0GEgAAAABJRU5ErkJggg==" alt="" />

上面是查询,再看一下插入和更新,同样在Dapper源码里面找到SqlMapperExtensions.cs,这个在Dapper.Contrib项目下面,将其添加到自己的工程里面,同样修改其命名空间

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQwAAACJCAIAAABW5JEbAAAN3ElEQVR4nO2dv8scNx7Gt7yr8h+4cBd4O48bV8exXHmGq9+3msJFIGWKFIG8170wdkhxYMg5uFjIcfBCwMPBhZB78VSvHQJvisAWh7NcFTDc2jF5fdyhK7QrfSV9NdL82p3VPB+EeUcraTSzekbSWM9qJgAAtcz2XQEAxg5EAkCAXYjkzoPbkWEHlQGgKTsSyXUETURS5rOsWA5Y5yiWRTaGagzCsshmebnvWoyDliL54adf4hN3FkmZzzZsv7ZeRNK5HUSJZFlkM82QmirzGb0eq3YNFR1zc/T3krae2ojk6YvX73z8XXx6JZLyyZP5fD6fz8snT66vr+fzufrXLxL61S+LTP45DpGM6CxCCOuuSHHq44a3LFTtMjekUeapdqmihUievnj964++nX34PD6LFIlUyMuXL6+vr1c//jg38YpkWWTM7YdIfKdSt6XMZ3me0+dLoztWX22r00qcZiJ5+uL1rz76dvbh8xYimc/nz589o+Or5j0JjcyKInf6ejIA0LHy+3bHbGw7YEug8VlRbBVqFKAzmo3RPQupjy6HG0+Wm/i81MWTwt0zknOV+Swv9bGnqvxdyoolzSCrZ90Mr+LYwoOX0+x67ZILN3GfNBAJVUh3kcT2JELdHKfJ6q9f3pwyt4YXJIXR/LiGoz7jSrCGfDNHJGZGA2NOkhVLp9Eti5w8/UmB5LLcKtN2ymihlH2I6j/KnKgn4i6pktgr84qk7gaGLiecwFuy3RJ6JlYklkJaiOTzR4/ocCu6J9mwaWv6m6ZNJCuW7jenbrAlBl+8vwQrvnR6kronq68n4a5OXyEtkfubPlXpQ3RzM5Q4Nn/oIhrdpdwzqvJdr7fw0OXEXG+45KZDyliiRPLDT7+88/F3VCEtRKJ0Mp/P//HNN61eAasHSKRImFFRQ5FwJfcrEtIzeTqKmEZDK5eXpLUwx9F3aZZlnmez5/TewocQiZtxryLpSKdXwOqFlhCee0rvF/s2Z1lk1mgperilH7/h4ZYazxWbIT3b+JwYcimkbjGtig7MjfLyPDeuwj723iXmUUJvHhnPUGnLclQH57mB3UQSVfJkRWIO6rn/J6G3xj8lzZ15O/8/GJ6Ju07rmbjrBKqXihMJLTrPY3sSs/p2f2jE2Me1E3e2kttZgjXo52+Vf3rdSSQxJR+4SPa6LKXvl7B1gyuQIFNY4NhdJHTMV/MiC6QJRBJfhjkuA5NhCiIBoBMQCQABIBIAAkAkAASASAAIMKxILi8veyytqqrj42O5sOXx48c9lgxADcOK5N133+1LJ1VVqSXDZ2dnvZQ5LCmbe6fFsCK5cePG0dFRLzpRfQhViL8/MZac7MceBJGkwuAiKcuyF5243cjZ2dl8PvckJ8t4dtpY8fsJCTK4SIQQveiEOrTOzs6kQqJEstPFVhBJguxCJEKI+/fvHx0drdfr1kXNOY6Pjz3JWZE4vtm69bClu2yYpqf91LbMTA/xsmIZMvf6VvGCsbELkVxeXh4dHZVl+5Zw7949ViRVVXlysMMty6EaZ2Q1nKJGC1dr4vkF5/VWW3Q5h8PgIulXIXfv3lV9iF8hwpy4uy1bCNHc7ss7Zv02DOpbZDLKWMzsD4BdvN3qSyFN3vyy/pugSGrtvvzMJk4kteZeSGXkDCuSmzdvdlGI4F5qxREhksZ2X9YxGyESNuOyKEonCxglw4qko0LEViTN//cwRiSiod2XnWvbZW6SWBN3bpLOvhkAIwRrt1zwaAcGEIkLRAIMIBIXiAQYQCQABIBIAAgAkQAQACIBIABEAkCAQ7LvArAXDsa+2wzf9h1C/f65EPYvZlvgJTDYcDD2XYW7YD6cp8x9ItHxxh4PxgGYOOO17/pkAJGAHTNe+243kdgjKQy3QGvGa9+1ZGD9ERJJmZuL4tGTgNaM177bqSep2fPIFIlHFxAJ0IzXvttJJM7bLWrjwHALNGLs9l2XHifuxpgMPQnwMHb7bi9Yvy9EfkbFdB1CJIBj7PbdXjB6DCUS6/cZIBLgId21W+yPCgktEvP911YXKhd+wARsSVckAPQERAJAAIgEgAAQCQABIBIAAkAkAASASAAIAPsuAAESte/2D37WcbocgH33068/ufPgtgyPqs+EEHce3Fb/erAW+HZv3hDJdBmvfVciFfKHP//+UfXZp19/8rfvSyUYGTz5nP16AkIJagAimS7jte9K7jy4/bs//fbNm5+tSBHRk9hLs+oaOUQCvIzXviu58+D2+1+8Z8U07kmsGHtLHWLRojuQGgM1/5a83AY99Zv2cIsn7U+xN+94GK99V9JbT0L3Dc2J64rsuKv14EnAbcnLJWZ6HXbnXvqpZ5NTMALGa9+VvP/Fe3RO8tdnf4nLx4rE+NUH8znt2dXNm8A4dBI7O+vW/FieYHcexd68I2Ls9t03b36WOpGhvUhUQ1wW2YxuIepoIJiAHvKJdRq9H3VNg/d+ir15R0Gq9l337da2qZEWSXbWJen9CZgtednEzM66/Aa82UwZwPRIriiW2Jt3VKRq3zX/n8QZ72+i89yezGfFkk/g25KXL42Z4LszcS0S+qm/BLAnsHYLgAAQCQABIBIAAkAkAASASAAIAJEAEAAiASAARAJAANh3AQgA+y6oRS8LmO4CmTTtu2qRx26/VGMtzMjak7H2rGE+iGRI9mffDay7HQayGp+uy9rFeUPNd1lkWeYuUs4bLKNsJJKkFJWqfXffItlpBcItUtbM3G0CIoklVfuu1UbVmtqsKNQHZS4P7YXC1CFlLOLd2Hd1dmuRMSuSuox8+fZojT2RKjMj27DkOe2/9C3YVqzMmToYJWwWQesK244ap4aM1hw79IFbl1O171KRULcGNUmR31AxrR1GO2Ptu7wdlx1uuRkjytfxvhO5AmMu24n0uYjtv21vf00N+WJo7MFbl1O173oahvcD91mr4jnfOm/HZTfXcjLGlK8O/SfyDJzUCTiNOCYxn0jMn7kIejNrRXL41uVU7bs9ioR7t8NPOJbc7vFBkbDvjohI+BPVGe6NUZJ3u+4diuTArcup2ncjh1uOSNzhEG9g5+y4MSKpLZ+xB3tP5BWJWBZZlucZd/XGcRuRMDUk7/FICqtzO2zrcpr2Xfv/SYjH1p642yIRtRNr7hxGywmKpLZ8xh7sO5HzNpc8di1LP3N6MrMxRop64u5W31tDVUGPHZq7BPqKXH86Uuvy9NZu7ePdcAR9PjVHeokHyxREsiSbsjvvUsZCfyIZyyAlHaYgEqO7H6VCRF9NWw5UIJF+mYZIAOgARAJAAIgEgAAQCQABIBIAAsC+C0AA2HcFXQsIgEua9l0hRJPFDUokvkV11A0CJkeq9l1rUWO9TAyRZJm9AMtaGQWmRqL2XXapoRdDJHnhrh6kyyLB5EjVvusuftXxjv3HFElpLhCUB7a7jl2W6w7wfPFGTThTLutDqltWC4YjWfvutl2xVortgUckzK681PjRaG/e9qZco9ojN7imTbL2Xcnmieu2TOPQEYmyO1AzLMnrPMh9Lqguply3njQKk6Tdkax9l7B9gDcQif4pFdugRa2NQWtrJ1OuW08mPaSyAxK17xovtGh34PPx8qZTY6TkdCmWW5Uz33Yw5R6UwTVt0rTvCmNEZP4OgxrgFLU9iXVgmdFlEXF787Y05R6UwTVtJrx2q0+Tq++Jjid9CkAkvQCRpAxE0gsQScpMWCQAxDG79VAgICDUBIgEASEQIBIEhECASBAQAmFYkeRf7v8KERA6hmFF8uY/XXUSpJd6VkKc7vub2HM4FyshFuf7rsYow7AiEUK8etteJ5KgfdeXvdoKqboInEiJZLEWgmsrlRBiLU52+90sTPfNsDKGSPxhcJF88FV7nYg4+y6btyLaWKwDLYyKZLUWqyvj05MrIfYkkqC845MhtA6Di+TWw/Y6EXGmKybvuVg1adNUJNWVWJmP7cVaLK4gkumGXYjk1kPx8Ll49Vb85vPG2WPsu2zeyjPKqmhZ23ZviORCnK5IZ3IhxFqcXBCRnIuVM5CTGd0Bni+e1kSdSydeixOu9cs+TVb1dCXEilwOuRar2EqIxZUdeXKlcorT7UWdcneJRobL8dxtmb4+8WjDLkSSfylevRUffNUme8ue5KG4dcF8GVQ5pyuvSGReO2abeLHaqsVMps8VEV+RCYASg5HYmpOsdLVXV2Z9iJbYYiuVXU08zu3eksZUwnxGkPhwOebdNgautYnHHAYXSWuFyOxB+259CZtHl/xqL8wh04VfJHJyQtuimdd9IlpPfVoOE39hXcSmMfkKsYJ8PLti8BVrKUf+bRWiW/CFPbCkYguXw91eX80PJezi7VY7hcjsrH23aTmbDqSJSOSnCzXuUonPxUo9IMmjsbFIuBlODyLhimUbtzoUVp/AiUTpIVwOd3vdyzwsqQwrkv/+r71CZGAJZzwXq5U+VN+u9cqrTiTbtqhHSk6XQmcIi7UeEcXEWwO/eqXRIIdbJ1fe4ZZbLNO4z8XCnDXVDbfIXYosh7nbV1zigRt3X2FYkXRUSJdAR0T6+yADEvrCihXJyZVu39YcYDOYWZk9yUoXTucVbHzN7P8WyUtZnBvzKCU/4w01VyzbA5yqdGSaEZ64x5WzSUYqo1820MQHEia8dss/HmgRfI/Gw3pkIrABIumnNIgk4QCR9FMaRJJwmLBIEBDiAkSCgBAI+CEIAAJAJAAEgEgACNBeJP/+1/f//PsffaHHKgKwX/4P1+IfiCnzqC8AAAAASUVORK5CYII=" alt="" />

然后在测试

Dapper使用
class Program
{
static string _strConn = "Data Source=192.168.11.128;Initial Catalog=PD_ShopDB;uid=sa;password=123;";
static string _strSQL = "SELECT BrandID,BrandName,IsEnable,BrandEnName,BigLogo,SmllLogo,BrandStory,BrandLink,IsDelete,CreateDate FROM Brands WITH(NOLOCK)"; static void Main(string[] args)
{
using (SqlConnection connection = new SqlConnection(_strConn))
{
connection.Open(); connection.Insert<Brands>(new Brands() { BrandName = "手机", BrandEnName = "Phone", IsEnable = true, CreateDate = DateTime.Now }); var brands = connection.Query<Brands>(_strSQL).ToList();
foreach (var item in brands)
{
Console.WriteLine(item.BrandID + " " + item.BrandName );
} var brand = brands.First();
brand.BrandName = "家用电器";
connection.Update<Brands>(brand); Console.WriteLine("-------------更新后"); var brands2 = connection.Query<Brands>(_strSQL).ToList();
foreach (var item in brands2)
{
Console.Write(item.BrandID + " " + item.BrandName);
}
} Console.ReadKey();
}
}
Dapper使用

测试结果

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAS4AAACNCAIAAACG3QDgAAAgAElEQVR4nOy9d3AbWZ7n+fD3xe3t3dzt3s5293RXV+1Uu2kzERcXOxGzMddbRiVXUqm6fNWUkVROopdEK9Fb0HuQIEAABD1oQAOCBEjQASS8B0h4RwIESHjLivsjEyBIUa5arequym98gvHy4fcyX5pv/l6+hCDw3O9ffjUl83/9j39X29gq2zaN0NiYwXnM0HzHwHzH4HzH4HznIFyAypihha5hRtcIs3uEiR1dwlKO6Blb6hlb7hlj9VBYOMpSD2WxZ3QRO7qIHWFiR5nYUSZ2JInRxZ4ksCPM7hFm1zATM8TADDI6BxbaB+bb++fbyPS2PnprH62FBDHblAzxqNxInGkgTNcTpup7Iaj1vVSoXNcbr8RT6/DUOjwV3TNe3T1W1TlS0T5Y3jZY0TFU2TFU3TmM7h6txVLqceMNvRMNvRN1PePobkp150hF22BJM7mwgVRQ25uHxueicdnV2OwqbHYVNruy+05l9+2KrtsVXbcqurLKMVllmMzSzszSjozi9ozi9rSitrTC1tR7rTfvNqfcbb55t/lGQdPX+U1f5Td+ld/4ZV7DFzn1n2fXfZ5ddz277tqd2mu30Vdvoz+7hf40C/1JVvUnWdWfZFZ/nFn1SWb1J1noT2/Vfnqr/lp24+f5LV/fbb9Z3JVSgk0r7Ukvx6WX4yHSynFpZfi0MlxqGT61DJdajk8tw6eU9qaW9aaW9aaV96aWE1IriOkVhPRKUkYlKaO6L6O6L6OalFFFSisnppT13izBfVWE/fJe1/W7mOt3MV8Udn1V3PN1Ce5GKf5mWe/NUkJKOSG1nJhSTkwtJ6aWEVMqiKkVxNRyYmo5KbWclFpOTCkjpZQRU8qIqeWE1HJCSjkxpSIeX05KKSfeKOu9UYL/uhj3ZSH2egHmal77J9ktn2Q3f5bbei2v/Yu7HV/ew3xdiLlR1HWzpPvrIswXBR1Xc1s/udP8UVbj+xl176Sj305Bv3WjOsHbN6vfSUO/m1H3fkbDh1lNH91p/SSn/bN8zNV8zKe5HR9nt310p+WDW83vZzS8k1b7dgr6rZvVb6eg30lFv5NW+15G/QdZTf9+p/WzvM5rBV1XC7qu3e2+drf7aj7m45z2D281v5tR/3Yq+s2vqy59UX7havHZT++d+bjglY/yXv4w9+WP8s58evfcteLXvyy/fKPqys3qP6Wg305Hv52OfjsV/aeU6jdvVF35uurKjaorN6qv3Kx+M6X6rTT0O+l172Y0vJfZ+G5G/Tvpde+k14Lq6ur//T/9qLahhcGWtPbNtpJmW/tmWvtmW/tm25Ih09r659r659r76ZBLOwfnMYMLmKGFLsicw4zuYWb3CCPuNLjQPbyAHWZghxewIwyInlEGjsLAUZg4ChNHWcRRmD0Qo0zsCKN7hNE1vIAZmu8cnO8YoHf009v76W1kelsfrZU020qabUlAnImXaS2k2WbibDNxppkw3USYStBImGokTDcSppsI0/HFqYZeaj1+orZnrKabUoUZreocqeocqcaM1nSN1nZT6nFjDfjxJsJEY+9EPW68Fkup6aJUdY6Utw2UtpCLGkl36wh36wgFdb0Ftb0Ftb35aHw+GpdXg8urweXW9ORW9+RU9eRUdd+p7L5d2XW7AnOrApNZ1pFZ1pFR2p5R0pZe3JZe3JZW1JZa2JpS2Jpyr+Vmwp8FjV/lN36Z3/BlXsMXufWf59Zfz6m7nl13LbvuWnbtteza6zn113MaP89t+jK/5cbdtptFnWkl3emlPell2PQybHo5Lr0Cl14GgU0v64HKaWW4tDJcejk+vQyfXt6bXt6bXknIqCRkVJEyq0hZ1X23asi30P230P2Z1aSMKkJaeW9qKe5GMfarwu4vCjFf3Ov8qrD7qyLsjZKem6X4lFJcSik+tRSfWoZPLe1NLetNKyOklvamlRHSygnpFYS0CmJaBSEdhpheSUyvJKZXkNIrSOmVpLRKYnolMa2CmFpOSC3rTSnFf13U8+W9rs/vdl7Pb7+e3/55QfuX9zohE94o6rpZ3JVS0n2zuOure52fF7Rfy2v7LKflkztNH91q/DCj/oP0ug/S695Pr3s/ve6DjPqPMhs+utX48Z3mT7JbPsttu5rfca2g81pB59WCjqt57Z/mtn2S3frx7eaPsho/yKiHmnyY2fBRVuPHt5s/zWm7mtd+vaDz87tdX9zr/uJe9+eF2Ot3u67md3ya0/bvt5s/yKx/N732nZSqN7+qeOOLstevF1+4VnT+6r3zV+9dvF586YvSN76u+NPNqrdSqt5Oq34nHf1OOvqdtJq3U6reuln11s3Kt25WvQV9mlr9Tjr6vYy697MaPshqeD+z/r2M2nfT0eA//+y3f/+T5yQqfTN87VIbe6mNhKkmwlQzYaqZMN1MnG4mzTSTZlpIM60QfbMQ7eTZNvJce/9cZ/9c5wAdM0DvGpzvGqJ3DS90D89jhxewwwvYkYWekYWeEQZulIEbZeBHmXgKs5eyiB9b7E0CP7aIpzBxo7AhscML3cPz3UPzXUN0zAC9c4De0U9rJ9Pa+2Yh2kgzR/cIiL7Ztr5ZqIdtfVBXp1tJ062JbpNmWkjTLaTpFtJUM4Ha2DtZj5uow47VYSn12LH6nrH6nvEG3HgTfqKZQG0hUpsJ1Eb8ZANuor5nvLabgsaMVLYPVrQNlLX2l7WQS1vIJc19EMVNpOImUlEjqaiRVNhALGwgFNYT7tb33q3vzUfj8tC4PHRPbg02pwabU9WdXdmVXdl1J+7SWxWYrPLOhFEzitvSitrSilpTC1tTCltu3oO5cbfpxt3mm4UtKYVtKYVtqUXt6SWYjLLuzHLsrYqeWxW4rEpcVmVPViUuqxKXWYnLLO/JrMBlVuAyK/EZFbjMCnxGJT6zsjezsjezipBVSbxVRbpdQ7pTS86u68+pH8ipH8ypH7iD7rtdTcqs7M2owKWV96SUYGE/FHXfLMGmlvWklvaklPaklmLTSnEw5fi0cnx6OS6jojejkpBRScysJGZVEbOqSFnVpKxqUlZVgj6YalJmFSmzkphRSUiv6E0rx6eW9qQUY28Udt8o7LpZ3J1agk0tw6aVYdPKsOnlPRnlPenlPaml2JTi7q8LIU+2Xc9ru5bTejWnJZlruW3X89qu57d9XtD+xd3Or+5hvi7s/rqw+6vCri/vYb642/l5fvv1vLZruW3xJq3Xclqv5bZ9nt/+5d3Orwq7vi7C3ijG3ijB3ijG3izG3ijGfl3Y9cW9zuv5bVdzWj+90/Tvtxo+zKh7P73m3dSqt29U/unr8j99XfbWjYq3UyrfSa16L63mvYyaDzJqP8is/TCz9oMM9PsZNe+lVb2XVvVeevV76dXvZdS8n4H+MLP2w6z6j27X//vt+o9u1X+YVfdhRi34X/7jf6qoaeibXGrATzbgJhtwE/W4iQb8RAN+shGi98icTUcWnWomTjUTpyFntpFn28m0joG5zoG5riF69/B8z8g8bnQBN8rAjzJ6KcxeyiJhbJE4vkgaXyJNLJEml0iTLNIkq2+S1TfJIk0uwUwsEceXiONLvWNMPAWCgRtd6Bmexw7Pdw/RuwYh5uLQk8EMzmGOPoLBxOkcoEF09M929M+29820kaZaidQkptpIU+2kmXbyTAd5pp08006abiVNtRKpTb2TTfiJRtx4PZZS202p7Rqt7RpFd42gu4bRXSM1mOHqzqGqjsEj2gcr2gfKW/vLYd/2lcB2JRY2EgsbCBD36nsLavH5tfj8WnweuievBptbjc2txuZUdedUdd+pghzbBWVXaAx8u7L7TlVPdlVPTjU+D43PqyXk1RLz0MS8WmJeLTEXTchFE3PRhJwaQg6akFNDzKmB/hJz0KQcNDGnlpRbS8qr68ur68+v7y9oGCxoHLzbNHyveeRe01B+42BeHTmnlnSnhnS7qjerEp9Z3pNR1pMBGbsSn1WJz6rAZ1bgsyrwt6rwt6t6b1Xhb1cRblcRblcT79SQctCknNq+nNq+3Fpybm1/Xl1/Xt1A7hH9uXX9eXX9ObX9ObXk7Nq+7Nq+bDTpdjXxdhXhVlXvrcre+NoId2oId2qI2Whidi0pG028U02IdwmfXoZNK8WmlXSnlnSlFscp6Uot6U4rxUKkl/VklOMyyvEZ5fiMclxGGS69tCe9FJtWik0t6U4p7kpJapJe2pNRhsuowGdW9mZVEeIQsyp7MyrwUNvUkq6bhZiv73V8WdD2eV7rtdymq3caP71d9/Ht2k9u131yu/7TOw2f3mn4LLvxs+zGqzmNV7MbPstu+PRO/Se36yA+vVP/6Z36T7MbruY0Xs1tupbXdC2v+Wpu09WcpqvZjeA//N1/kW+bGvCT9biJetxEHW6iDnIjBH4S4siTvdTGXmoTgdpEmGomTrUQp6Es1EGmYQbmugYhHy7gRhmEMSZhbJE0sdQ3ySJPLvVTWQPTy4PTK0Mzq8Mwa8Oza0Mza0Mzq0Mzq4Mzq4MzK4PTK4NTKwNTK/3U5X4qi0xl9cEWXSSOLxLHmAQYRi+F0Uth9I4xYSgweAoDT2H0jjF6KQz8aJzk8igDP7LQMzKPHZ7DDs1hB5P+DtGxw/Se4fmekfmekXnsMB07NNc9ONc1MIcZmO0kz3SSZ9pJ0+2kqTYiTCuR2kKkthCoLQRqM2GymTDZhJ9owk804ccb8eONuPGGnrE6LKWum1LbNYLuGkFjhtGY4arOoarOoaqOQSjTVrQNlLfBvi1rIZc2k0ubySXNfSVNfcWNpKJGUlEDsaiRWNRIKmrsK24iFzeTS5r7S5oHSpsHS1sGS1oGS1sGS5oHS5oHSpoHipv7iyCa+gubB4qa+gubBgqbBoqaB4ugv82DxS3DxS3DJW0jZe2j5e2U8s7x8o6xkraRkpahwubBwsb+ggZyfl1fXi0xt5aYiybm1hLzakl5taS8WmJeLSm/lpRf25df21dQT4a429Bf2DhQ2DRY2DxY1DxU3DJc3DJS0jpS0jpS0naM4laI4eKW4aKWoaLmocLmwcKmwXuNEAOFTYPx9RwRjxm429Bf0EDOr+/LqyPl1h4jD77L9OXXk/PjHYPIryfn15Hz68h5tX15tX3x+L682r78ur78OnJBPbmgob+gYaCgcaCgcbCgcfBu42BBQ39BQ39BPTm/jpxbS8pBE7Ore29X4bMqcJnl2IzSrrSSztTizpSijpSi9pSi9pSijptFHSlFHSnFHSlFHTcL224Wtt0obLtxr/UGVChsu1nYdrOo/WZRe0pxZ2pxZyoUX9gO/sPf/f3u3kHCckneSxhvqqn3lHzYQoJMONveT8MM0DFxE+IpTML4ImmSRZ5cHpheGZpZGZldG6GtU+bYY/Oc8XnO+MIGxES8cMT8xjidM0bnUCDm2KM09ghtfZi2NjyzNjS9OnjEShJH9QNTKxD9U8sDcfqPQ6Yuk+Mmh5lYggwP3ThIkyxyIl2PL5Kgu8A4k0BhJuyNG13AjSzgRuZxI/M9w/NQ3sYO0bFD9G6IwTnMIA0zQMP00zqgNNs33d4HpdmpFiI8BobzLX6iATcOUd8zVg+5F0up7R5Fd43WYEZqMKM1mNGartGaLgq6i4LuotRiKbXd47XY8TrseC12HN09XtM1XtM9VtM1Vo2h1GAo1RhKNYZShaFUdSaBidM1XtM9UYOdQGMn0VgquoeK7qHWYCeqMeOVnZSKjtHy9uGytmHI5zCtg6WtQ6WtQyWtQ6UJ2obL2kbK24crOiiVnZRKzFgVZrwKM17dNVHTPVmDhaDeB/xRNXaiunuiunu8CjNehRmrgpp3jVd1jVd1j1fDTFR3xysxY1WYsUoMpaKDUv5QKiA6KRWdj4iE4zvHKjrHKjDjlclAlR3w5sraRkpbh4tbhoqaBwsb++81kAvqSfl1xLxaQm4tIRdNyK3pzanBw1Tjs6tx2dW47KqeO1U92VU4eLEal12Dy67BQWHZNfjsanx2NQ78b//Xf7U73S2kmRYSNAsCPVbNJh4IW/torX20tjitfbS2/rl26OFwcL5raKF7mNEzyuwdWySML/VNLvdPrQzOrA3Pro3OccbmNyYWNieZvKlF/vQSf4YloK0I51aE9FXh3IpwbkWUDG1FSFsR0pZhZlnCGZZghiWYYfGnlvhTizwqkzfJ5E0yuTCM+N84EwkWuBMLmxMLmxOMDYiTno9DmedQ5uPOh5jfoMxvJNeM0tmjc+wRGsT6CG19eDaRz9cG4wxMrw5Mrw5MrfRPrfRPrZCpK2TqMmTs+MB7kTC+GE/dTNwIAzey0DOyAD9UD89jh+a7huhdA/SugTnMwBxmYK6znwbRQaZ1kGc7yLQOMq0DXqR19M919M9BNe1kmMRpgma5WuH5rZkW4kwLcaaZONNMhCa6aK0kWitprpU810qmt5HprWR6ax+tmURrJs40EqYbe6caeqfqcZMJ6pL/9kzW46j1uKkGPLUBP9XYO91ImGkmzjYTac0kWmsfvM62fnp7/3z7wHx7/8JpzLeT59vI863w1umtfXS4DDWHmW9L9DARRppreQxaSXNQZDOJ9iDik/PxJn3HaIGbzzWTaM1EWiNhprF3pqF3qh5HrcVNorETNd3j0O2vCjNa2TlS2TlS2TFS2TFS0T5S3j70AIZhOqDCUHn7EPg//vOPHS4PZoiBGWJihpmYYWYXxAiza4TZ1DNc105IgljXQazrINZ3EOs7SQ2dpMZOUhOmr7m7r5M0NkhbH6FvjC1wJxg86pJghiWkrYjn1iTz6xIGW8bkyBc35CyuYpmnPAVuMoolrmJpU7G0oVjcUDA35MwNOYMjg1hgS+cTrD8M+ppk/jj048ytiedWxXOrYtoJVo4KsyuiI5ZFM8uimWXR9LJwelk4zRJATC0JppYEVIhFPnWRP7nIn2TyJpm8CQZvnMEdZ3DHFjbH5jcp8xujdM4onTNC54zQ2MO09SHa+hBtfXB2fXB2bWBmbWB6bWB6rX96NeHnPpjlPupK3+QK6VQmVkgTK8SJZeLECmFiuXccgtU7xsKPsXrHlvBjS/gxFn6MhYsX8GMs/NgyfmwZDwcv48eWcWMsHGUJercUf73E6BpmdA0xuoYYmCEGZgguQ5Xdw4zuYejt1GLP6BKOwsKPQWtbIUysECZWiZOrhMk1InWNSF2/jzXi5Bpxco3wbVglTDwxvQ9n8sFMrPZOrPSOr+DHV/Bjy7ixZRyFhR1d6h5d7B5hYoYZmCFG58B8xwC9vZ/e3j/XTp5rO7onzrbcR1Kem00kOfB//v3PnAc+AnWdOHUEaYpNmuKQpjjDlEmuUMYVSu9DxhPJeCLZBI01Mbs0MbvUNzjaT12eXpHQ1mR0tnxhQ8ncVC3x1Ms8NS4TBQAAmd11r4A/tnA2pFrSbRS4Nb0h1W1IdRyJ9hjiI9hi7bpIuy7SrIu210Tba8LtVeH2qnBrVXDECv8Yyw+BB6GOo2LdxxIEV7XEUy3yVIvcBMpFrpLJVTI3YRgbEArGhgIucBQLMPJ5jnyeLaezZfR1GX1dRluX0daktFXp7KpkdlUysyKeWRZNLYumWCIqS0hlCanYTAAyGxeFk4uCiUXBOJM/zuSPM3jjDN4YxAJvbIFHWeBRoMI8b3Qe/js6zx2d547Mc0foMMP0zeG5zSHa5tAcd5C2cZLZ+wq0jUHaxgDE7Eb/DIc8s06eXidPr5On1vuOWOubWuubWu8j1v6/4I+3iOt9U+vkaTZ5hk2e4QzMcgZoG4M07tAcd4jOG6LzRub5Iwv8kQXBKOM0Fu6Hf1rlgyLncv8H+O9lcyPz/G9HV9lL4H80dT1Jk+F5/tA8H9q7QRp3gLY5MLvRP7NBnmH3Ta+TphL3l1XoZtE7sRK/LT4AXPX/A/6/DNxK78Qy+L9/8vy+JzDCFI0wRSNMMcQoUzK6KBldlCwwl0PhcDD0CELhMJ2xNDi7yuRtswSaFaF2Vaxbl+jZMsMGpQCAArLSJFAJms+AlzAC0ZZ1KBcFcuZFW1aR+hhCtVWotiQQqM0CtVmg4jefAS918nlKEwQ5GwXu0LhKE1dh4ipMtI5z4BX8LKv3JZCsgj65cfMBQL0iyWhpKABAAVFm5MiMHJmBIzMQb6PA7VmoDMGWGjhSA1uqT2ZdoifcQoGXe6gS/bpEvybWTbaeBeA1NEO3KtatinSrQ/kAvFa9oF0RapeF2mWhhiXQsASaJf7WEm9rkbfF5G0xuWomV83gqhl92QBkd26oFjZU8xwlPc4cW9Geikrs0vVeOW1dQVtX0NbltHX57Lp8dg1mZk0+vSafXpVPr8qmV2XTK7IpGOnUsnRqWUo9QpIoT7KgRckkK4F4giUeXxKNd2cBkFW/KBofbfmXeAf+pWJhjCkaG235F/ByAUU0viQaXxJNsMQTLMkkS0pdlk6tyKZW5FOr8uk1xcyacnZdNbuunGWrZtkqWhxocXYK86/gTPFUfPGJWSn+I/jXupWHh7WmApA6PstW9dWdie8EvNG+ujPgj5i+x9zcugrel3XlzLpyek05vSqfWpUTa14F/9ZOWJZOsKTjLMn4knhsUTTGFFISnHobSjDc9N/BS3nDglGGAPzXn73o9oVmONszHA3EbIINzSJrRak2VXQzKnsWqvDz1UQ6mjwnl2tdzj2jwWA0GJzOvc7xzc7xTTpjaYLJY8vNHIVlU2nlqWz8rR3h9s4C9gJ4rW9RZ5fp7HK9Q2FwKAx7YwUokL+kMOw9CHkCvUM+U4ICxaM6uwyCQ34FXGjl2CVaCOYtFMia2pVw+l4B51vYu2LNrlizK54qQgHwcrcEXjyGpPU18FK3RKRhZEHXeS5DtL0LMZSLArkLou0dCGEyWzvCNdLL4HzT2o5ga0cwWYQChQPqHb7axlfb+nNQAID0CRtPZeOpbDTMefAqcVZp5Sqtm0rrptK6oTBvKMwcuZktM7NlpnUIiXFNYlwbLgCgAC8xrIoNq2LDitiwItKviDarXwbgpR6KSMcS6VjC6RuovG6hbkmgWxLoloS6RYFuUaBdFGgX+dpFvpYJwdMyeVoGT8vgaRg8DYNL/RKAL8maBa5mgbs9z92e524nChD0ze35zW06zBZ9c4u+uVb6P8G/1q/NTXf9KwCfE9VzHDWNs1ryx5w2jnpuBvOv4Ezp9NYcZ2tuY2tuA2qomedqFqBN83VMgW5RoF8UGpaEhiWRcUlkZImMSyLjksgEs9D7b+Bc5YLpqOapE98EpeUcAHexcCX+37Jml0RGSss58DKeAvfqyVgUGhaFBqZAP9J0FrzUM8zXLfC081zt/KaGvrlN39ie29ia29ia42zR2Gpa0m3oIYCfPP8rTyCyKLYtim2LEttSEosS2+LSsmrL+nntxBeN41+3j97sHk7rHRSJtlx79mQrds9w6Iwl2ppMoHEKtS6xziXRu2SGfblxf7n3Ejg3tGI+UFsOtizubatbY3NPFaJA4arG5obYPoH1GNR7KHBvdcvi3rK41Rb3KuESODe0aj5QQ8yVoUDZuPlAxR86A17v5B+ozHHmylBQjQlGCcEbOgNe7+QdKEwrd1DgDm35Dgrcoe0rTPsK0/5YAQoULENlhXFffgLu4KvgYht3X2bcl3EHXwXg9uy+zLAvMyzfRl185SwA+Syp3iXVK1rPApDPkuhdEp1LrHOKtU6Rdk+k3RNqHAKNQ7DtEGzb+dt2/padt2XnTRajQBFZvctNoNqdxVwAr5JmVDsbqh2OcoejtEGwFTa2YoetsLEVNrbcti63rcutEGty65rcsiY7YlVGvwnAzRHLqtSyIjVDrErMq/HycgKJeVligmH0/hs4V8UwLg0VAFCAFRuXICBTMXr/DZyrZJiWxCYWhMS0LDEvS82rMsuqzLomg3q1w1bssJW7HNUuR2WHUds5agdH7eCskv8ILtatOuDFvwDTmIvgDHla7SDmAJCz+KBPH29t9qNdUNk5KjtbZWerdqc6L4BX+6iKnXXFzprMtiqzrkotK1LLssS8LDGzJGZW4hCJH3zLEJuWxCbw03/8J18wuqZ2rR+xv652rW/ts7f25+aZqi1rfi/ty/bhD5pw77R0vNPRLBJtufYcBoPBYNA7nXu9rGXyJoPOWGJsqqUmr9zsVVi8KqtPbfNNFh0NrvKYGtxF8BpZa3AEZktQoJhjcAQMjgC3/414yGWcNGBw6HAXwVmy1uAI6B0BvYOTjwL5TL/ODqHtuQhe69No7X6t3a/d9U8VoUARW7vr10gor4FL3RK/ZicBOw8FzpA0GkYlClRQ4/Vs0mVwfnR9x7+9s56LArkLvm1GJQpc6hL5tm0+aiEKFK5v23zbNt/WQmViB3Lmjy2C86OrNg3mPHiVuK22+tTzlahzI6vzFahzIytWr8q6no0Cd+hepcWrtHjH7h21u03zyExumXH1NgrcKihDAQDODjJmy1CgdEi/L9YrW88CAC62bChazoKXsAqh1hXHKdA4BVqnQOukY19PrPB/dst5GidvW974Gnipuz89Xp9O3eOu9f/PoxF7cd+WY2NLVn80UiPPqB0bamYaAGk5xVDNtNrOUdmnMRfAGfK0ys5Z6fsjAH/ESDgqyFG7bNUOe6Xvj+BCHaYosWaiys5R2zfUjr6co+1lUF187b5Au5wJQGbP0Mvx+qxZt8jgFm0OvwwutWy6RYYkNocTYeDs8EK8fqggUVmedRa8jFOLDOoWuOAWGdzzuEvxiEvNm26hwS00qJvPgpdxaiH8aaIeZh53CZwdbk6suWA1/tFq5tFOlA9ClbPlAJQ3H22lbFB/INAd0HteB68Nzmn3edp9nsbF3XZxt52zXRcT7f+IkcXdy0xNVGYX/xFcqFuxs1fIcEFlB8/94nf+8OGmzrup823qfdzjQFZ8o7r7TEXT+br611tq3uisgLKiwaCHsuKIZGZcMUFnLC0JtSpbUL0T2toNbdtDGkdItxfe7L8CLlaJHJ0AACAASURBVI5vOkNGp6H3dXB2wGByhWmlKFC6aXaF+YNXwMVxviucKPNcR2EmV5gHV4ZNrrDRGTayqlGgatYZMjpDBmfIIB8/By7jZCHDXsggHz8LLvfIQvq9BHrcRfBav16/VI0CVTNw5WY+CuQvhfR7Id3eZj4K5C2FdHuh6RIUuDC24QhNl6BA8YbOEdItVqNA1bQjpHOEtIvVKFA15QhpZeNnwWWsNKhxBDWOIJv8BrgwxrYH2eQ3QBFnWzr2GrjcJQluM6tQoGpyN7i1G5wsQoHzY6u7AfVuQM2oQoHLnaKA0srORgFwbpRl8SksPjm9EgXKKebt9vMA3F2Tmb1S0/ptFLhF80pNXqnJKzF5JEYYBv4SAOVDRo/I6BZxh18BIHPWLTKoW84BAF5v3jwQ6g8G8wE4OzSvPxDqlzMByJzZF+j2BTpl01nwUo8yuczXLWcAAF1PfO0+X+via1kZAGRMuXgaF0/j4lFLAAAAlJA1Th4Ee+AlAMBrAzSNk6ddygDgJayCr3X15wFwdpCuPxDq3aLZcgAutXK9EtP6LQAAqBwx+6Vm/xLhMgCX2wUBmYDyClSwxBFQXgHgNh1a1LafB+AeR2YJHDWxBGT0SgDAKwQtFPAKQSuzBEbvAQAqRy1Jq4IjjypH7wEA4BVCLBEux1cFBUOb4NxOVEKtzlOW4tsF9zhSS0Bq0badB+A8ZdHsX+y9DM5RmCafxOQTm3wio3cBfwmA8gG9W6A/4G8MvQRAxvQ+T6dsfA2A1wZp2n2e1kXOAwC83shx8TiDL0EFLQv8/Je/94cP+cYA3xQUmEICU1BgCgrMIaE5JDCHICuerW680FB7qa36Slf5271FUFZMDFBlNpnMJqMzllbEhi17ZNsR1exFdXtRnTNqcEW5g1fAxUmeK2reNxFeB+eGTJaDKL0MBcp4lgMTIXGXgVVDP4hajjARLsFNLAdR8350rgwFSnnm/ahpP2raj/LiKze5okbF5DnwBl4RNboS8ApQoICVXBM1smpQoHrWFTG6IgYXtwAF8lkRgytiUEycA+DsgHG2FAVKuAZnZLYUdbxvb/TII3r5xFnwRo8sondGdM6ITj5xFlRP7xl7LoK8pYh2z4C9CPKWwpz+K6B4U7sX1jo281AgdzGscYQ1jvC2w9B9EZzp06t3N3NQIHshqNoJqnaCyoUqFLj86nkACjlKa0Bh9Sus7Dso8ApRI7f65Ra/3OKXwWjaz4NXerdlZp/U7JOafSP3UODuusS03XoOvNK7LTF5JSavhFYBQMWw0SsxrmUBkDXrFRm9Im5SzoFTwZrIsJYJQOas5yhjzJTBd/0kBvIBAADkrwj0B4LNoZfA602bSR/lrwj0q5kAZM16xEav2OSTmDRt56BrmnMbgDvzQbktqLCFFDsbdwC4sxBSisdfBW90isPKHZhl0hvgwvhyfFG5UA1A9diOofMCeJVkiIclFhOFzWwA7iyEFTvHGCsCoGjzeOXmHQBAPJhFegNcGGclfXRnIayANxpvIh5/FbzRIb6vHl4MsUhvgPPjLGtQbg3KrEGZRdt2HrzSq4070zdUAEDBmpA78jK41LzpERo8QoNHuDkMLyYKs+Xg+V/9IRD5RmgOiyxhkSUCIbZGxNao2BaFrHixGf1GR+WfsKXvEAo/6M8TibacSc+K4VAwHArSGUurUtP2XkzjjOlcMb0rZtiPGfdjvKE3wetU/kHMcmAmXALnhsw2d2yhHAXK+Da3mXQJnB8yW92x01FTz4MrRHXM6o5ZD2KWA/49FLi3ErMcQMArNB/EzAcxs4p6HlzpVcXMBzHzfsy8HzMto1GghrYfMyVBK0OBUn58kX8XBQqWY8b9mHE/xh18E4Ar514HoJRv3I/RSlGglG90xRIYXDGDgnoOXMEpYgZo0WXGvQ7yWfx8VM20K6ZzxTYG3wQl/OlSVN5SVOeMap28PBTk0oh2L6LZM2IvgjNk47aDm4sCOcyw2h5W74bUjGrY9+fHVnZCqp2Qaic0VogC58eWbUGlLaiwBhTWgNwakFt1HefBK0St3BqQW6E7Nwrc48AXAUErtfilZr90rjKeiNi3ALg155eY/RI+5RVwuZXvE5uSWc8CIIvmFZtghu4CULAmMnqP44GcnDULFS61bHpEBo/I6IWuNjHkeZpPYvZJzH4plLWIOrkt7r2dsHI3rNrlZgOQzYyopJNnwBWMNKqyw6yQr4ALkyvxRRWzBoCacbsJcwGcIZviYYnFRIGXDUA2M7GeiMoeUdnjW7GfZIV8BYCacahwYWLlRDy80Xi8dOIMuIKR3lcfX4RWsrwbUe6EFTthuU0P7bXMGpRaAlJLYPguAHfZYj7lZXC5lecTm3wik0/EG30ZXG7hJRVoFXErWsIia0Rki4psUfERMciKVzDlb+GL3yPd/Wgw55PRWyLR1p4jbsW9PZ/Pe7C/T2csrcnMGueh1nWocx3q9w8N+4fGg0PYiu6YxW0hXALnhi02z+FCOQqU822eQ9HImwBcIW4d2jyHtrXa88MWm8dCugTOD1ts7kPIsVb3IYRg+E3wOlXgPrS4Dy3uQ/NqLQqg59yHZveh+eAwbsVD08GhCdouAAUrh6aDQ9NKLQqgaQeHJhX1HLiCj8cYDwQFKFCwcmg8gNxoxkOPYKV8437MsIxGAVCwHDPsxwxK6rlSPlwAV3DKmMEV0+/H9PuxmTLUa69fARcnN1wxnSumY6FRF6+8Bq5gFTGtK6Z1xqZKUQDUUJ0xjTOmWUKjwJUuWXTbwctFgZzFiNoeVtvDamY1ClSN7+oxFwAAVWO7IeVuSCEefxUAcH6MtRNS2IJy28YdVBXFFmSR3gDgcpsoKLMFZcKxVwG4NR+UWnVxKwakloCUXglA5YglILVwbgFway4gMQckZm3rOQDOURhmv9jsH7p7uZXvF5vZkIVgZ8IXh1dk8opMXhGtAtxdExm9QqMXvrVzkwpGb8KKIqN36C4AoGLI7JeYAxJ6JQBvtItCMtvGHQDAhXHWbkS5GxkrBgDUjNujKin1DLiCkcVUjjgy6hkAzpDNKkdM5TBjLgJQzFc5YivkKwCgx6GYRTSAY8yYi3DweDFIBKyQ0RhZbIV8BVykrsTXPF4MshfhcuKj4zH8bADF8LMBvF14zVDM0XZjKns8xh5bIV8BF6jL9qhiNwLBIr0B7bjUGpIKxl4B4NZcQAwd+btssckvNvmH7gIALrfw/CIe5WWoYGLDVownwyQfWmMSW2xuYVEs1VRRBqvH+9GTpLopQsMMfmNDnLDinsPhcR84nU46Y2lNemRFw0krHprdUBKzWD2H8+UoUM63eg6tkC0hvU4Veg6tHgsRCnMLClHg3uph3IqJetiKc2UoUMY3HxzCqKjnjo290LQD2HKm5VoUQNP2D3mDb4KLVO7+oRFGUIACBcuJxUOjknoOAFDKh/rPHXwzsbYZ16HBdWhwWXCQXS9SN1yHOtehjlWLAuC1AYsOWnQJ8lAAXKRynIda56HWeahxWpImWa50y2Lbe7GtPV4uCuQwI2p7RLUbUTGqUaB6LD4AgwdRtpDCpu+4kGh7uV0YklmDMmtwtDBpHmg+KLUEpRbIijqJOSgxByRzlQBUDpsDEnNg6C4UWDlk8otN7Kx4w5d7tSKTX2SCrOgXmXwik2+h9zI4N7pg9IniLOAvJ7aVOesVGrzCTWi45RUavEKDd7AAgIJ1odEnNGpajs7B5VZBUGYNyawbdwC4U1idOAKdkqhyN6qUTibmjwAA4AJ1xR5TMdFHNcV8lT2mssdUdjMmcRAuoLMvgDNkM1R5hmyGYsaLk1sd++jkGgB63B5LuGgFDuBnA5DNjKnsMZWUetSxRAATDQA6u/ioftkeU9pjy+QryTvxKsmo2IlQio5qbtGDEnNQbA6I+ZTE08HLdytfPmlFP3j+V3/wQ1nREhFZoiJrVGyNiq0xsS0mscVm6cxoNOJxuzwHLs+By+vxeD0HXvd+MOAPBQM+n9ftdu/vu/b3XUdWdB7qXId6KDEeHBoPDk0Hh2bYPzGLO5bIco9gtRYF0PS48Sxq6nlwhaA+NENp0C24hwJ3Vw7NCb8dx5jgyHgW/Ovg7KAlqQZy1xH6BwDZTO861DlPQXsfmgR7MNt7h9t7kAljW47YliOqdkTV9qhqN6LajSh3I9CzkMIWVtjC8jgyWwjGGpJZg9ITWI6Az3cyJn8youMI78foExo1zefAy3iN0OgTGn1Cwwm8Av0DMPgg4IZGv8jkF5sDYnNQat24BcDthbDMFpbvROQ7EcVuVAkTU9qfFH42AK+SzQ+LkVJfBVc6pd9i5Q+GiQYAPZZcs5tMVLEbVexG5TtR+U5EZovIbGGpNSy1hiSWoNgcFJkDIhOEX2j0C2crAbjczPULjUecsOJJN5KHJ+mMpftZWFxmslYXmKxETd8gZU1m2d47PDFGTXaj2X1odscsD+HgAc+BB7F4DoyZDmKmA+gRdJIXXzRC7MMYIFxH6F0xPQuNAjUzUPk+dMk4j6F9EHsxzV5M44xpnLFtZwxyWoKtEzhiakdMbY+pj27V0OUYUexGFDsRuS0is4VltrDMGpJZQ9IElpAEJiixBMWWoNh8DBGEKZg42fD5Pg0BjI9/PwYff7YCgIp+vY8P4z0BT/cA9DDxSMiWfqHJLzJtZAGQRQ9JrWGpFbpMo7KdqHwnKt+NKR4HBhoU8aEyq+8KAFc6JA+LHysCifinBgMNAHrseKU8CdlOVLYTldmiUltEaotIrRGJNSy2hMSWkMgUFJoCgwUgcxY6+NqmswCcHZ0z+PhJgOd/9Qd/+BuBOSy0hIWWiNASEVkgK0bF1uimzssUmRlCE0NoYohgmEITU2hiikyLSS8ol6VmsdG7Bd3+nYca18mHRtMxQ57GwemcmvSO5b2DQ+M+PCQ27B/qIR6c4hJZ7lROT24nOEp0x9iKo3acROU4VNkPlUko7IeK3ZgCOoU7UZktIrWFISSWsMQSFsOE4DNqCYlMCYIiU1B4REBoCghMAYExmYTx/PwEBhjeCfQJfAm4Ou8JNh/MsUi9j6f38Q1+vtEvMHIyAciaC4ktYbE1LLFFpLao1BaV7kRlOzHZzqFs99GMHg353myXPFaTpwwDDQB69P76nSOkOzFo1yTwI15EZAmLLGEh9GLCyMlI7MRZCk3v5+n93CTiVjSFheb7rQgPUyW2mGQnJtk5WpTaYtKdmGwnJtuJQfc25W5MZY+pHTH1XmwLcqPzUHvckIkkeQr7j8BwGpDrvqWdnIca5+F2Elt7p3PMTkmFZJRxFPaTyHdPAB83qS0mhY9nVGyNiK0RkSUiNIeF5rDAFEqGbwrxjXEMQZ4hyIUJnEQf2NT7YXT+TZ1vU+fbeAAcCO1xND6OxpuAfT/bnvXTYG97ksM4Gi9HC23Iz9UHeIYg3xTim0IC+DKLiqxRsS32fUJkjYmsMaElKrREhZaIwBzhm8J8U4hnDHENgU19YEPnjwMfbXYSkBUP+aYg3xwSWKDcGBZaIiJrVGSNimzQIYuKd6DtHR0+yJ/SHdiTsCHtCUMeJgwJZUjYlvv3kfwk9vB8lUyS0+5PSie9BBNTO2BU92OPqY4/HijsMYU9Jj9B8pgEAjoIuzHpLnw0pDvxO1ccUQJbDDqwQmtUYI0KLDA8U4RnCvNMYa4xtGkMbRhCG4YgjD7I0QcSsHUJ/Gydj63zrWuPsZZA41s9Be/qdpwtz8oDcSdYVh9HdcA6jWXVwbL64Chsy72y5V7d9qxqvGtaH1vnZ+sDHH1wwxDaMIa5pjDPHOGZozxLlP+3Dy8Zc5RrinBNkU1TeMMY3jCEOPogWxdY1/rXtPGzsO1d3fZCh3o5DmxFniHANwb5piD8ot8cgm7P8MtGK0TiMRJGYo1KoMFGfMgh34kqdqMKe1Rphy9x6NLfckS3HbFtx8kHKgjNA3jw01d0ay+qdhyReDeljKNIsHsSOcROVJ4YHMaR2k4iiROfW47AGQzCcoTQGhFaIoI4fDMMLxlThGeKcONsmiIbhvCGAT5h67rgui64rg2sawNr2sCqxp9gZdt3jC3f8paPpfay1F6W2nOCJRj3kuokiyr3otK9qIA4WFQcME9nn5FA7jqJ7MEkhyn2mYqDRaV7SeVmqT3LW74VjW9V41/TBNa1wXV9iG0IsQ1hjiG8YYhsGP+WMUQ4SbAN4XV9aF0fWtcF17TBFU1gReOHzteS2gOfCKV7UelmKtzQAWcoDuBv23D10CgiwDME+IYgzxiAvn8jhEYUENDA9zgiS1hkDYutEYk1IrFGoGdWGcROBJ4x24kodiJKiN0HkOQimN2HAftqJ6LYich3IjJ42ioitUUkNrgzJxAnIbKGYZJ2SpDADMOHMIX5pjAvgTHMjbNpDG8awpuG0IYhtAFns9CGIcSJw46zbghBp2dNH1rTwazqQqua4KomuKIJLm8HWNt+1rZ/acu3pPYuqr1MJQxD6WUovQtKT4J5hXte4Z6XH8zLD+bl+wnoELL9uQTSJCQQLtoRzhPMJhA7Z8V7CWZEjuPYZ4SnkRQwK3bMSvZoEuec1EWX7c/LDxaUbobSw1R5F9XepS3f0raftR1Y1gRXNKEVTWhF+zfPsia0rAmxtoOs7cDSdmBpy7+05V9U+6DTB50yevy80CSuWRjnrMQJfv6L3/lCMY7Ww9F6NjSeDa0XesDY1Pm4eh/X4OcZAzxjgG8M8o1BgQnOnNC4n28O8eMzBwJzUGAOCs1BYXxOT2wOic0hcdIEoNScNPkOYQ1KLNDUPDRhGH5MJHGgiQ0RhDkkMoeEEKaQEOok/KwV5BuDvCS4R09cwU1DcNMQ3NAfwdEHObojkoaFAbYusK4LJHLXmjawqgmsagOr2sCKBmZZE1jWwNY6YssPnZsltX9R7YNgqnwMlY+h9C0ofAsK77zCQ5d76HL3nPRgTnowK9lPwjUjhpkWORNMHYcqclKFe0k4qEIHlX8C+0QCnn2Ct3sq49ydZMa4trHNJ2Ccaxvn7kzwdif5u1SBY0q4Ny1yzoids5L9OekBXeamKzzzCu+Cwreg9DGUPobKx1T5ny6MZ86C0reg9M0rfPMKH13hpcs9czIPTXowK9mHTtwUdIIEjkmBY5Jvn4yfAvDci7/1hWJrateaen9Nvb++tb++vc/ePoDgaDwbWs9G/Mvi0HwA9xjQF8e9CTZ1Xq7Ow9V5oDlueBI8Mc2t8/D0CaB6Hx96KwVNuJv80HxgnKN5QkECI0SAbwzwjXAyj09aBDb1gQ19YEPv5+j87FPR+tfjrGn9axr/2mlDwWWILR8rzpIaZlHtW1T5mCovBCPOgtK7oPTOx6ErEnjoCs+cPI7MQ5N5aDI3Teqelbpnpe4ZqXtGejAlOaCK96ki16TQOSl0jguc4wLnGH8vCQeFm4ydwrVTuLujm7ujm7sjR+yMbMTh7IxwdoY5tmOwbcNs6xDbOsS2DsJYTmVg3TKwbj7Jmqn/UQysm6DgwXXzINsyzLaObNhGN3cpXPsY3zEu2JsQOqki15Rkf1pyMC09mJG6Z6TuWannu2Xm6eCelrqnJfAJnRS5JkUu6FRSeA4K1z66uTuyAZ+UIbZtiG0dZFvAT//xN95glCXbZclhluX2ZYVjWelYUe6tqJxratf61v769gFH4+Zo3ByNh6P1cDQe9raHo3EnTLu+tb+u3o//Yyvnutq5lgRco9pbP4ZzXeXibLk4W/sb2+4NjWdT69nUejZ1nodPo2/E4WhhoFm7dY13XeNd2/asbsenH9Se5TgstYel8rBUnqU4iyrPotLDPMKdgKF0Lyhg5hXuebl7Xu6myw/o8gO67IAuO5iTHcxJD2jSA5r0YDbOjHR/RrI/LdmfluxPSfanxPtT4n1qnEkRhGsCQuAaP8JJETgp/L1RrmNk0zGyaR/a2B3k7AxydgbYNoh+tq1/HcLav24lr1kg+tYsfatm0imYSCtxlo33Q2QZiSwDkWUgsAyEJf0j6V3UHUeLZz6MXqa2d1Hbu6gjLOmILD1p2di3YiKvWQbWrYNs29DGzvDm7gjXPspzUHh7FL5zjO8cg46G8LtD8C0ZOw6F76TwnaO8vVHe3gjXMbxpH9q0Q2eTvG4lQ6csfmqIy0YiywD+4YVfewIRhsgcx8IQWZhiK1Ns1e54TQ6fec9vcfotroDFFbS4glZX0JKMM2BxBixOv8XpN+/5zXs+057P5PCZHF6Tw2ty+OJAi14jVNiDMe/5LHt+i9NvdfqtroDVFbS5gjZXyLZ/HNdJrPdhSeAMmZ3BBKa9UzAex7AXOIE+gSOgO4EdBv43k3a/1u7XJNj1a3b9249ia+cINYTNp7b5VDafyupVWb1Kq1dp9SgtHqXFo7B4FGb3/ciPcSA3PQKZaf8kxiOkp+M6huEUJA/gKMbokhldMtM+1A2F2a2wuJUWj9LqgXYW2nf1jk+9c+zI/C2ivv+EHp1Tj9LigU+cyR0/KQfQiQA/ef6Xbn+IxtXSuLoEczz9tnW/pZt08f0vLn7w1aUPv7780Y3L/37zGB/duPThjdc//PriB19dfP/LC+99ceG9z8+/e/3cu9fPvXPt3NtXkzn79tWzb3929q3PXnvrs9fe+uzsW5+dffuzs29fPffOtfPvfX7x/S9f//CrS9AmPk554+PUK58gIPywAD9+7sUDX2h6XT3N3ppiq6fZWzPsrZmNbZ1t/9w718DT1uLi4hPVI0L0Q9GPnnvxwBucXFVQ15TUVSV1TTm1ppxmq7VW19m3rz6trSwe16kBjx+MCNH3UD/62T8eeIOTK3II6qqcuqacWldpra5zb3/27da5eJ8ep8kjy4gQfZ/1o+eOrEhdlVPXFFNrimnIiu88nayIWBERokfrR8+9eOALTq0pp9aUU+vK6XXVNFs9w9nS7exfePd6IuzPscRD2p6aPxErIvoh6sc//4XbF5rhbEHMbmzTNjU0rla/4774/hdQzJM+s91vsCd9Vjy1jAjR91nQy4w5nnaOp6XzdHS+fp5vWBAYjHbPpQ+/eirTJ49se2L9iBUR/RD1Dy/8yhMIM4RmhsjMEJsZYgtTYlmU2EwO35WPb0Ixz8aKiTDEioh+iPrZP/7GG4iwZLvQd9+W5fZlhX1ZYbc4/X/6LA2K+YtaMfn5EHlWRPTD1XMv/tYbjK6qXKtq11qCrX2LK/T2NfgHyx/fio98Srx/xItYEREiAAD8j6TYGjdb42FrPRyNB/rCt+0g/O7nt6CYv1xWfOSgFLEioh+Knv/l733hQ+jHTpJ+E8W/cxB570vod83/4s+K4DGsiHgS0fdc0A9qxH+n6Ojf0e64o+9/mf2gUeUTCbEiIkSP1gu/+oM//A3PFOKZglzjETvu6Ptf5Ty6/WPoiax4IhixIqIfil749T/7w9/Ef7glBGMM7bijH3z951rx/mmYh0eeGvznJGREiP5mdNKKRpinYkXw2Nns8U2LCNH3U8etGH7qVkT0RHpaNyPkpva3p5NWNCFWfAp6yNvUR86EPcRFjzTYnz/Hhug7E2LFZ6aHe+NBLn24tRDvfX/0F522QZSsb2eVRxr4W/UF0V+fkqwYQqz4dPXnDE0XH+8tDmLF74/iVgwhVnzqWnzAO9JTF5MrT/XkgzbxpIZH9FcqyIr85N+0N4X4ptCOB7Hin6vHt+JDXPRwayFO+/7oVCvyECs+DX27fPUgsz0kiyL6PuiFX/+zP/LNCR8mrPj4t2qkPrke0uKTD1AfEnZq/INWguhvTyesyDtuxe+6d3/beiIrPsTtp8YnV57aFnHp35hgK5pDvOMgVvzz9SCHPNwq3yIrIgnz+6C4FcN8xIp/AT1kvPqg4Aclw/ubI2PX75WSrBhGrPiX0EMS1/1h9xcQK/5QhFjxGeiRT24PSp4PSaqPzLeIFf/GBFkx8b/PC8whvjnEN4d2ESs+DSWb8JGzKffnz8e35eM/iyL6K9UpVjSF+CbEin+WHjkx8yDDPGYavH+Fj1mJ6K9XJ6zIN4efrhWfwQWBXHOIvg9KtiI/wVPNio8zY/FwPd31P6QSEaLvTC/8+p8DkW+ERwNUmG9txUf66v6r/+EjsadixfvLD+kAIkTfgeCsaAmfYNf77a34pGFPasXHN/lDtoVYEdFfl+6btgkLzKdY8VsY7PHDvoUVnzT+fqM+3L2IED1rvfCrP/gj3wjMIYE59KAB6hNdrI9MWfev7YmCwdMb0CIORPRXpOd/9Qd/+BuBOSwwhQWmIyvaPdEPvsp5iB8eU4/T8Emt9bSs+JjdQ4ToWQj6oX6+McQ3hRPAWfGrb5MVE0q0eurWevws+sjIP/9egwjR01HcikG+Mcg3HY1R7d6jH+p/oiv1QX5IlE9t8viL3yL+/k8R4yH6q9PPf/l7f/iQq/fzjAEe7MaQwBTe9XxLK55Q8qX/oJU8ab76dlZ8yA0CEaLvXnEr+rh6P88Q4BuDAtPTseKJZPiQNfyls+JDto4YEtFfi577xe/84cNNnW9T7+Ma/DxjgG8KQt+2eeoD1If44fEXwZNk0cfsOWJIRN+9nvvF73yhw02tl6v3cfU+njHANwYSVnzIVf44ut+Ep67kL5EV7zfkiV14nMpvt9eIEH0bPfeL3/nCsQ2dd1Pn4+p9PIOfbwwITMHkrPgtdH92etCnT+q0U7f18MpTyw+qRKyI6LvRz178nS8U29B6uTov1+CHrMg3fksr3n/t3p+j7m/yoJpHtn3QGgBiRUR/c/rZi7/1hWKbWg9X5+XBMzcBgSlo//OyYrKeyIdPGpAIe4h/Tq1/nErEioienSArbug8XL2Xp/cLDAGBMSh8qlZEhAjRo/VTKCvqPFy9l6+HHxQRKyJC9KwFWZGbyIrGgNAUFJpDiBURIXqm+umLv/WHYlydh2fw8g0+oTEgNAWE5lDyF98QIUL0F9dPX/ytPxzj6r18G1v5DAAABm5JREFUvU9g9AlNAaE5IDKHHIgVESF6lvrZi7/1h2M8g5dv9AmMfqEpIDIHRRbEiogQPVtBVuQbvAKjXxi3ohixIiJEz1g/+8Xv/OFDgdEnNPpFpoDYHBBbghLEiogQPWM994vfBcKHIpNfZA6IzUGJJSixhCTWkMOHWBERomeon//y94HIodgSkFiCEktQaglJrSGpLbyHWBERomcpyIpSS1BqDcmsIZkNIrzniyFWRITo2en5X/0hGPlGZoN9KN8Jy21h2U4EsSIiRM9UkBXltrBiByICseeLfYBYERGiZybIisqdsHI3kozTH0P+JylEiJ6dXvjVH4LRb1T2CIRyN6Lajah2Iy7EiogQPUu98Ot/DkW/UdsjantEvRvHjlgREaJnK9iKjqjaEYEMCaVHxIqIED1TQVbcckS3HJEtR0QNgVgREaJnLMiK23vR7b0I5MYtO2JFRIieuWArOqIJthzRLXvU5UdeZiBC9AwFWVGzF93eO+ZGlx95xY8I0TPUC7/6A2RFzV5U44hqYDdGECsiQvRM9TxsxUiCbUcEsuJ7X2Z/171DhOgHo2NWdMBsOyL7/ihiRUSInp1gKzrCCbYd4W17eN8fffeLO9917xAh+sHo57/8PWTFbXuC0LY95PJH375++7vuHSJEPxg994vfhaLfbNuD27vB7d3gVhyXP/rWtVvfde8QIfrB6Gcv/i4UPdzeDWztBLZ2AmobjMsXefOzzO+6d4gQ/WD0s3/8bShyuGXzq61+tdWvtvhUFp/S4nN6w298nPFd9w4Roh+MfvrffhuKHKqtPpXFpzL7VGaf0uxVmr1OT/jSR2nfde8QIfrB6Ccv/FMwcqgye1Umr9LkVZq8CpNXYfI63eEL76d+171DhOgHox8//5tg+FBp9CqMXqXRozB6FEaP3ODZc4fOvXPzu+4dIkQ/GP34578JhmNKo0dp9CgNHoXBIze45Xr33kHotbdufNe9Q4ToB6MfPfebYDimgqwIuVHvUejde+7Qq29+/V33DhGiH4x+9NyvYSsaYBQGt0Lv3jsIvfIGYkVEiJ6VfvTcr0PhQ7XJqzJ5VCYPnB4NbqcbsSIiRM9QP3ruN6HI4bbFt232bkGYvGqjx+UOvXIFsSIiRM9KP/75b0KRQ63Vp4Gw+LYt3m2z1+UJn3kTmbZBhOhZ6SfP/yYcPTTsBvS7Af2uX7/j1+34dTb/gS9y9m3kZQYiRM9K//DCP4Wjh0ZHwGgPGO0Bg91v2PXrd/0Hvsj591K+694hQvSD0U//2z9FoofmvSCEaS9gdASMjoDbH3n9Q+TbNogQPSv99B9/G4l9Y3GFLM6QxRm0OINmZ9D8/7d3LztNRHEYwF+Ei5aCF2gV3oLEREOiCcEYjBsvO3f6GnKxqARDCJE0pbZlKIVoMCBCCCgKbYFOKXRmCp1b53bmQomLIhof4LDg++WfWZ/Nl0xmzpe/SDTL6+rFHVQAWmpRFBSbV2xetrnaSES3vK6Hz8/7dAAXxlkUBcXm5b+jE0QRgKJ/oyj8F0W8oAJQ09gSPI2iTASZ8H9Gt7w7DxBFAFoamoPucZWXCS+dDicRTiS65aGvCEBPvT/getWzBHKiVXtqpou+IgA99U0B16vyYi2HhBMJVybFsqWZbif6igDU1K6Ds7xxNjnOyHGGojnoKwLQU+drqxju1LdSYqmUWColFoXYIh9bEHaLOkpSAPTU+drKqjMU3wvF84NRdiDK9k/m+sK59ayCKALQU+cLlFVnKJ5/HcsPfGQHovm+SfZVeHctK6OvCEBPfVOgXHHeMoUhphBKFELxvcFYvj/Kru8onffw2QaAlgZ/UNTckdni8OzB8MzBu+T+m+n90FThR65yqxslKQBaGluCku6OzZdG54XRz8L7T/zIHDc8V/xV0G7jFz8ANZeu3JANb2Kp/OFreXzxaHzhcGzhcOxLaevA6OrFzgwAWi5fvamYx5FVObIqh1ek8Io0sSxNLItZ3rz7CJukAGjxXWtXrePYd6020XU1uqZG1tSdEsF+RQB6mq63q6TKbJrMpjn100xsGPENI7ah547s7sfYOgxAi7+1o0KqyTRJpq3ptMVsmcyWyWyarOj2PHlx3qcDuDD8rR0VcpLK2jNZO5mpDZlOE1b0ep4iigC0NLd2aPbJ3LaT2nZSWSeVcVIZZyZj5yXv/rOX5306gIviN+SjHEcdBto3AAAAAElFTkSuQmCC" alt="" />

OK已经达到要求了,不过在使用的过程中,有一个小问题,就是自增列的处理,原生态的实体类代码中,将自增列声明为[Key],而我自己的用的是Linq的[Columm]

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQ4AAAC/CAIAAACAMqWWAAAKHklEQVR4nO2dPZLkNhJGeR9dQNeUWafYwyhizDXGkCFzXRklo3cq2EBm4gMI/iT5XlRMsMkkAFblIwBWN2Z5T+W1Qolc/+gdKo7G+4MyW20HiFjmFjecnXEwqsDpTFZlzVxVzP7KVMWjq/EABTl6Fb0KehXYCVQBkJg/ABsb8KAKXJwd5ypdiE/M4idjZiHMVWAKV1EF4OKgCoDE8vff/+OV6LUsy39//nnA6/QrvdoLVZK9UOW0d/7sbg36WJbl518/DnidfaGX4xxVluW9WDV/7fcObazxGIJLmFT+8tsf/1m/fv71w9tGlYmc1qsEyXRYWk+v+nP6rqp8pXIhw/rH7Z6gSg2qzKz6gJajylnM/Gw/Y4/1CCTeNscqxZ4gTBnt1DGfH732NBtQl9B1utd47XL6VCmGasXOYs96I2rEI5l8Gyw++N6d5o/NGOVebmaqUpR3VJHcO733DfleYIcq+s61JPQqJndQpbdhQe1x39XMZq9VdU8bxMQdy1ivUkR6XQ0DsABU6ehVmvvjnU1VFMbmKspMBlVi7qDK2ABMLEqP1E+/7AAMVQLmq9Kcxdbz4CDM27nerzepqHodUMSbJcSXqV+713jliszvVeLJejAGCyIbb+vz2LFXgT3g2/qzmJna4m0etoAqZ8GvSyZ78euSp73zp7eAV9frGE9QpX4xWgKQQBUAib1UWZZlYYIPN2JHVXYqGeAUUAVAAlUAJFAFQGKXhMYTuB/0KgASqAIggSoAEqgCIMG39QASZDOABKoASKAKgASqAEigCoBEGlWWX1ywNHgCaXJlndafFas+29vLBIhJkytFWn/0GPakLhMgIE2umKps8aQuEyAgTa7UqpierMdmb2uotj4LVUAnTa6YqhS2rH80R2hFPKqATppcUQZgxbrXcXBdJkBAmlxRpvXe1AVVYDtpcqVXlWBs5pUJEJAmV8TvVcw5zBtVYDNpcmXL9+vm0Itv66GLm+eK18kA9HJzVQBmgSoAEqgCIHFnVV6v12Fnwe15riqv7wRnvXx2aTdckhyqDKTmV7B4SlMVMRJuTAJVBrKz9xRUgSY3VOUTU28UYQzAQCeBKm95NBUkfZ3ZXmn0KmCSRpWBu3gcjyrQRQJVhrOzqQoDMNB5rip6FfQq8EYVpQpUgXcKVd77zFW8SFQBkxyqjCE+MYufjJmFMFd5IHdWBWAiqAIggSoAEqgCIIEqm3jgWhYPvOQv0lzz3E9n+Y55VCxnZrOS8NCrPrsBk+n6EIOP/BRVDsvAjRWhyh1AlQMqQpWLsiz/fxV71hvrsCI4LNkees0dgJmtKvbEjZcbc1hFCdJmOmmuufh0io/fC2uVuXg/ag5IntQNU7Z7McvZo6JfJaTJnFmkueBalea2UOYmVZQwL2u9HmALdUexW0Vp0mYiaa45qSpvJ4O9yO0o7waqDJDmmpOqYh7PPgBDlYtSjyLMqWoR3yrT/l4l/r7FLEdvvLnfjO+t5ciK9LCb8cRrnkjTqCn38sNSU7w7oArsgndfh1zwAQJIoAqABKoASDxOlbE/iOfP6AFVyqOsowcmOVQJsnBgZTDxFFY8gjUJVAkSsesu3pvQqAJrEqsy1kXUG0UYAzAwSaDKGjHji1MC2epuKq7XK6dZAmQnkypmRvamZhyPKuCRRpVZqdlUhQEYmORQJc7UjUUpkfQqkECVsSHT9nhUgTU5VPH6kIGOBVVgjASqzEV8YhY/GTMLYa5ybx6nCsAYqAIggSoAEqgCIIEqOXjg4g9Xu+QLNWVXJr7n66WPuhY43ljp3lVckEtd9YWa0suJb+Naj2M+TpbcP50LNaUXVNlQ2sTCdqwIVbrxVpf01pWs155shpkV+e1Zin8/+wuLvLUqe0duwwtMmitx+ktOiqtLHlbRhfLzQk3x6Fp418tyU4niUL3hN8lQxVzyWI9sVteKMRrf9daJmOXsUdGvEq6SoldpR4y36q4Z6ZXg/ThLlc+henhWq9K1MnJdixVgND7ofrcQ98ZTK7pQfl6oKU2CdI93xueaY7NWS74lvbl/vRH0KiL6AKzY40VuR1ECVQ6ldwDWLMQrR/9cTFX2G4ApYc13I+MADFX6CGeH7njD3Pm1f7EmoHFF3ys1hljFoWJ89fm3HoPJb0JbFbPx4lsn1nJkRXrYMVyoKacz8XY4naZXUxp/WGqKDzNQ5boovcplSd3468P7CiCBKgASqAIg8ThVxv72nb+YB1Qpj7JkHpikUcVLwYGVjcRTWNwI1uRQxbtbd93FexMaVWBNDlXefrL2dhH1RhHGAAxMsqoSZ3wRGfQAXrFx7XU5zRIgO/dXJS5HPIoqkFKVLanZVIUBGJikVOXNfxoBh5NVleb+3nLiSFSBHKp4HchAx4IqMEYOVSYiPjGLn4yZhTBXuTePUwVgDFQBkEAVAAlUAZBAlflcbf2EA3jCJae5vD0+iJ0+3dsnjcntr/pul9f1eaVQ5bAMvNPydntwt8vrXSFyjw8YVW5JgsvzFoxcb6zDxLWw4sW5zTUj5QYPrtFoLnvpr9ooLtB4WEUJcmkLaS7PXPazPrSlV2muKSyuiSjElBvidi9mOXtU9KuENOk0QJprq1VpbrcKNHqPYmMdpncs+lLc5p2+7gG2ECwuPLuiNLk0RprLm6tK0G/UQ7KeZqqnmBnsRW5HeYtQJSbN5R2givlh9w7AlDDzePYBGKqcTz1gMGelRXxY4Lf/zqHe9ub6coPbqphzaH9iPTjbPqwiPSwvN7+8LgY6EK+c+PQp9/LDUlN8mIEqz6K3A9lQUbv3g0vBZwUggSoAEqgCIIEqABKTVXnCkxB4JvPTGlXglqAKgASqAEigCoDELmmNLXA/6FUAJFAFQAJVACRQBUCCb+sBJEhrAAlUAZA4X5V/fv+9GeC9jm/MxnjIy9GqmLkVJ5x31CtKeXnloAp4nNCr1Ok1V5Wuwt89qgx4CLfhNFX0VOtKyqDHiNujx/eWD/fg/LnKh67ew9v/2amrNdxLfJxvXhrcgDNVEXuAYVW64uO64hOx5Qkcp4p5nw4y2zxRH4ApqgxMbNZh2PIozp/Wzx3G6AMw8alAHeAZwpz+3pyvirnnLT9u0rup3im+2R6lBIS5Jeer0tWrKHd9L3JMyI3tgdtwsirKcL9rStD7BCyoSwxjxvIQzlRl4CFVM/uHZ+pKsNny4WdokIszv4L0DgU7BwZgykM2sfy4qK6KIB3n/A6YnkxF/Ma7/sa5B6o8mUNViYdS9bCqznIllYvTvQFS7xO2upyBuRDk5UK/2FJgzjr0VPYKARjjuqoAXApUAZC4tCqv1+uwswBiEqvy+k5w1stnl3bDHdlLlSILB1LzK1g8pamKGAngsYsqwW1+Sur3xqMKbGe+KnVvMJz39UYRxgAMDmOyKmZy66rE3VE9qIvb0GwAqoDOtVTxSus6iiqwBzNVUTJyrioMwOAw/gXxbJLmsRQcQQAAAABJRU5ErkJggg==" alt="" />aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAu4AAACgCAIAAADcsn6oAAAPoElEQVR4nO3dPZLbOBoGYF3Cp5gL+JoTOt4DzGG2asINHDiYcNMJtIF3ZDYBfPzAf6ifp1guCQ2SICgJrwm2+vEEABjW4+oGAACsJ8oAAAMTZQCAgYkyAMDARBkAYGCfMcp8//HnOcvVBwoA70+UEWUAYGCijCgDAAM7L8o8bpOavv/487ff/5guK2JKdd1ZYb5Jj8fjcWQHTbf/+GhWclwbAOAIYwxd+46w0+SRTC1ByetxWdh5jMeei9n2W0+lGQDGMsa4dbcoU/3pe0SZE1oCADtaOWg9Hh+WWfn0wbRyuXr509bT2Raqm01qXVz5+XQ6QxTPQwWTU+uiTDnLM5sDKivH1VqbffZEGckGgDtbP0rNosn0cXXsK4NI+TjYZnLvGa3LLbMQ03tVpizpalUrTMQppEwzs8LqWvFT2QWAgRwSZRbrx6tUr+KUW2tdrVkURJnFx4tRZvq0q1VBlGnVr8aXpygDwGdyWZR5lbQiTv6qTK/josysZleruqJM8gKMKAPA27tXlLl8gikZZRZ/g+nQKJNPLSuijBwDwFg2RZngft5WYTDNFFeurrtidunZ+F6Z2b29s1t6F79CprrNrlYFt/3GN/OWdcrH0wpxSbVhXQcCAGfa56rMWILZon2Xqw90H6IMAHe2cpRafUXkDq6NMq1LKQDACp9xHHVVBgDehigjygDAwD5jlAEA3oYoAwAMTJQBAAYmygAAAxNlAICBiTIAwMBEGQBgYKIMADAwUQYAGJgoAwAMTJQBAAYmygAAAxNlAICBiTIAwMBEGQBgYKIMwB39/fWr5ZLl6jNPN1EG4I6MqZfQ7SMSZQDuyJh6Cd0+oq1R5vGPXVqzoxs2adG/vnx5/Xtno7Qz7z2OKG5/66fvcexvyZh6Cd1+uerwHYeNHaLMrOS33/94LcGKmTp7teoxccTudlGOKP/68mW6HLHH12bLfbV2vWXkq56I1nl5fLRid0lHjOWtrmudyu17z+yr3Mv2Y199jvLnd1pnsX61Qm8LH4//LxvrbPRzTE121Ir3y9Gfh+WJO3R3e3lFmRU9PyuM6+/b7INc1dSg9+rl++5vGk0yMeWEKJN5fAfVQWWWbA7a6eLTshmrG/Pq9sVz8foEbFXYy3GXJXZPLcG6rZdK/BLa62w+V52j/OrTz9PMjoJXVGLd+YNM5SNMLw/0HvVNPt+6zlrPZnfc2NzsqkxXzyc/1pKbPcLG92mjwtrW9O/0jCizIpccEWXK/5Blqt3TTaLMjnuvvtXj//Hsst9LnBZl8idux1fR9lNz8yize+VebxNldm/MbaPMM/xYu8NJGSXKtPZ7cZRpTSfNruK8nr4eT6erWj8NmlQtCS4bBtcJq+XBlls1H4Wyu16qszyzOaCyclyttdnnpVGm1Rutniy7cfFsdvX8s+ilYL6vNXOUiTLJ8xvPNiav1sQ1ewUdWO35Z/tNFJ+4175m/5bbj9vW2vWkeR+Wj+vWp5OqJWXl1uqxOMqUvVf22LPR+dUe7jods21+7Mb54/LQypaXq3edo9fT8sHs8XPpdCxGma6eb1XLdMiz1oGZ0xFss1y9us2y/eefjmp3tfrwjCgTzDoFT6fBZfbvs8g9rSZNC8vzFBxL9YUS14xf1q2GxYKZgkzsmI2F8Tbjp6ddlYlPU371I3p+Oh2zoj/zhdUT11q3q/yEKNM6Hcl3SlA4/bdVM2hb8mUQ55Uy4izWDFaPBVEm6OTWmFRuv7rNZCfnPxV7Pz/LhtVaXi/c5XTEUWbLR9BBb5ln+nRU23Db0/FZokxrI0G/rzijwQZn79LWi6D1+ZKRv+nhVb44Cg4dZV4liydrY88/23mxen9J5ipXvnDFed9SuE7cq613x3PpvFdPXNco22pb8mXQqvVoXK2pVquuWP4olrkqMytptDxVXu3k6b4WPxVb783W1qrbzJym1tgZlEzHzvh0JK/KtOoEr8/yRT57mnnLBF1XytTM773loNPR9S4WZZZ/GnforObih8uj0Grts3NIS16A+TxRplwx3/MvZSeUUabat+XTfOH2KNN7/WaFzBtt8XM5Lqz+dN3LpqzfHhWqR1T/aZB7FussytwrkxzPMuXTd1bv+7TcQu+65eqrz1G1pHUGS8l7Zbo+gpKfWovb7zrFyc5P7v3807HYsA/lzc3kzLYbZJHycfx0dZR55l4x8RldUTP/cszLD2n51LIiyiyOf/lksPju6h2TWqsf0fNnTjAtPs40OLPr0oqz+Vzq+b0Kp23b+LJpSX4ELz6tflhPCpc7ecUEU3U7W6JM1+gbtHPL+722l1ThutOxZYIpn29WJKHMWos/XTGcLZ6U3U9HsNOTosyzcYdvWVi9n7csn97h21qr3N3sNJQpcvqjsiSz+uOjTM1K94Vad3q2bv+c1S8nm2aPpxXiksWmJg8w05nV8nI7W1bPCDpw2j9l5VZ/5guDE1c+nZZXG7/i0lpXp2XeHbM6wY+q2yyftnZULWkVNg7n19Iq//mjsiSz+qzlQUue4ffKBCXFEVUOvNVvz0mUCXov6MzqXsrjzaweK/oze+KeS6cj/l6ZTEmmvDzw6jbLVcptZhpQ1g/2Hq9ete/peF4SZTLHeb7zmzR7rZy898uddsjVT4Fzdn1zcVLpmlrSpSdY7OThvnZ248vm2lfda+/Ddfv7qb4S4rDhA2tPtw12hzrtkOP/OpzQgM9AZ54g2ckDjakb34bXvotnux6o23nxmQVwR8bUS+j2EYkyAHdkTL2Ebh+RKANwR8bUS+j2EV0QZb59+3baWgCDMqZeQreP6HZR5ttHwVrf2g5pN8CJjKmX0O0j2hRlVkSHn5WTqyxGmWRNgOEYUy+h20e0PsqsSA+9q4gywKf199evlkuWq8883c6LMq865YNZNRNMAEDSPvfKZG5/qVYuk0drU67KAAClHaJMb3RYzD3JclEGANgaZVbkhswlHBNMAEDG1t9gOnQtt/0CALF9bvs9aEVRBgCIbYoy6+Z0RBkAYC+3+7bfZ+Ob9zK/6OReGQD4bPw5SQBgYKIMADCwx19//fc9lv98//c5y+VHarFYLBaL5bWIMqKMxWKxWCwDL+8zwfT9x5/nLFcfKADwy+FR5vF4Pmo7+Vne+tEK33/8+dvvf0yXFTGluu6ssOfYP1hzVIntt/Z16K4B4CbOGOSCkXTHQXaaPJKpJSh5PS4Lu1o1jREHpZnMU2kGgHclyiz89D2izEF7B4DLrRzeXtND00mi+HF1OmlWElQLJqR+al1c+fl0OkMUz0MFk1Prokw5yzObAyorx9Vam32KMgB8PuuHt+nIOE0tycLq08U6vVGmDDG9V2XKknaXVI+lHibiFFKmmVlhda34qSgDwFsaLMoEgiiz+Hgxykyfplrzq/HNKNOqX40vT1EGAGpEmeUoM6uZas2vxndEmeQFGFEGAF4GizLrJpiSUWbxN5gOjTL51LIiysgxALyrTVGmeitueUdwtWZZrVU4LQ9U7+ed3ds7u6V38Stkqtvs6aIPquVB/dZdwNUtxyX5NgPAWPa5KnMHwWzRvsvVBwoA/LL1l7HvQ5QBgE/In5P05yQtFovFYhl4EWVEGYvFYrFYBl7uNEUEANBJlAEABrZDlPHrvgDAVfaJMts3AgCwgigDAAxMlAEABibKAAAD25pC5BgA4EKuygAAAxNlAICBiTIAwMBEGQBgYL7tFwAYmAgCAAxMlAEABibKAAADE2UAgIGJMgDAwIaPMn5/6racGgBOMPxI8x6D5dGj/nT7j49mJbvvd98NAsDMGCNNMCDuO1heOPIePerPtt96und/jvECA2BcY4w0oszu2w+e7tgSUQaAo1050jwev5aysKxTHRYXB8vXiit2tPg4eNCrOsszmwMqK8fVWpt99kSZLXFElAHgaJeNNNNYUBYGjz9uJNX+Ml7kdxTULLdZPaikVpiIU0iZZmaF1bXip+aYABjI7aJM61JNezvLh1ANKMkdbQ89SUGUadWvxpfnnaKMHAPA0a6fYJqVtGq2N7IyyqyoeZ8ok7wAI8oA8PauvyrTKjz6qkxyRzeMMvnUsiLKmF0CYCxXRplyfmdaXq1f287CIWzfUTkbVW6z+rRLcNtvfDNvWad8PK0Ql1Qb1nckO63Ljv7++nXfyn9//dpaklvON6mr8au3ecRegHPc4qrMlvGuNQCzl9Xd69RcpToq7xsdWnWCdWdZ5+eDxX1tzFX5dooyMK7r75X5bINd61IK7Gj1UL0xYVT3W00Vs0zTtZe8fKoTZWBcxlF4Q69EsvpaxeJUUe8EU1eUWTeBtbjT6par5V17Aa4lysAn0nUJZMX1khVRZq/tJ+tXm9HVNuBuRBl4Z8lB+qDy+C6W4EKIKAPkiTLwPqrJYPGulHgg32sC6LZXZVbfVwTcxPBRxp2zJ9PhQ8hce3imB/Jdbh8JokzmjpYgKuUv9gTNiNsD3NnwY1I8rB497ua/weW4NoTNO+R3xESZ+9typSG+srJuwuhZxKnFKJNvW1fyCNq5ePkKuKcxxqQt3/Z79Lj7KL68rvr0wuFflPmEkldlMuvuVb8rNxwaZVpPRRkY1Bhj0htEmRNa0iLKfEKtax6ZQbq3TrJ+17xV7wTTYgNalbdvELjcLb4ib/bNv9U/CLDhDxdUZnlmc0Bl5bhaa7Nle5JRJv+9edW/n1D+aLbKbPXycbh69EeguKfgAsPiOL0iygRp41UStySTMFrlXUckysD7ucWsx3RwjSsUG8n8Lcnmn2nMxI5Zsom3GT/dKwF0dV38NLN6ow3SzK0FM0pHRJl8k1otFGWA1a6/KlOWVC/VtDfSMcGUCRblhZlylRtGmdfTaq8urr549evjFuSYW+u6M6a1en77K6JM+fjMKLPvjBVwuevHpNzVl2D1PaNM8gLM7lEmP8H0T/1f/84Kg/LyaWuVpb1f/7KhJR624yG83MLi9hfrz6olb5rpbXZ8pMmrMhsjIHCVsSeYnrtGmXxqWRFl9h3+yyhz5gSTKPPeulJOMnP0zmp1XZXZkRwDI7oyyrRmQxo3n9aH2EyUKS91BDftVk1/Wq25WLLYIb1aXfSo3RdcTtiV5e2ed9svAPc1/Jh0UFDgpZr2rmoMAMy8z5jUe7sJAPAGjPcAwMBEGQBgYKIMADAwUQYAGNjOUcb9tgDAmY74vhNRBgA4iSgDAAxMlAEABibKAAADOyR2SDMAwDlclQEABibKAAADE2UAgIGJMgDAwHzbLwAwMLEDABiYKAMADEyUAQAGJsoAAAMTZQCAgYkyAMDARBkAYGCiDAAwMFEGABiYKAMADEyUAQAGJsoAAAMTZQCAgYkyAMDA/gfDcSSkKGmAYAAAAABJRU5ErkJggg==" alt="" />

我在KeyPropertiesCache方法中将其进行了修改

Dapper使用
 private static List<PropertyInfo> KeyPropertiesCache(Type type)
{ IEnumerable<PropertyInfo> pi;
if (KeyProperties.TryGetValue(type.TypeHandle, out pi))
{
return pi.ToList();
} var allProperties = TypePropertiesCache(type);
// var keyProperties = allProperties.Where(p => p.GetCustomAttributes(true).Any(a => a is KeyAttribute)).ToList();
//因声明主键的方式不同,对自增列进行排除
var keyProperties = allProperties.Where(p => p.GetCustomAttributes(true).Any(a => ((a is System.Data.Linq.Mapping.ColumnAttribute))
&& ((System.Data.Linq.Mapping.ColumnAttribute)a).IsPrimaryKey)).ToList();
if (keyProperties.Count == 0)
{
var idProp = allProperties.FirstOrDefault(p => p.Name.ToLower() == "id");
if (idProp != null)
{
keyProperties.Add(idProp);
}
} KeyProperties[type.TypeHandle] = keyProperties;
return keyProperties;
}
Dapper使用

关于Dapper的使用,用官方给的原生态的代码就可以实现了。一般用的时候,框架都会对其进行二次封装,以利于项目的开发。

上一篇:【PHP绘图技术&&验证码绘制】


下一篇:macaca自动化测试以及配置环境问题