Open Closed

ABP Framework connect to Oracle 12c #640


User avatar
0
toan.nguyen created

Dear support team,

We are trying to replace the default Entity Framework with Oracle database but we found conflict errors. Can you please help us fixing this? <br>

  • ABP Framework version: v4.0
  • UI type: MVC
  • Tiered (MVC) or Identity Server Seperated (Angular): yes
  • Exception message and stack trace: Version conflict detected when we trying to connect to Oracle database 12C.
  • Steps to reproduce the issue:
    1. Follow this guide to remove and add dependency https://docs.abp.io/en/abp/latest/Entity-Framework-Core-Oracle-Official
    2. The error message shows as below image


11 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi @toan.nguyen

    Oracle.EntityFrameworkCore has not to support net 5.0 yet. We will publish this package immediately when it is available.

    https://www.nuget.org/packages/Oracle.EntityFrameworkCore/ https://github.com/oracle/dotnet-db-samples/issues/81

  • User Avatar
    0
    toan.nguyen created

    Hi @maliming,

    Thanks. So should we downgrade framework to lower version or using another library like devart?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    https://github.com/oracle/dotnet-db-samples/issues/81#issuecomment-728258466 we're still on track for a December/January Oracle EF Core 5 release.

    https://www.nuget.org/packages/Devart.Data.Oracle.EFCore is supported net 5.0 but it not free library.

    You can wait for Oracle or try Devart, otherwise you can only use net core 3.x.

  • User Avatar
    0
    toan.nguyen created

    Hi maliming,

    I am trying to install abp suite version 3.3.2 to downgrade framework to net core 3.1. Can you help me fixing this error:

    C:\Users\Toan Nguyen>abp suite install --version 3.3.2 [10:05:01 INF] ABP CLI (https://abp.io) [10:05:02 INF] Version 3.3.2 (Stable) [10:05:05 WRN] ABP CLI has a newer stable version 4.0.0, please update to get the latest features and fixes. [10:05:05 WRN] [10:05:05 WRN] Update Command: [10:05:05 WRN] dotnet tool update -g Volo.Abp.Cli [10:05:05 WRN] [10:05:05 INF] Installing ABP Suite... error NU1202: Package Volo.Abp.Suite 4.0.0 is not compatible with netcoreapp3.1 (.NETCoreApp,Version=v3.1) / any. Package Volo.Abp.Suite 4.0.0 supports: net5.0 (.NETCoreApp,Version=v5.0) / any The tool package could not be restored. Tool 'volo.abp.suite' failed to install. This failure may have been caused by:

    • You are attempting to install a preview release and did not use the --version option to specify the version.
    • A package by this name was found, but it was not a .NET Core tool.
    • The required NuGet feed cannot be accessed, perhaps because of an Internet connection problem.
    • You mistyped the name of the tool.

    For more reasons, including package naming enforcement, visit https://aka.ms/failure-installing-tool [10:05:13 INF] You can also run the following command to install ABP Suite. [10:05:13 INF] dotnet tool install -g Volo.Abp.Suite

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi toan.nguyen

    Replace apikey with your private apikey. https://commercial.abp.io/my-organizations/

     dotnet tool uninstall --global Volo.Abp.Suite
     dotnet tool install -g Volo.Abp.Suite --version 3.2.2 --add-source your_api_key
    

  • User Avatar
    0
    toan.nguyen created

    Hello support team,

    Oracle just release the Oracle EF Core 5 https://www.nuget.org/packages/Oracle.EntityFrameworkCore/5.21.1 Can you guide me on how to upgrade to this new package?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi toan.nguyen

    We will release it in 4.3 Please refer to this before that: https://github.com/abpframework/abp/pull/7716

  • User Avatar
    0
    toan.nguyen created

    Hhi maliming,

    I am testing version 4.3-preview, I cannot find the option to connect to Oracle using Oracle Official package. Can you please check?

    Regards, ToanNM.

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi @toan.nguyen

    It seems we need to add oracle to abp suite. We will handle it in rc2.

  • User Avatar
    0
    alper created
    Support Team Director

    Hhi maliming,

    I am testing version 4.3-preview, I cannot find the option to connect to Oracle using Oracle Official package. Can you please check?

    Regards, ToanNM.

    Oracle provider added to the Suite in RC2 (comes tomorrow 2021-04-09) you can also use this command to create your project

    abp new Acme.BookStore -t app-pro -u mvc --mobile none --database-provider ef -csf --preview --database-management-system oracle
    
  • User Avatar
    0
    ServiceBot created
    Support Team Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Made with ❤️ on ABP v9.1.0-preview. Updated on November 11, 2024, 11:11