{"id":17,"date":"2009-06-29T16:31:03","date_gmt":"2009-06-29T21:31:03","guid":{"rendered":"http:\/\/www.johndhutton.com\/?p=17"},"modified":"2015-07-06T12:23:05","modified_gmt":"2015-07-06T17:23:05","slug":"mysql-from-net-thanks-andy","status":"publish","type":"post","link":"https:\/\/www.johndhutton.com\/?p=17","title":{"rendered":"MySQL from .NET &#8211; Thanks Andy!"},"content":{"rendered":"<ul type=\"disc\">\n<li>Download and install MySQL Sever 5.0.77\n<ul type=\"circle\">\n<li><a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#win32\">http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#win32<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Download and Install MySQL Server Tools 5.0\u00a0 (gives me SQL Queries)\n<ul type=\"circle\">\n<li><a href=\"http:\/\/dev.mysql.com\/downloads\/gui-tools\/5.0.html\"><span style=\"color: #800080;\">http:\/\/dev.mysql.com\/downloads\/gui-tools\/5.0.html<\/span><\/a><\/li>\n<\/ul>\n<\/li>\n<li>I Verify I could load up the tools and connect to MySQL server.<\/li>\n<li>Get out of Visual Studio completely.<\/li>\n<li>Download and Install MySQL .NET Connector 5.2.5\n<ul type=\"circle\">\n<li><a href=\"http:\/\/dev.mysql.com\/get\/Downloads\/Connector-Net\/mysql-connector-net-5.2.5.zip\/from\/pick#mirrors\">http:\/\/dev.mysql.com\/get\/Downloads\/Connector-Net\/mysql-connector-net-5.2.5.zip\/from\/pick#mirrors<\/a><\/li>\n<li>This may take awhile.\u00a0 It took about 10minutes to completely configure Visual Studio.<\/li>\n<\/ul>\n<\/li>\n<li>To add the Reference in Visual Studio 2005, I did the following:\n<ul type=\"circle\">\n<li>Project \u00e0 Add Reference \u00e0 Scroll down and pick MySQL.Data<\/li>\n<\/ul>\n<\/li>\n<li>To add Imports to the page\n<ul type=\"circle\">\n<li>MsSql.Data.MySqlClient<\/li>\n<\/ul>\n<\/li>\n<li>The connector looks and feel like MSSQL.<\/li>\n<li>.NET documentation is located at:\n<ul type=\"circle\">\n<li><a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/connector-net.html\">http:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/connector-net.html<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>From my twin, Andy Hutton. Thanks for the info!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Download and install MySQL Sever 5.0.77 http:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html#win32 Download and Install MySQL Server Tools 5.0\u00a0 (gives me SQL Queries) http:\/\/dev.mysql.com\/downloads\/gui-tools\/5.0.html I Verify I could load up the tools and connect to MySQL server. Get out of Visual Studio completely. Download and Install MySQL .NET Connector 5.2.5 http:\/\/dev.mysql.com\/get\/Downloads\/Connector-Net\/mysql-connector-net-5.2.5.zip\/from\/pick#mirrors This may take awhile.\u00a0 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-net"],"_links":{"self":[{"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":3,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":20,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions\/20"}],"wp:attachment":[{"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.johndhutton.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}