我尝试将mysql数据库连接到asp.net core(v2.1)应用程序的测试代码。我创建了一个示例应用程序并添加了 MySql.Data.EntityFrameworkCore
nuget包。。。
下面是我的代码:
// Context
public class EntriesContext: DbContext
{
public EntriesContext(DbContextOptions<EntriesContext> options) : base(options) { }
public DbSet<Entry> Entries { get; set; }
}
// Controller
[ApiController, Route("api/[controller]")]
public class EntriesController : ControllerBase
{
private readonly EntriesContext _context;
public EntriesController(EntriesContext context) {
_context = context;
_context.Database.EnsureCreated();
if (_context.Entries.Count() == 0) {
_context.Entries.Add(new Entry {
From = "default@from.com", To = "default@to.com",
Message = "default message", Site = "default site"
});
_context.SaveChanges();
}
}
[HttpGet]
public ActionResult<List<Entry>> GetAll() {
return _context.Entries.ToList();
}
// Startup
public void ConfigureServices(IServiceCollection services) {
services.AddDbContext<EntriesContext>(
opt => opt.UseMySQL("server=localhost;database=mydb;user=myuser;password=mypass"));
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
}
模型如下:
public class Entry
{
public Entry() {
this.Date = DateTime.UtcNow
.Subtract(new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc))
.TotalMilliseconds;
}
public Entry(long id, string site, string from, string to, string message) : this() {
this.Id = id;
this.Site = site;
this.From = from;
this.To = to;
this.Message = message;
}
当我启动应用程序时,我得到以下信息:
System.MissingMethodException
HResult=0x80131513
Message=Method not found: 'Void Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory..ctor(Microsoft.EntityFrameworkCore.Diagnostics.IDiagnosticsLogger`1<Command>, Microsoft.EntityFrameworkCore.Storage.IRelationalTypeMapper)'.
Source=MySql.Data.EntityFrameworkCore
StackTrace:
at MySql.Data.EntityFrameworkCore.Storage.Internal.MySQLCommandBuilderFactory..ctor(IDiagnosticsLogger`1 logger, IRelationalTypeMapper typeMapper)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at [...]
at Microsoft.EntityFrameworkCore.Infrastructure.AccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.get_DatabaseCreator()
at Microsoft.EntityFrameworkCore.Infrastructure.DatabaseFacade.EnsureCreated()
at LoggerApi.Controllers.EntriesController..ctor(EntriesContext context) in C:\MyProjects\WebApplication1\WebApplication1\Controllers\EntriesController.cs:line 19
at [...]
at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__13.MoveNext()
有人能告诉我哪里出了问题吗?
1条答案
按热度按时间dzjeubhm1#
尝试添加包https://www.nuget.org/packages/pomelo.entityframeworkcore.mysql/
版本2.1.2
我为我工作