Sharing: Using MySql in ABP ASP.NET Core 1.1 project #3095

2 Answer(s)

• 

  0

  ismcagdas created 7 years ago

  Support Team

  Hi,

  Thank you for your sharing :).

  About the exception with module zero, official EFCore library provided by Oracle cannot doesn't automatically do registrations for derived classes.

  You can either use <a class="postlink" href="https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql">https://github.com/PomeloFoundation/Pom ... Core.MySql</a> or you need to define Discriminator column like this

  modelBuilder.Entity<FeatureSetting>(b =>
  {
      b.HasDiscriminator<string>("Discriminator")
          .HasValue<FeatureSetting>(nameof(FeatureSetting))
          .HasValue<EditionFeatureSetting>(nameof(EditionFeatureSetting))
          .HasValue<TenantFeatureSetting>(nameof(TenantFeatureSetting));
  });
  

  modelBuilder.Entity<PermissionSetting>(b =>
  {
      b.HasDiscriminator<string>("Discriminator")
          .HasValue<PermissionSetting>(nameof(PermissionSetting))
          .HasValue<RolePermissionSetting>(nameof(RolePermissionSetting))
          .HasValue<UserPermissionSetting>(nameof(UserPermissionSetting));
  });
  

  Thanks.

  Save Cancel
• 

  0

  jakeuj created 7 years ago

  I override OnModelCreating, then I got an error when Add-Migration.

  Error message is below

  "Unable to determine the relationship represented by navigation property 'User.DeleterUser' of type 'User'. Either manually configure the relationship, or ignore this property from the model."

  P.S. I Include module zero (the current version)

  <span style="color:#FF0000">But</span>

  Pomelo.EntityFrameworkCore.MySql is work fine.

  after abpusertokens table created, then throw exception below.

  MySql.Data.MySqlClient.MySqlException: Specified key was too long; max key length is 767 bytes
     at MySql.Data.MySqlClient.MySqlDataReader.ActivateResultSet(ResultSet resultSet)
     at MySql.Data.MySqlClient.MySqlDataReader.<ReadFirstResultSetAsync>d__62.MoveNext()
  --- 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 MySql.Data.MySqlClient.MySqlDataReader.<CreateAsync>d__61.MoveNext()
  --- 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 MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.<ExecuteReaderAsync>d__3.MoveNext()
  --- 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 MySql.Data.MySqlClient.CommandExecutors.TextCommandExecutor.<ExecuteNonQueryAsync>d__1.MoveNext()
  --- 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 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
     at Microsoft.EntityFrameworkCore.Storage.Internal.MySqlRelationalCommand.<ExecuteAsync>d__3.MoveNext()
  --- 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 Microsoft.EntityFrameworkCore.Storage.Internal.MySqlRelationalCommand.Execute(IRelationalConnection connection, String executeMethod, IReadOnlyDictionary`2 parameterValues, Boolean closeConnection)
     at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
     at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
     at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
     at Abp.Zero.EntityFrameworkCore.AbpZeroDbMigrator`1.CreateOrMigrate(AbpTenantBase tenant, Action`1 seedAction)
     at MyGZ.Migrator.MultiTenantMigrateExecuter.Run(Boolean skipConnVerification) in E:\Users\jakeuj\Desktop\MyGZ\src\MyGZ.Migrator\MultiTenantMigrateExecuter.cs:line 63
  

  I think mysql not support Length: 2000 Value = table.Column

  migrationBuilder.CreateTable(
                  name: "AbpSettings",
                  columns: table => new
                  {
                      Id = table.Column<long>(nullable: false)
                          .Annotation("MySql:ValueGeneratedOnAdd", true),
                      CreationTime = table.Column<DateTime>(nullable: false),
                      CreatorUserId = table.Column<long>(nullable: true),
                      LastModificationTime = table.Column<DateTime>(nullable: true),
                      LastModifierUserId = table.Column<long>(nullable: true),
                      Name = table.Column<string>(maxLength: 256, nullable: false),
                      TenantId = table.Column<int>(nullable: true),
                      UserId = table.Column<long>(nullable: true),
                      Value = table.Column<string>(maxLength: 2000, nullable: true)
                  },
                  constraints: table =>
                  {
                      table.PrimaryKey("PK_AbpSettings", x => x.Id);
                      table.ForeignKey(
                          name: "FK_AbpSettings_AbpUsers_UserId",
                          column: x => x.UserId,
                          principalTable: "AbpUsers",
                          principalColumn: "Id",
                          onDelete: ReferentialAction.Restrict);
                  });
  

  Save Cancel