Base solution for your next web application
Open Closed

Oracle Connection In .net core platform #3593


User avatar
0
velu created

Hi,

We are using ASPnet Core + angular Platform to develop application.

We are trying to connect with oracle database (<span style="color:#FF0040">Currently Not Supported by .net core</span>) that’s why we procure and implemented Devart drivers.

By using devart we successfully connected to oracle 11G database. • Abp table structure generated in database. • Failed to insert Default data in database.

when we are run the .Migrator we have some errors. • Error 1: ORA-00932: inconsistent datatypes: expected - got NCLOB For this error we convert NCLOB datatype to Varchar(4000) by using alter command. Then ABPuser, Tenant data inserted in database but next to this Steps we face error2. • Error 2: Transaction isolation level ReadUncommitted not supported.

thanks


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

    Hi @velu,

    I think it is not supported by Oracle. You can disable transactions like this Configuration.UnitOfWork.IsTransactional = false; in your core module.

    Thanks.

  • User Avatar
    0
    velu created

    Hi,

    Please provide me a particular module name or class name, Where can i set this.

    Thanks,

  • User Avatar
    0
    velu created

    Hi,

    It Worked for Me,

    Thanks.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Great :)