OpenIddictProDbContext error when OpenIddict 4.x to 5.x Migration #6464

16 Answer(s)

• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  Did you add the new ef core migrations? Can you share the migration file?

  btw, It seems the Oracle didn't support ef core 8.

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  Yes i added new migration :

  using System;
  using Microsoft.EntityFrameworkCore.Migrations;
  
  #nullable disable
  
  namespace MyBankStore.Migrations
  {
      /// <inheritdoc />
      public partial class Updated_OpenIddict : Migration
      {
          /// <inheritdoc />
          protected override void Up(MigrationBuilder migrationBuilder)
          {
              migrationBuilder.RenameColumn(
                  name: "Type",
                  table: "OpenIddictApplications",
                  newName: "ClientType");
  
              migrationBuilder.AddColumn<string>(
                  name: "ApplicationType",
                  table: "OpenIddictApplications",
                  type: "nvarchar(50)",
                  maxLength: 50,
                  nullable: true);
  
              migrationBuilder.AddColumn<string>(
                  name: "JsonWebKeySet",
                  table: "OpenIddictApplications",
                  type: "nvarchar(max)",
                  nullable: true);
  
              migrationBuilder.AddColumn<string>(
                  name: "Settings",
                  table: "OpenIddictApplications",
                  type: "nvarchar(max)",
                  nullable: true);
          }
  
          /// <inheritdoc />
          protected override void Down(MigrationBuilder migrationBuilder)
          {
              migrationBuilder.DropColumn(
                  name: "ApplicationType",
                  table: "OpenIddictApplications");
  
              migrationBuilder.DropColumn(
                  name: "JsonWebKeySet",
                  table: "OpenIddictApplications");
  
              migrationBuilder.DropColumn(
                  name: "Settings",
                  table: "OpenIddictApplications");
  
              migrationBuilder.RenameColumn(
                  name: "ClientType",
                  table: "OpenIddictApplications",
                  newName: "Type");
          }
      }
  }
  
  

  I changed this part as well

     var application = new AbpApplicationDescriptor {
         ClientId = name,
         ClientType = type,
         ClientSecret = secret,
         ConsentType = consentType,
         DisplayName = displayName,
         ClientUri = clientUri,
         LogoUri = logoUri,
     };
  

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  The migration file looks no problem,

  I'm sure you have update database with the migration file.

  Please check the table columns in the database.

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  What does update database mean? I add this file myself and i didnt change anything else. While developing in .net7, we were using abp 7 version. And the migration was working without any problems. With my migration to abp 8, I added only the migration file I sent you for openIddict to the Migrations folder. and now when it goes to the migration seed data section it gives me the error I got.

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  You need to update your database with your migrations.

  You should use dotnet ef migrations add Updated_OpenIddict command to add new migrations instead of copy the code from https://docs.abp.io/en/abp/8.0/Migration-Guides/OpenIddict4-to-5#openiddictapplicationmodel-changes

  After creating new migrations you can use dotnet ef database update to update the database.

  https://learn.microsoft.com/en-us/ef/core/managing-schemas/migrations/applying?tabs=dotnet-core-cli

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  

  I update the database it gives this error.

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  It seems your ef core migration files are not generated by Oracle provider.

  Please check it and make sure your db provider is Oracle.

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  

  We are using a suite and it creates all of entities for oracle so I dont think provider is a problem.

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  Can you share a project?

  liming.ma@volosoft.com

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  Which part do you want me to share with you?

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  Can you share an entire project?

  or the ef core project MyCompanyName.MyProjectName.EntityFrameworkCore

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  I successfully moved my project from .net 7 to .net 8.

  But your ef project is still using abp 7 and ef 7.

  

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  Since OpenIddict was not migrated automatically, we had to downgrade the project. As I explained in the e-mail, we have to continue writing code. The problem is, when I create the migration file I sent you above by adding and updating it as in the link you sent, we try it on the test database. and it gives the error I sent above.

  Save Cancel
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  hi

  Sorry, I missed your messages.

  Can you find a way to reproduce this problem in a project?

  Save Cancel
• 

  0

  IbrahimSarigoz created 10 months ago

  Hi, I solved my problem. Here I would like to write an explanation for people who may encounter the same problem. First make sure you have successfully upgraded all your project's nuget packages. Some nuget packages may need to remain in the same version, depending on your project. For example, in my case, since .net 8 was not supported, the System.ServiceModel nuget packages had to remain in version 4.4.*. This may be another nuget package or another version in your project. var application = new AbpApplicationDescriptor { ClientId = name, ClientType = type, ClientSecret = secret, ConsentType = consentType, DisplayName = displayName, ClientUri = clientUri, LogoUri = logoUri, }; Don't forget to change Type to ClientType.

  After checking these, make sure that the project is built successfully. Run "dotnet ef migrations add Updated_OpenIddict" in the EntityFrameworkCore project. In this way, you will migrate the necessary entity changes to your project. Finally, if DbMigrator gives an error due to old settings, run the "dotnet ef database update" code in your EntityFrameworkCore project.

  Save Cancel

  1
• 

  0

  maliming created 10 months ago

  Support Team Fullstack Developer

  Thanks.

  Save Cancel