在VS的EF中连接MySQL

时间:2021-06-04 02:56:54

VS没有主动提供那些繁多的连接器,需要的话得自己再安装这些第三方程序包。

MySQL为windows平台开发者提供了许多程序包:http://dev.mysql.com/downloads/windows/

其中就包含为VS提供的连接器:mysql-connector-net-6.9.8.msi 以及 mysql-for-visualstudio-1.2.5.msi(数字仅为版本号)

=====================

步骤:

1、下载和安装mysql-connector-net-6.9.8.msi 以及 mysql-for-visualstudio-1.2.5.msi

  下载地址 mysql-connector-net:http://dev.mysql.com/downloads/connector/net/

      mysql-for-visualstudio:http://dev.mysql.com/downloads/windows/visualstudio/

注:各个版本支持的连接器参考https://dev.mysql.com/doc/connector-net/en/connector-net-versions.html

2、上面两个文件安装好后,打开VS,打开解决方案。

  然后在菜单中选择:工具—>程序包管理器—>管理解决方案的 NuGet程序包,左侧选联机 右上角搜索 MySql.Data.Entity,然后直接安装。

  安装完毕后退出,再次打开VS,打开解决方案,新建edmx文件向导,更改数据源就能看到MySql选项:

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAb4AAADpCAIAAADUE8VFAAAc0UlEQVR4nO2dV9QcxZXH59kY44BZ47UB24gcTTLRQ7BJNtlEAyJj5QRC+ZOEkEBCEYEkhJCEJHLOOYMIawsoHNbGmAUMNjbsWT/s7tmH3ocW7VbdW7dup5rumf89v6PTU1N1q6qn+zfVPfONWlEUmXVrAQAAeOnr62u321EUtRJ1fmHrATEb9RuwUb+BG20z8IvbDPziNoM23nbQxtsO2ni7wV/abvCXthu8yfZDNtl+yCY7DPnyDkO/vOPQL+849Cs7DvvKTsO+utOwr+48/Ks7D//azsO/tsuITXcZsemuIzbddeTXdx359d1GbrbbqM12H7XZ7qP+5fuXxHxjj0u/scelm+956eZ7jt58z9Hf3Gv0N/e67F/3jhnzrX3GfGufMd/+wdhv/2Dst/cdu8W+47bYd9wW+43bcr/xW+4/fqv9x2+1/4StDpjwnQMmfOfAid89cOJ3D5r43YMmfe+gSd/74aTv/bBv63bf1u2+fu3J/Q6e3O/gydscMmWbQ6Zse8iUbQ+duu2hU7c7bOp2h12+/Y9ipu3w42k7/HjaDodfsePhV+x4+BU7HTF9pyOm73Tk9J2PnLHzkTN2OWrGLkdducvRV+569JW7/uSq3WJ+OnP3n87c/ZiZux8z6/vHzPr+sbP2OPbqPY67eo/jrt7z+Nl7Hj97r+Nn73XCnL1OmLP3iXP2PnHuPifO3eekufucNO8HP4uZv+/J8/c9ef5+pyzY75QF+526YP9Tr9n/1GsOOO2aA05beMDpCw88feGBp1974BnXHnTGtQf9/Lofxpy5qH3movZZiw4+a/HBZy8++OzFh5y95JD+Sw7tv+TQc64/9JzrDzvn+sPOXXrYuUt/dN7SH513w4/Pj1l2+AXLDr9g2REX3hhz5EXLj7xo+VEXLz/q4hVHXbzi6F+sOPoXK48esPInA1b+ZOBNP40ZtOqYQauOGbzq2MGrjx28+tghq48bsua4oWuOH7rm+KE3Hz/s5hOG3XzC8FtOGH7LiSNuOXHErSeNuPWkkbeeNPK2n4267Wejbjt51O0nX3L7yZfcfsqld8ScOvrOU0ffedpld5522V2njbnr9DF3nT7m7jPG3n3G2LvPGHfPz8fd8/Nx95w5/t4zx9975oR7z5pw31kT7ztr4n1nT7z/7En39590f/++B/r3PXBO3wPnTH7w3MkPnjvlwXOnPHTelIfOm/rQ+VMfPv/yh8+//OELpj0Sc+EVj154xaMXTX/0oumPXTT9sYtnPHbxjMd/cWXMEwOuemLAVU8MnPnkwJlPDpz15KBZTw2a9dSgq58afPXTg2c/PWT200NmPzNkzjND5zwzdO6zw+Y+O2zes8PmPTd83nPD5z83fP7zIxY8P2LB8yMXvDDymhdGXvPCqIUvjlr44iULX7zk2pcuufalS6976dLrXh69KGbtZYvXXrZ47WVLXhmz5JUxS14Ze/2rY69/dezSV8ctfW3c0tfG3/Da+BteH7/s9QnLXp9w479NjFn+y0nLfzlpxS8nrfhV34pf9a381eSV6ybftG7yTeumrHpjyqo3pq56Y+rqN6eufvPyNW9evuataWvemnbzW9NuNlfcEvP29Fvfnn7r2zNu+/WM23494/ZfX3n7b668/TdX3fGbq+747VV3/nbmnb+deefvZt71u1l3/W7W3f9+dcw9v599z+9n3/v7Off+Yc59f5hz3x/m3vfO3PvfmXf/O/Me+OO8B/44/4E/zn/w3fkPvrvgoXcXPPSnax6OeW/hI+8tfOS9ax/9j5jrHnv/usfeX/T4+4se/2DR4x8sfuKDxU98uPjJD5c8+eGSp/58fczTHy19+qOlz3x0wzMf3/DMxzc8+/GyZ/+y7Lm/3PjcX2587q83Pv/X5c//dfkLnyx/4ZMVL36y4sW/rXzxbytf+tvKl/5+08t/v+nlv696+dNVaz9dtfbT1a98tvqVz9a8+p/BSKvTrFsLdUKdUCfUCXVCnVAn1Al19ow6oyzRbrdjCeZrVZU6425c6oyi6L/+8d+xOuOaVJ1xuaDOuMKW+48X5gl1Qp1QZ0+pM9M9ykSdOVp51KnR8CbbD7FKBHVGUfT+nz+N1RlF0QcffepVJ9tpvOqMouiDjz+LouiTT/8RrzrjZ7HqhDqhTqjTrFvbSkVQdVqrzlhMwqrTq84cq854I1l1ptUZX7An6lzvTVywQ51QJ9T5uTfptqBOKtl0STZ1epecgjrTsemuI2jh62/+ySrZfM/R6YcffMTfv6DqpHWgTqgT6oQ6M6lT30qrTrrqFNQZR/wx0XpvpladcUm86oy3k7WnvOqMN9h7nYk644+JoE6oE+qEOoW1pHzBrrnML2fVaRW+uu7dxJ6WOq2asTSTO55F7nXSOlAn1Al1Qp3UgJp7nd5W5aw64232E/a0OuPt5F5nIk1BnckFO111shfsWHVCnVAn1FlQnaFXnVSdcVgfE8WFyfc6qTrTbeVVJ+51Qp1QJ9RZ7peTKr/Xmf6EPVFnvBF/JX69N1OfsFO7Zbpg937CHn856X/+9//wCTvUCXVCnTlWnWV+wr5Rv/X29KpzvTfFVWdcstlu//yAKP39JKrOKIreee8TlzqjDe91fvjxZ7E6seqEOqFOqLPIvU7vWlWlzo36DUxExv41UfJsfMEeb8ufsEdRlP5ep2vVmVZnOti/JkqvOtfbE+qEOqHO3lZn1gv2ctSZtlWy6rTCute53pupv2Ffb8/UBXu86nz/8+v0+G/YP7fnaHK78/MPiLgL9vhh/Dfs8TYu2KFOqLNn1dmnjrQ6c7TSrjrx8x9QJ9QJddZcne2MEUswXyuoE+qEOqHOLlEnfnQO6oQ6oU6oszHq7Ovr+6c6AQAAyMTqbLfbUCcAAGiJ1dlqtaBOAADQwtzrBAAAIAN1AgBAZqBOAADIDNQJAACZgToBACAzUCcAAGQG6gQAgMxAnQAAkBmoEwAAMlNUnekfYaY/yOwqpM+2HNHxHQQAAJT86oy9Rv9lqxlOjjSP1UToV18OAAClE27VSf/LJE01IRtdmcKeAIAw5FQnu4TUP6QX42wd2qm1YXxGBgCAKii06qTX3UaxnGTFp7ls16xMYVIAQABKuNcp6M+s4y+xXa2Uq06rX1cdAACoiPwX7OkN+m+6plUuKE+56sxUAgAApVP0gp0+pMtM62Hxe53eMQAAQKWU8zFRUmjcLrNsKCjPpT923Qp1AgDCU/Rep9FdZQvX465Lfvm6Xli6yiUAAFCc0j5hN+Kq03U9zq5JWSlbCfXloEdwHTauW0ZsCQBKCl2wJ9vGvaJknShvew/iFomO70dQB+R3X/ltHkcRyAR+/gP0ClAnKBGoE3QbrosSVp24dgH5gDpBN+BSpOFuH6XvddJqAGjIqc4+BKLKYI9GtmbyrEadVqFLnYEni6hJZHVgTnW2EYhqwqxb61JnRKKgOtkLdtoLousjqDo7PVlEd4asTtcx6bowz7HqBD0I1IlofJgC6rScaMkR9zqBiw6oMz4Q0xtJecjzLTklstZPmsgP9XkQBcPkVSc1pixHqBMk1EidIYP2K4+EKp6Vvsabyh4R+jCFL9itQlaLLcctUdCbQJ3OEn39fOpElBUmlzpj2KWld73J1gE9RV3UyWo0fWHrEi77MGsdzRU0TUK3NWYUZmptWxvyTqvDG1KnwhRQJwD56Iw6rX/T5fShoFe2jnVesU8J1eSQs+mdJTfPNFOhVY+EgTpBcBqgTk2JvMZk63iTu4JdCWZNEhHlWUtIV6fpEm+rHgkDdYLgdKE6XU8VUSdt67pqlhMq16qutmXZv8vCQJ0gOHVRp7WAooVshYgTCq2pqUOrsSNh89A6rlRy196ZurIJrXohDNQJgoOvxBeNnhVWfcJAnSA4UCei8WGgThAcqBPR+DB51RlfMdDt4riyldiF1VdZmasYYVcCdSIaH6aMr8QXV0aro39ulK+76gZZfwUXHGFdvhIfBf+AOOvnKvQTHvmhPk/I6GzvrpAH4x2wgTqhzuAjrJE6Qwbt13v2Wtus9DXeVPZYRYTvXdOLfBhoxmxKVWf63SVdTT7TXE3kJGxfrszeVGxDYZDKabJNsu4NzT70Don27hpPjrlnBep0lujrt3KpM3yE7125Q4Rq7H62wpStTm8dOZXQyus7b9qsmeUJCskz5cm3N/SvRekbyp0vUBd1shpN3hlcrVwPs9ahTdhz2HUa69Upz9TatjbknebaP1Yv3iEJO8dq7irJuleFgUWO/WyFKfuCPR629dAqzCcLmsGbVjke2rtVh+2FHY88Czlhpr2hH0zWjXxzz0RdvhJPT4wW8RF7rro2hDpyNTnkbMok3uaZZiq0Ejp1ZWZfnXwbrh6FScljdlUz1dzrVDoikyxcqTRdZBKB14nKag1VZ765Z6IB6tSUWHm8XsutzvTIk45yqNNqlc4mDI9OU27l6tE1DPZfdiPacA94kwtDsvIIGapQp1Gv6awSOVW6Plso9MXmFMbT2jCEMbN9pUsyVfDuELZ3zQ50tZJnLU/EO7WsdKE6XU8JfQmnpattOq2yC1cF5WDSHeWYgrd3+roI+1Devfoheat5d2mEr8SDTlAXdSbvCdZpkxSyFSJOKLSmpg6txo6EzUPruFLJXXtn6somtBKasBNvZX91NNU0o9JMkw0DdYLg4CvxRUOjhqZHzSdooE4QHKgT4QnleraDYaBOEByosxejteFtB7lC1oQFn83haBNWnfEbifF9yJC+oWGVsA/1eWpIFWMra8rW60WDPqVJC3X2VrTcnwXRapH7Bq7rKEzXYRPKQ5JrusIU/oS9yKnozZlUps9qvJl7nE2kRT4BLzeta4P+66UuX4nPd84UCeE8l+tTfWRKKCsmTHh3u0tkesHJbqV5ulidtCSfOnuB6tRpaZG1ZKbuaqTOkEH7lUdCXcPaRyMUZY9VBOsv/UNWefJEvPu5Rd54aF/eMMW+Ek8NKDjRcOpMJ6Eb9LRsqdXpGky6UDkebyvNTNPJ2bRsBblceC1yvDreiciZ9TmhTmeJvn4rlzo7Fend7hq5poIQNA9bkj4ShCbeMKWuOls+r6VPQlpZk83bhTxItlNvv5pWQr/ymHP0nu+1yLHr0i+W1bwb1MlqNH0quoTLPsxahzahIUihpVanPFNr29qQd5pr/9COaEM6crpn6B5TTtm10/Ql3jC1USfbpJU6b9lWmc7/dCohDx2PppXcqZUq6z6krXK8FnQW+l3nnXumnHX5Sjw9Z9izVFPHdSpmPYfZkLPpT3u5eaaZCq3kwbteiHQq19TkZ70zzVTiDVMDdQpnJtWlUE0Ym1eUtFDOn1ud3sGzytOIoqw83lnoXwIXDVCnpsTK4/VakTM2GbnXL5o86VTeNwA6TbmV3C+bmea0wmrlqiAPnj6lTMWGKfzlpLg710P2PGxtKES6nQQtpHVcPbqeTRe6mrMl3lbeMdAhCQ+FVt7Xgs2jGbm8r+ieV6bNfXQl9euuTtdTQl9sievZFucaTReuCsrBpDvKMYWIGIqdDh2bZsyarpXl3lQ0TD2+Eq886zKdn11Dy/Ee01zqok7rfKaFbIWIO7dpTU0dWo0dCZuH1nGlkrv2ztSVTWjlStLihGiVtDZ8jSLu9WJDyKaZlDwFGqbT6oxn3fGTueYkh0fHR1IK+Ep80dAIq1ZB3wAiIixLnVSLbH1NX96GTVQn6EGgzh4K6j55RWmVs61oHdqXdxhyKm8YqBMEJ6g6v7D1AABKxxT7f9jrcyGpGUZ1Ay43M5ukxOQdf8mgTtB4TD3+M+FS0AxDOeYcMwqwN4pnrskr1QF1xhdZ6Q2W9BWZVcI+VCbJR/EMoDpMYXXW5GxUjgTqDP+6UGqqznR5Upk+q9GZsrI3FdRZW0x5f8OebFvXg7QOvWC06hjOy96+0iUuR7CCYwcsjLD0vSHUdw1J05crScE8xWmAOmkJ1AnSmFJXnaxxaGWrYY46Ql9ewXk3aBK2jiuzfm/k7l2zNzSDzJ2nILVQZ/qa2iXWctVJk1OPF6kj9AVKx5Rxr1MoSc5GWYvWaohdHLk22I68Y6bGF+SlSa7ZG/K7hauhS3DWHtPIRC/lSumMOq1/2Q2hvKA65Zz6Vt7BZx0qyIepWJ2ZVpRWqxzq9J7/gVedmhFSI+cQHNTpbJaWCKtO1i/syjT9lIyw6hTUSevo83jXoaBcTOEvJwklVnnyLGtGuoai5zlddrEZXMtDulgTyl355czKvWGVyKnY3ul82YFlmqYyT3Hqok5LOlRq6ac0y0ZaHmDVKTQH1WHwlXgQnHqpM73tWtBZDpWXda5nhfyuOpo8mmGD0jFQJwhOjb4Sr5QLNAQsDNQJglMLdcKGoAgG6gTBqdHPf7TUP1spV0D0WphiHxMZ92cy6WrCZxHBPpoA9aHz6mxl/BEdWZ2QaQ+GqVKd1ie5bIkhHzGDrqfD6myJ/79CElb9aMNfP3PVQfRImFDqpCVQZ8/SSXVajtMsIak6W9wvSMKePRWmPHWmL71dYoU6gemgOlktCuvNiPxErvWQZivrzETUPEwBdRpyGe6yIVsOdfYsnVEn6zVZf+wVuqBOVyGi+8JUoE5WhezKNP0U6B2atOqMHPc6XdnKOCsRDQhTqjoN+cM+tr63GuhuGn+vM9L9Z2GILg5TgTrT2+llplVI61g1QbfSDZ+wszkRvROm7K/EK90HS/YyNfpepyZcV+jClTui68OUp07YECjpvDqTyHHBLtRE9E4Y/CEmCE5d1Olyn6BI10U9otfCQJ0gOHVRJwKROwzUCYIDdSIaHwbqBMGBOhGNDwN1guBAnYjGh4E6QXCgTkTjw0CdIDhQJ6LxYaBOEByoE9H4MFAnCA7UiWh8GKgTBAfqRDQ+DNQJgpNPnX19fVAnoi5hoE4QnHzqbLfbUCeiLmGgThAcXLAjGh8G6gTBgToRjQ8DdYLgQJ2IxoeBOkFwoE5E48NAnSA4UCei8WGgThAcqBPR+DBQJwgO1IlofBioEwQH6kQ0PgzUCYIDdSIaHwbqBMGBOhGNDwN1guBAnYjGh4E6QXCgTkTjw0CdIDhQJ6LxYaBOEByoE9H4MFAnCA7UiWh8GKgTBAfqRDQ+DNQJggN1IhofBuoEwYE6EY0PA3WC4ECdiMaHgTpBcKBOROPDQJ0gOFAnovFhoE4QHKgT0fgwUCcIDtSJaHwYqBMEB+pEND4M1AmCA3UiGh8G6gTBCafOjk8VdDFQJwhMIHV2bkWC6JUofnADoCeQOgEID9QJqgPqBF0L1AmqA+oEXQvUCaoD6gRdC9QJqgPqBF0L1AmqA+oEXQvUCaoD6gRdC9QJqgPqBF0L1AmqA+oEXQvUCaojtDpbrRa7LRe66rQ2DFpH2Z2QJ+vYQH2AOkF1hFNn2mXUa1Y1Q3TGSlAwo6xOK6e3GhvC4JXloFKgTlAd9V11siqkdXK7VVMtk/LoAtY1fhAGqBNURyB1sks2/UO5MOnC2uZWirzO5JzePGzvRrQ/CADUCaoj6KozLR2vX1wVjE95bC902yVBtqNMhUp1wqRVA3WC6ujAvU7LLMqVoEuCQl/GrU65L1cFoWvWy0IdEACoE1RHuAv29Ab9N13TKmcdlBYxu/CkbdmOlG51VWCf0ugVBADqBNUR+oKdPqRLP+thupxd0Lnc6op0HaNwtJyHtoU6awLUCaqjMx8TJYXGvbITloQ0g1DZNR7alzdPvqf0owLlAnWC6gh9r9P4LJOWml6dRfrKUYGVoMvjyuSgdKBOUB0d+4TdiKtOS0OuxaCszqyuzOFWub6+IagCqBNUR9AL9mTbrOPXg+wVPVvHiHpl132unC0uDOdNjQHZVKAjQJ2gOvDzH6BrgTpBdUCdoGuBOkF1QJ2ga4E6QXUEUmcfAlFlsEejqxyA4mQ9uvpyq7ONQFQTZt1aqBMEJqg6IwRCEZmOYKgTdASoE1G7MOvWKmsmh2MEdYKwQJ2I2oVxqFA4HNn6UCeoDqgTUbswUCeoPbVQZ/xXN8kGDfqUkEeuEzI0w6huwOVmZpOUmDydykCdoPbUQp3pM9O1Qf9V5ulsaIahHHOOGQXYG8Uz0wwG6gS1p0bqtLTIWlKziNNUCxZQZ44MJqVC9iqEHo4R1AnCUmt10utB/fUvTZtuS+uwfQkrX1ceV0Oan07KlVnYG17b5t4bQn3XkDR9uZKk65gNVdjaMNjDMYI6QVhqpE567kUb2oQ+FPKw57OVJF3ZapijjtCXV3DeDZqErePKnC7x5snXu2ZvKAdpiApZbxqoE3SOuqvTe5p5K7jypJdFEXEcXQ3RxZHsGlcrYczU+IK8NMk1e0N+t3A1dInS+wpqBmk4FVJvGqgTdI56qVPe0JyNOWThUifbKoc6vSMva90nZNaUUHELDTPNXQ6lOuXDka0PdYLq6Iw66XlI14CadR89CelKjW1C87NmpGsoduSa3l0jp9MUyl355czKvWGVyKnY3ul82YF5p2mgTlB76rLqRCCSMFAnqD1QJ6J2YaBOUHugTkTtwmT5gVeoE3QEqBNRu1D9SGcqDNQJghNOnR2fKuhiXOpEIKqLEOrs4BIG0SOBow4RPipXJwAA9DJQJwAAZAbqBACAzECdAACQGagTAAAyA3UCAEBmoE4AAMgM1AkAAJmBOgHISavbg065Y19VDxKxCpVAnQDkpKX77ecmRrvddqmz47u9IhIVZq2f+W/Yc/9BqPWSsK9QupCtkKmaFzmPpiQp1Lx1g+4gVmfHh1E6sRSgTmX9PL+clOPHb0wudbo05FWe8krEq+CkMPGjt46QLUc5qCFQZzcRVJ3Cgl/Yy3pPyZVdqzyvwpTqdI3NpWCaRPajNVS5X1BDKlWnfBhUepDUXJ0Vzb3W6rSkIwvLqib7zltB3laq0/UUK1PNulJIWNYBAaqjRHWyb/zsO3S6SUXzCqNO14rHNU1ho8RZ56gfaNVp2ZDuO3Y/shZzJWEPPteL1HKokyaRxyMnkavRmtWdFaBEWmWvOtnjQXM800O0CMFWndZ8XXOh1UwF50iT1Onaj+y2q4QebfLx50qVvGDsUUhfWsHC1vAELUKdjaY6dbIl8lHRBeo03Mle6UzprHPU7/yqk92hVrlgPZoqkzrlF0ZuIgxPk4pWhjobQbnqpIc6e3YEIKQ62XPWdQpXultqrU7hvcXSpWBMq4nLPq59zQquoDrpyy+8ulBn11C6OpMDhj22heO5XI/UatUpn+AlDqbW6rR2jVdY8m4SdjdtIm/r1al5jeUZQZ1dQ4nqpNL0arG6g6Q+q05X5dLfLUz91WkcvqDuSB9Dch5hXyu3vTpjX1FrbK6D3ut0eLOhlKhOw60q5DOlO9TJbijfKnpLncJba1KB3UfCjnNJNpM607LWv5zCCynX17wfgJpTqTpd777WmeJ6ey5CR9QpvCW49klT1emtk+9ep2ZHu5KkXwPXGxfVtMvU7CBdLx7No1FtdccBCEAr7L1Oa7u6A6Yj3+ukE/TOt5HqFNab1toTgG6ldHWy/9INYXFQCuH/msi1qJJXV41UJwCgXHWm01oPM10AFadT6swkytIv1KBOAAJRkTo7Ts3/hr3SWeeo350HAQDVAXV2E0p1JnsA6gQgJ7E6Nb9d27iAOlmiKOrfv79VH+oEIButVqvdveFSZ6etXmG0RXXG3oQ6ASgK+1lNNwWdcmdtHiBcr7XlTQN1AgCATNqbuNcJAAB+LG/igh0AADxQb0KdAAAgIXjTpH7HA+oEAID1uLyJe50AAMAjeBMX7AAAwCB7E+oEAAAbpTcN1AkAADF6bxqoEwAATEZvGqgTAAByAHUCAEBmoE4AAMjMP9UZ/ieeEAgEorkRq/P/AbNOjlu9H9kWAAAAAElFTkSuQmCC" alt="" />

