Activities of "HIPT"

Hi all !

Can I use ASNETZERO with ODP.net and oracle 12c?Because I have 4 projects using ASNETZERO, using Microsoft Entity Framework (EF) Core and oracle 12c and each project development in different locations.

Sorry, with ODP.NET 18c, can I use with ASPNET.CORE and angular, EF core 2.1? Because when use Devart.Data.Oracle.EFCore, I must have one license per on location.

After running migrate data from Migrator project with oracle database,I executed a query with one table in database and it throwed error ORA-00942 although I typed the correct table name. What is wrong here? Can you help me, please?

There are my queries and they have the same error:Error ORA-00942.

select * from HOTROKTKT.Auditquestions

select * from Auditquestions

I want to check my data and I run my query in PL/SQL or SQL Developer and has an error ORA-00942: table or view does not exist.

select * from HOTROKTKT.Auditquestions

select * from Auditquestions

But if I created my table in PL/SQL or SQL Developer, It execute successfull.

Auditquestions has been existed. You can see my attach

After migrated from project aspnet-core, my table is structured like that:

CREATE TABLE "HOTROKTKT"."AuditQuestions" ( "Id" NUMBER(19,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, "CreationTime" TIMESTAMP (7) NOT NULL ENABLE, "CreatorUserId" NUMBER(19,0), "LastModificationTime" TIMESTAMP (7), "LastModifierUserId" NUMBER(19,0), "IsDeleted" NUMBER(1,0) NOT NULL ENABLE, "DeleterUserId" NUMBER(19,0), "DeletionTime" TIMESTAMP (7), "TenantId" NUMBER(10,0), "AuditQuestionCode" NVARCHAR2(50) NOT NULL ENABLE, "AuditQuestionContent" VARCHAR2(4000 CHAR) NOT NULL ENABLE, "ParentId" NUMBER(19,0), "BussinessId" NUMBER(19,0) NOT NULL ENABLE, "LocalSoftwareId" NUMBER(19,0) NOT NULL ENABLE, "IsActive" NVARCHAR2(1) NOT NULL ENABLE, "IsHoData" NUMBER(10,0), PRIMARY KEY ("Id"));

And if I want to select data from AuditQuestions using PL/SQL or SQL Developer, my query must include quotation mark (") with table name or column name.

How can I fix it with my Enity?

Hello, when I migrate asp.net core to oracle database, it throw error

Failed executing DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] UPDATE AbpEditions SET Discriminator = 'SubscribableEdition' Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist at   .(Int32 ) at   .      (Int32 ,    ) at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() at   .ExecuteNonQuery() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ORA-00942: table or view does not exist

How can I fix it? Please help me !!!

Yes, new database.

It's ok. I must migrate for new database. Thanks !

I have solved this problem