1.使用mysql 首先要确定mysql connector 支的版本,正面是链接
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html
Table 9.2 Supported versions of Entity Framework Core
Connector/NETEF Core 1.1EF Core 2.0EF Core 2.1
6.10.4
.NET Standard 1.3 or .NET Framework 4.5.2 (and later)
Not supported
Not supported
6.10.5 to 6.10.7
.NET Standard 1.3 or .NET Framework 4.5.2 (and later)
.NET Standard 2.0 only (.NET Framework is not supported)
Scaffolding is not supported
Not supported
6.10.8
.NET Standard 1.3 or .NET Framework 4.5.2
.NET Standard 2.0 or .NET Framework 4.6.1 (and later)
Not supported
8.0.11 to 8.0.12
.NET Standard 1.6 or .NET Framework 4.5.2 (and later)
.NET Standard 2.0 only (.NET Framework is not supported)
Scaffolding is not supported
Not supported
8.0.13
.NET Standard 1.6 or .NET Framework 4.5.2
Not supported
.NET Standard 2.0 or .NET Framework 4.6.1 (and later)
2.配置数据库连接字符串
{
"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-WebMvc-6350BA27-C046-416F-B717-F8342091E6E4;Trusted_Connection=True;MultipleActiveResultSets=true",
"MysqlConnection": "server=localhost;database=mydb;uid=root;pwd=123456;"
},
"Logging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Warning"
}
}
}
3 修改StartUP
public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext(options =>
options.UseMySQL(Configuration.GetConnectionString("MysqlConnection")));
services.AddIdentity()
.AddEntityFrameworkStores()
.AddDefaultTokenProviders();
// Add application services.
services.AddTransient();
services.AddMvc();
}
4 生成Migration ,数据迁移过程中有一个bug就是原生 clr bool类型为强转成short类型,如果要程序不报错需要做一个强制转换,在使用Add-Migration InitialCreate 方法对生成的代码需要加以下注释
//
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using WebMvc.Data;
namespace WebMvc.Migrations
{
[DbContext(typeof(ApplicationDbContext))]
[Migration("20181210165422_Update")]
partial class Update
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "2.2.0-rtm-35687");
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd().HasMaxLength(50);
b.Property("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property("Name")
.HasMaxLength(256);
b.Property("NormalizedName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedName")
.IsUnique()
.HasName("RoleNameIndex");
b.ToTable("AspNetRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd().HasMaxLength(50);
b.Property("ClaimType");
b.Property("ClaimValue");
b.Property("RoleId")
.IsRequired().HasMaxLength(50);
b.HasKey("Id");
b.HasIndex("RoleId");
b.ToTable("AspNetRoleClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd().HasMaxLength(50);
b.Property("ClaimType");
b.Property("ClaimValue");
b.Property("UserId")
.IsRequired();
b.HasKey("Id");
b.HasIndex("UserId");
b.ToTable("AspNetUserClaims");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b =>
{
b.Property("LoginProvider").HasMaxLength(50);
b.Property("ProviderKey").HasMaxLength(50);
b.Property("ProviderDisplayName");
b.Property("UserId")
.IsRequired();
b.HasKey("LoginProvider", "ProviderKey");
b.HasIndex("UserId");
b.ToTable("AspNetUserLogins");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b =>
{
b.Property("UserId").HasMaxLength(50);
b.Property("RoleId").HasMaxLength(50);
b.HasKey("UserId", "RoleId");
b.HasIndex("RoleId");
b.ToTable("AspNetUserRoles");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b =>
{
b.Property("UserId").HasMaxLength(50);
b.Property("LoginProvider").HasMaxLength(50);
b.Property("Name").HasMaxLength(50);
b.Property("Value");
b.HasKey("UserId", "LoginProvider", "Name");
b.ToTable("AspNetUserTokens");
});
modelBuilder.Entity("WebMvc.Models.ApplicationUser", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd();
b.Property("AccessFailedCount");
b.Property("ConcurrencyStamp")
.IsConcurrencyToken();
b.Property("Email")
.HasMaxLength(256);
b.Property("EmailConfirmed")
.HasColumnType("bit");
b.Property("LockoutEnabled")
.HasColumnType("bit");
b.Property("LockoutEnd");
b.Property("NormalizedEmail")
.HasMaxLength(256);
b.Property("NormalizedUserName")
.HasMaxLength(256);
b.Property("PasswordHash");
b.Property("PhoneNumber");
b.Property("PhoneNumberConfirmed")
.HasColumnType("bit");
b.Property("SecurityStamp");
b.Property("TwoFactorEnabled")
.HasColumnType("bit");
b.Property("UserName")
.HasMaxLength(256);
b.HasKey("Id");
b.HasIndex("NormalizedEmail")
.HasName("EmailIndex");
b.HasIndex("NormalizedUserName")
.IsUnique()
.HasName("UserNameIndex");
b.ToTable("AspNetUsers");
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b =>
{
b.HasOne("WebMvc.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b =>
{
b.HasOne("WebMvc.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b =>
{
b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole")
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade);
b.HasOne("WebMvc.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b =>
{
b.HasOne("WebMvc.Models.ApplicationUser")
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade);
});
#pragma warning restore 612, 618
}
}
}
源码下载