PS.

以上安装完成后,在引用中会自动添加MySql.Data.dll和MySql.Data.Entity.EF6.dll的引用;另外web.config中也会添加provider节:

      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider>

system.data节点也会添加内容:

    <DbProviderFactories>
<remove invariant="MySql.Data.MySqlClient" />
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>

在VS的EF中连接MySQL的更多相关文章

  1. 使用EF CodeFirst连接MySql数据库

    如何使用EF CodeFirst连接MySql数据库? 我们这篇文章介绍怎么使用EF连接MySql 作者的环境 VS2017.Win10.MySql5.x 前言 一般在EF中,默认是使用SqlServ ...

  2. 第八节:EF Core连接MySql数据库

    一. 前提 1.安装EF Core连接MySQL的驱动,这里有两类: (1).Oracle官方出品:MySql.Data.EntityFrameworkCore (版本:8.0.17) (2).其他第 ...

  3. Odoo中连接mysql数据库

    how to integrate Odoo with MySQL - Stack Overflowhttps://*.com/questions/31959919/how-to ...

  4. Java中连接MySql数据库的例子

    Java中连接MySql数据库的例子: package com.joinmysql.demo; import java.sql.DriverManager; import java.sql.Resul ...

  5. Django 3&period;0 中连接mysql 8&period;0&comma;可以不使用pymysql &comma;升级Mysqlclient即可

    python 中,连接mysql一般都推荐用pymysql ,而且在django中,网上的教程都是这么连接mysql的. import pymysql pymysql.install_as_MySQL ...

  6. django 中连接mysql数据库的操作步骤

    django中连接mysql数据库的操作步骤: 1 settings配置文件中 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mys ...

  7. &period;net 中连接mysql

    1. 下载mysql驱动.里面包含需要连接mysql的dll.mysql-connector-net    地址:http://dev.mysql.com/downloads/file/?id=463 ...

  8. Eclipse中利用JSP把mysql-connector-java-8&period;0&period;13&period;jar放到WebContent&bsol;WEB-INF&bsol;lib中连接MySQL数据库时Connection conn &equals; DriverManager&period;getConnection&lpar;url&comma;username&comma;password&rpar;报错的解决办法

    开发环境: 1.系统:windows 7/8/10均可 2.jdk:1.8.0_144 3.服务器:apache-tomcat-9.0.8 4.IDE:eclipse+jsp 0.网页代码如下: &l ...

  9. 在EF中使用MySQL的方法及常见问题

    有时需要在网上租用空间或数据库,Mysql成本低一些,所以想将sql server转成mysql…… 注意:在安装Mysql时要选择文字集为utf8,否则将不能使用中文(当前也可以在创建数据库时使用u ...

随机推荐

  1. oracleDBA-D3

    1.静态参数文件 PFILE:使用操作系统提供的VIM进行编辑,包含多个参数文件 参数文件名是:init.ora(如: D:\app\Administrator\admin\orcl\pfile) 其 ...

  2. NXP QN9020

    NXP的这个BLE蓝牙方案也很有趣, 一起研究. 这个函数在app_gpa_task.c里面 ***************************************************** ...

  3. mysql之存储引擎

    1.存储引擎概念 打比方说:一部电影有mp4,wmv,avi,flv...等格式.同样的一部电影在硬盘上有不同的存储格式,所占的空间与清晰程度也各不一样. 那么我们表里的数据存储在硬盘上,是如何存储的 ...

  4. Android Studio 安装后首次启动的 Config path &period;&period;&period;&period;&period;&period; is invalid 问题&lpar;转&rpar;

    原文链接:http://m.blog.csdn.net/blog/hnust_xiehonghao/46127775 1. 问题描述: 安装好Android Studio后,启动时弹出如下信息: Co ...

  5. SAP文件的上传下载 SMW0,二进制文件

    TCODE: SMW0 选择:二进制数据 输入包名和对象名 新建 维护文件类型 文件参数信息 下载: DATA: LS_WWWDATA_ITEM LIKE WWWDATATAB, " LV_ ...

  6. Vue-admin工作整理(十八):Mock的使用方法

    # Mock简明文档           ## Mock.mock()           - Mock.mock( requestUrl?, requestType?, template|funct ...

  7. COM接口调用,CreateDispatch失败的问题

    有一个自动化处理Office文档的程序,原本运行的很好,基于效率和UI效果的问题,改成了多线程处理,编译没问题,一运行就报错找不到Office软件. 程序中产生错误的地方就是创建COM对象失败,以前好 ...

  8. Centos 7&period;6搭建LNMP环境的web服务器

    一.安装软件 1.1.MYSQL安装 下载mysql的repo源: wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rp ...

  9. 002-Spring Cloud 功能简介

    一.主要功能 分布式/版本化配置.服务注册与发现.路由.服务间调用.负载均衡.断路器.分布式消息传递 1.云本地应用[Cloud Native Applications] Spring Cloud C ...

  10. jquery函数写法

    普通jquery函数写法 <script src="http://code.jquery.com/jquery-1.11.1.min.js"></script&g ...