.net core Mac上连接MySql的问题

[diandian82]

using Microsoft.AspNetCore.Mvc;
using MySql.Data.MySqlClient;
using System.Collections.Generic;
namespace CoreApi.Controllers
{
	[Route("api/[controller]")]
	public class StudentController : Controller
	{
		// GET api/values
		[HttpGet]
		public List<Student> Get()
		{
            
            var students = new List<Student>();
            using(MySqlConnection connection = new MySqlConnection("Server=local;Database=Student;Uid=root;Pwd=movoto1234;SslMode=None;")){
                connection.Open();
                MySqlCommand cmd = new MySqlCommand("select * from Student", connection);
                using(MySqlDataReader reader = cmd.ExecuteReader()){
                    while(reader.Read()){
                        var s = new Student();
                        s.ID = reader.GetInt32("ID");
                        s.Name = reader.GetString("Name");
                        s.Sex = reader.GetString("Sex");
                        s.Age = reader.GetInt32("Age");
                        students.Add(s);
                    }
                }
            }
            return students;
		}

	}

    public class Student{
        public int ID { get; set; }
        public string Name { get; set; }
        public string Sex { get; set; }
        public int Age { get; set; }
    }
}

mysql 是用nuget加的MySql.data(6.9.9)，但一运行，就报错。
An unhandled exception occurred while processing the request.
FileNotFoundException: Could not load file or assembly 'System.Security.Permissions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. The system cannot find the file specified.

[diandian82]

用dotnet publish的时候看到这个警告 warning NU1701: Package 'MySql.Data 6.9.9' was restored using '.NETFramework,Version=v4.6.1' instead of the project target framework '.NETCoreApp,Version=v2.0'. This package may not be fully compatible with your project. 估计这个是版本不同造成的。哪位大神告诉我.net core mysql driver应该用什么package？

[Anonymous477]

在Nuget中勾选“包含预发行版本”选项，然后安装MySQL.Data8.0.0dmr版本试试