ASP.NET Core NET6 EFCore MySQL-Toy模板网

这篇具有很好参考价值的文章主要介绍了ASP.NET Core NET6 EFCore MySQL。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

ASP.NET Core 下使用 EFCore 和 .NET Framework 下使用有点区别。
参考官方文档：https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html

1.创建 ASP.NET Core Web应用项目

创建新的项目的 Program.cs 文件中使用了顶级语句，与NET5 有所区别。

.NET 6 的创建的项目使用了C# 顶级语句
https://learn.microsoft.com/zh-cn/dotnet/csharp/whats-new/tutorials/top-level-statements

2.引入相关nuget包

  <ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="6.0.10" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="6.0.10">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="6.0.10">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include="MySql.Data" Version="8.0.31" />
    <PackageReference Include="MySql.EntityFrameworkCore" Version="6.0.7" />
    <PackageReference Include="NLog.Web.AspNetCore" Version="5.1.4" />
  </ItemGroup>

3.创建AppDbContext类

注意： this.Database.EnsureCreated();初始化数据库，如果不存在数据库会创建。

using Microsoft.EntityFrameworkCore;
 public class AppDbContext: DbContext
    {
        public AppDbContext(DbContextOptions<AppDbContext> options) : base(options) {
        	// 初始化数据库，如果不存在数据库会创建
            this.Database.EnsureCreated();
        }
        public DbSet<Models.User> User{ get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
         //   optionsBuilder.UseMySQL("server=localhost;database=library;user=user;password=password");
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<User>(entity =>
            {
                entity.HasKey(e => e.id);
            });
        }
    }

4.添加连接字符串配置appsettings.json

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "MySQLConnection": "server=127.0.0.1;port=3306;uid=root;database=db1"
  }
}

在var builder = WebApplication.CreateBuilder(args);代码下添加

    builder.Services.AddDbContext<AppDbContext>(opt =>
    {
        opt.UseMySQL(builder.Configuration.GetConnectionString("MySQLConnection"));
    });