Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to configure DbContext with ODP.NET Core

c0036513-d01d-46af-8a69-d47e16c6c3ceOct 25 2018 — edited Apr 3 2019

It seems that Oracle released the ODP.NET Core version (see https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/). If this is accurate, please share how to set it up by using the DbContextOptions (or in any other "injectable" way, not by manually instantiating the connection and command objects (as in https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/ODPNET_Core_get_started/index.html).

I am not able to configure the DbContext from the Startup, Configuration method as described in StackOverflow (https://stackoverflow.com/questions/52972234/options-useoracle-not-available-in-ef-core ):

services.AddDbContext<BloggingContext>(options => options.UseOracle(ora_conn)); 

"UseOracle" is not a method that is available.

I have included the following namespaces:

using Oracle.ManagedDataAccess.Client;

using Microsoft.EntityFrameworkCore;

Even when I try dotnet ef dbcontext scaffold (with and without the option -c HiddenContext), it fails with the error "Unable to find expected assembly attribute named DesignTimeProviderServicesAttribute in provider assembly Oracle.ManagedDataAccess. This attribute is required to identify the class which acts as the design-time service provider factory."

dotnet ef dbcontext scaffold "DATA SOURCE=hidden;PASSWORD=hidden;PERSIST SECURITY INFO=True;USER ID=hidden;Connection Timeout=60;min pool size=0;connection lifetime=1800;" Oracle.ManagedDataAccess --output-dir Tables --schema hidden -t table1 -t table2 -t table3 -t table4 -t table 5 -v

What am I missing? Can anybody point me to any suggestions out there?

Please, please, help...

This post has been answered by Mark Williams on Oct 25 2018
Jump to Answer

Comments

bansak@loxinfo.co.th

Dear Sir,

I don't have CSI (Customer Support Identifier) How to get "Patch Set Bundle for Oracle APEX 20.1 (30990551)" ?

If I purchase Oracle Database Personal Edition on Oracle Store (link below) Can I get CSI for download this patch?

Best regards,

Bansak.

https://shop.oracle.com/apex/f?p=DSTORE:PRODUCT:::NO:RP,6:P6_LPI,P6_PROD_HIER_ID:4508888120961805719862,4509958287721805…

seanzh

First I can't speak for Oracle, my experience to your question is YES: I have Oracle Database Personal Edition Support Contract and I am able to download this patch. HTH

Pravin Kale

Hi,

Can we upgrade APEX from  5.0.4.00.12 to  20.1  Current database version is 12.1.0 .2

Thanks

Pravin

joelkallman-Oracle

Hi Pravin,

Yes.  You can upgrade directly to the latest version of APEX.  No need for you to install all of the interim versions.

Joel

bansak@loxinfo.co.th

Dear Mr.Seanzh,

What happend if I am not pay license and support per year over 2 years and back to use it again. How much license and support I will pay, only current year or 2 years+current year?

Thanks and Best regards,

Bansak.

seanzh

Again, I only speak for my own experience.

Our company used to use Oracle EE for ERP, 7 years ago we migrated to another ERP system which uses different database and we discontinued Oracle license, 3 years ago I found a couple of my small applications still need Oracle patches so I decided to buy Oracle Database Personal Edition at price like $470( first year)+$150 ( for 1st year support)= $620 /1st year , subsequent years the contract renewal for about  $150/Yr, very good price. The CSI support# enables me access to support.oracle.com to download patches, new DB software AND request support, one time I even got great support on 365 email integration with Apex by none other than  Apex director Joel Kallman himself, who sent me a patch personally and I was  grateful for that.  OK, I am detouring too much, back to your answer I'd  say, only current year=$620; 2years support+current year=$770... HTH

Yevon

Hi apex team! Congrats and good job for all new features of this release, but it has a very urgent bug thats makes it unusable, we are having lots and random issues because of it after upgrading to latest version with last available patchset installed (30990551). It doesn't behave properly with varchar2 extended mode activated. I read in release notes that this bug is suposed to be fixed, but it isn't.

Apex 20.1 release notes fixes bugs:

| 30589770 | FORM REGION INIT PROCESS THROWS ORA-06502 WITH MAX_STRING_SIZE=EXTENDED AND VARCHAR2 VALUES > 4000 BYTE |

Any report or process that produces varchar2 > 4000 fails with ORA-06502. If you debug the process or query in sql developer, it works nicely, in apex fails. I tested it in apex workapaces, but I don't know if this instance has extended mode active:

https://apex.oracle.com/pls/apex/pcat_test/r/test-varchar2-4000-bug/test-bug-varchar2-4000

Any workarounds? Is it possible that installing the patchset this bug returns and with standsrd install is correct? I can't check it. Thanks for your work.

joelkallman-Oracle escribió:

Oracle APEX, the world's most popular low-code platform for enterprise apps, changes the game yet again. Reduce costs, deliver on time, and produce beautiful results for your business, with Oracle APEX!

Oracle proudly announces the general availability of APEX 20.1!

Release Announcement: https://blogs.oracle.com/apex/announcing-oracle-apex-201

All Information about Oracle APEX: https://apex.oracle.com

APEX 20.1.png

1 - 8

Post Details

Added on Oct 25 2018
29 comments
32,403 views