应用程序mysql数据库连接,如何W10通用的应用程序与MySQL数据库连接

I'm writing my first Windows 10 Universal App that operates on MySql database. I used code from this guide (It's for Windows 8 store apps):

But when I try to open connection with my database I get error:

An exception of type 'System.NotImplementedException' occurred in >MySql.Data.RT.dll but was not handled in user code

Additional information: SSL not supported in this WinRT release.

public class DBconnector

{

static string server = "127.0.0.1";

static string database = "hurtownia";

static string user = "root";

static string pswd = "root";

public static bool login(string email, string password)

{

string connectionString = "Server = " + server + ";database = " + database + ";uid = " + user + ";password = " + pswd + ";";

using (MySqlConnection connection = new MySqlConnection(connectionString))

{

connection.Open();

MySqlCommand checkLogin = new MySqlCommand("select password_hash, password_salt from users where email = \""+email+"\"",connection);

using (MySqlDataReader reader = checkLogin.ExecuteReader())

{

reader.Read();

string hash = reader.GetString("password_hash");

string salt = reader.GetString("password_salt");

bool result = passwordGenerator.compare(password, hash, salt);

if (result)

return true;

else

return false;

}

}

}

}

So, my question is how to fix that and correctly connect to MySql database in Windows 10 Universal App.

解决方案

Add ";SslMode=None" to your connection string