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.

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
Do you need assistance from an ABP expert?
Schedule a Meeting
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v9.2.0-preview. Updated on March 18, 2025, 10:42