Base solution for your next web application
Open Closed

Entity Framework with Oracle #2900


User avatar
0
nitinjadhav created

Hello ABP community,

I created the template by using ASP.NET Core template with module zero that include SPA Angular 2.

I Had a few trouble in CodeFirst Generation.

Below steps I followed 1.Oracle EF 6 : nuget package Oracle.ManagedDataAccess.EntityFramework version: 12.1.2400 2.Delete ALL migrations files from CodeFirst 3.Added Below code in file *DBContext file of *.EntityFrameork Project SetProviderServices(TCConsts.ProviderOracle, Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices.Instance); SetProviderFactory(TCConsts.ProviderOracle, Oracle.ManagedDataAccess.Client.OracleClientFactory.Instance); SetDefaultConnectionFactory(new Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory()); 4.Added connection string appsettings.json in Migrator project 5. Ran Migrator project

It retun me Error: ORA-01918: user 'dbo' does not exist

I did follow below link , but no solution #2669@bac49aa0-f319-472d-8b32-e5d1288a274a

Then ported SQL data to Oracle under schema 'dbo' and modify the code " Database.SetInitializer<TCDbContext>(null);" and ran Web Project and I am getting error {"ORA-00933: SQL command not properly ended"}


2 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    It is hard to find problem according to this message.

    Can you try to disable some parts of migration file and try to run migration a few times until you find the section causes problem ?

    Thanks.

  • User Avatar
    0
    fairytellyw created

    Does there exist a weather module, where I can define two locations Florida/Paris ?