代码第一指定键中的标识和Mysql太长；最大键长为1000个字节。
代码第一指定键中的标识和Mysql太长；最大键长为1000个字节。
提问于 2018-03-30 11:39:25
我正在尝试使用CodeFirst驱动程序用IentityCore创建一个MySQL数据库。
我的用户 DbModel是这样的-
[Table("User")]
public class User : IdentityUser<int>
{
public string Name { get; set; }
public string Password { get; set; }
}DBModel是这样的-
[Table("Role")]
public class Role : IdentityRole<int>
{
public string Description { get; set; }
}我的DbContext是这样的-
public class InventoryManagementDbContext : IdentityDbContext<User, Role, int>
{
//Table List
public DbSet<Employee> Employies { get; set; }
public DbSet<ProductCategory> ProductCategorys { get; set; }
public DbSet<ProductType> ProductTypes { get; set; }
public DbSet<Product> Products { get; set; }
public DbSet<Entry> Entries { get; set; }
public DbSet<Exit> Exits { get; set; }
//Table List End
public InventoryManagementDbContext(DbContextOptions<InventoryManagementDbContext> options)
: base(options)
{}
//Fluent API to make Composite Key
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
// email address doesn't need to be in unicode, check it spec
modelBuilder.Entity<User>().Property(u => u.UserName).IsUnicode(false);
modelBuilder.Entity<User>().Property(u => u.Email).IsUnicode(false);
modelBuilder.Entity<Role>().Property(r => r.Name).HasMaxLength(255);
}
}因此，我为电子邮件和用户名禁用了Unicode，并将MaxLength设置为Role.Name。
如果我想执行这个命令-
添加-迁移
那我就会犯这个错误-
.....................................
.....................................
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
CREATE TABLE `AspNetUserLogins` (
`LoginProvider` varchar(767) NOT NULL,
`ProviderKey` varchar(767) NOT NULL,
`ProviderDisplayName` text NULL,
`UserId` int NOT NULL,
PRIMARY KEY (`LoginProvider`, `ProviderKey`),
CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
);
MySql.Data.MySqlClient.MySqlException (0x80004005): Specified key was too long; max key length is 1000 bytes
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
failverbose: Found DbContext 'InventoryManagementDbContext'.
: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
CREATE TABLE `AspNetUserLogins` (
`LoginProvider` varchar(767) NOT NULL,
`ProviderKey` varchar(767) NOT NULL,
`ProviderDisplayName` text NULL,
`UserId` int NOT NULL,
PRIMARY KEY (`LoginProvider`, `ProviderKey`),
CONSTRAINT `FK_AspNetUserLogins_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `AspNetUsers` (`Id`) ON DELETE CASCADE
);
MySql.Data.MySqlClient.MySqlException (0x80004005): Specified key was too long; max key length is 1000 bytes
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
Microsoft.EntityFrameworkCore.Infrastructure[10403]
Entity Framework Core 2.0.2-rtm-10011 initialized 'InventoryManagementDbContext' using provider 'MySql.Data.EntityFrameworkCore' with options: NoTracking CommandTimeout=60
Microsoft.EntityFrameworkCore.Infrastructure[10403]
Entity Framework Core 2.0.2-rtm-10011 initialized 'InventoryManagementDbContext' using provider 'MySql.Data.EntityFrameworkCore' with options: NoTracking CommandTimeout=60我的完整代码可以在这里中找到。
有人能帮忙吗？
重新-
问题没有解决我的问题，因为我没有面临任何问题的将军凯斯，他们是完美地为我工作。
我在尝试使用https://www.asp.net/identity时遇到了问题。
回答 1
Stack Overflow用户
发布于 2020-05-10 19:21:11
我会把这个留在这里，尽管这个问题已经有一段时间了，对于任何有同样问题的人来说。
您需要为以下几个属性设置最大长度：
- IdentityRole
- IdentityUser
- IdentityUserLogin
- IdentityUserToken
在本例中，您已经扩展了类IdentityUser和IdentityRole，用于使用integer PK，因此，使用fluent API的代码应该如下所示：
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
int stringMaxLength = /* something like 100*/;
// User IdentityRole and IdentityUser in case you haven't extended those classes
builder.Entity<Role>(x => x.Property(m => m.Name).HasMaxLength(stringMaxLength));
builder.Entity<Role>(x => x.Property(m => m.NormalizedName).HasMaxLength(stringMaxLength));
builder.Entity<User>(x => x.Property(m => m.NormalizedUserName).HasMaxLength(stringMaxLength));
// We are using int here because of the change on the PK
builder.Entity<IdentityUserLogin<int>>(x => x.Property(m => m.LoginProvider).HasMaxLength(stringMaxLength));
builder.Entity<IdentityUserLogin<int>>(x => x.Property(m => m.ProviderKey).HasMaxLength(stringMaxLength));
// We are using int here because of the change on the PK
builder.Entity<IdentityUserToken<int>>(x => x.Property(m => m.LoginProvider).HasMaxLength(stringMaxLength));
builder.Entity<IdentityUserToken<int>>(x => x.Property(m => m.Name).HasMaxLength(stringMaxLength));
// etc..希望能帮上忙！
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/49573740
复制相关文章
相似问题
腾讯云开发者
