- 3,722,209 Users
- 2,244,252 Discussions
- 7,849,704 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2K Databases
- 586 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 494 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 418 SQLcl
- 54 SQL Developer Data Modeler
- 185K SQL & PL/SQL
- 21.1K SQL Developer
- 2.3K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.5K Development Tools
- 12 DevOps
- 3K QA/Testing
- 321 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 70 Java Community Process
- 2 Java 25
- 11 Java APIs
- 141.2K Java Development Tools
- 7 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 14 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 145 LiveLabs
- 34 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 15 Español
- 1.9K Japanese
- 2 Portuguese
How to configure DbContext with ODP.NET Core

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));
<span style="font-family: arial, helvetica, sans-serif;">"UseOracle" is not a method that is available.</span><br/>
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...
Best Answer
-
Hi,
What your NuGet link points to is the Oracle Data Provider for .NET Core (ODPC) which is different from the Oracle Provider for Entity Framework Core. The EF provider is a separate assembly which has not been released yet (as of this posting date). The EF assembly will require the ODPC assembly.
Regards,
Mark
Answers
-
Hi,
What your NuGet link points to is the Oracle Data Provider for .NET Core (ODPC) which is different from the Oracle Provider for Entity Framework Core. The EF provider is a separate assembly which has not been released yet (as of this posting date). The EF assembly will require the ODPC assembly.
Regards,
Mark
-
When will the provider be released?
-
-
Hi Alex,
that is good to hear. We are currently evaluating Entity Framework Core in a product that runs on .net 4.7.2.
Will the new provider also work in full framework or is .net core required?
-
Are you guys still targeting December on initial Beta release? I am currently working on a brand new project rewrite of .net over Oracle with .net core and I hope to see if work nicely with EF Core. I would love to help with the beta testing if you guys are looking for any help there!
-
We're currently conducting an Oracle EF Core private beta with a small number of customers right now. If you want to join, send an email to us: dotnet_us (at) oracle.com
We still plan to have a wide public beta distribution in December. It will probably be late December.
-
Hi, Oracle.
Do you have any updates on releasing beta version of entity framework core support? It is holding up several development activities for our company. We have both Oracle and SQL Server databases.
Thank you,
-
Public beta still looking like late December.
You can get access to the private beta by emailing the address in my previous post.
-
Hi , Excuse me , Public beta is released ? or How long does it take?
-
Hello, we have been reached January/2019 and still don't have any information about this feature.
I searched all over the site and 18c released documentation as well, but couldn't find a mention about EF Core.
Can confirm if the EF Core feature has already been released in 18c?
Thanks.
-
The public beta is not yet available. However, the private beta is. If you would like to join the private beta and start using Oracle EF Core now, send an email to dotnet_us (at) oracle.com.
-
How long should I expect to wait after sending an email for beta access?
-
Usually, we can get you access within a couple of business days.
-
Any estimation on when the EF Core driver will be released ?
-
Hello, we're actually working on a .Net Core project targeting an oracle database using ODP.NET for .Net Core and we'd like to migrate to EF Core, any news about the public beta or the final release, will it be available on the second quarter of this year ?
-
After the public beta and hearing the feedback, Oracle will have a better idea of when production will be for Oracle EF Core. My best estimate right now for production remains second quarter this year.
The public beta should be available quite soon.
-
Hi Alex.
I'm having troubles with private beta, where can I find documentation or where to report
thanks
-
The doc is enclosed in the NuGet beta package. You can email me if you encounter an issue.
-
If you rename the .nupkg file to .zip, you can just unzip it like a regular zip file, and find the documentation inside.
-
is the nuget link for this product ? https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core/
-
Hello,
That is the link for the Oracle Data Provider for .NET Core product. I'm not sure if that is the specific product you mean. It is not, for example, the link for the Oracle EF Core provider product.
Regards,
Mark
-
Hi Guys
Any updates on the public beta date? I've requested private beta access almost a week ago, but haven't heard anything. Are you still targeting the second quarter for the full release? Seeing as the public beta hasn't started, I'm thinking that date will be pushed also?
Thanks
Justin
-
Hi Justin,
The beta invitation to you was sent out on Feb. 28. I'll resend it again.
-
I received it the second time around. Thanks Alex!
-
Hi Alex,
Would you mind send me the invitation for the oracle EF Core? Many thanks.
Best regards,
Hongjun