- 3,708,735 Users
- 2,241,115 Discussions
- 7,840,563 Comments
Forum Stats
Discussions
Categories
- 9 Data
- 362.2K Big Data Appliance
- 3 Data Science
- 1K Databases
- 322 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 479 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.7K ORDS, SODA & JSON in the Database
- 408 SQLcl
- 32 SQL Developer Data Modeler
- 184.6K SQL & PL/SQL
- 20.9K SQL Developer
- 1.3K Development
- Developer Projects
- 31 Programming Languages
- 134.5K Development Tools
- 4 DevOps
- 3K QA/Testing
- 172 Java
- 3 Java Learning Subscription
- 6 Database Connectivity
- 64 Java Community Process
- Java 25
- 7 Java APIs
- 141.1K Java Development Tools
- 2 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 132 Java 8 Questions
- 86.1K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 5 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 80 LiveLabs
- 23 Workshops
- 7 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 6 Español
- 1.9K Japanese
- 2 Portuguese
Oracle EF Core for .net Core 3/3.1
Marius St.
Posts: 4 Newbie
Hi,
.net core 3.1 with new Microsoft.EntityFrameworkCore has been released some days ago. I would like to know when there will be a release of Oracle.EntityFrameworkCore with .net core 3 or 3.1 support?
Is there already a date for the release? Will there be a beta/preview?
Any news @Alex Keh - Product Manager-Oracle?
Kind Regards,
Marius
5
Best Answer
-
Alex Keh-Oracle
Posts: 2,720 Employee
The Oracle EF Core 3.1 beta is now available for download from NuGet Gallery.
More info about the beta in this blog post.
2
Answers
As .NET Core 3 is a Current release with only about 3 months remaining in support, it's very likely Oracle EF Core will be supported for .NET Core 3.1 for production. .NET Core 3.1 has LTS.
No update on a beta date yet. We've seen many more issues than expected when moving ODP.NET EF Core to version 3, but we're making progress. Beta will begin early in 2020.
Thanks for the information. I am glad to hear that you are into it. I am looking forward to the beta in early 2020.
Regards,
Marius
Hi,
I'm also looking forward to the beta for .net core 3.1, is there a place where we can get information on the project or we can see a roadmap,
Thanks in advance
ODP.NET will likely be certified this month for .NET Core 3.1.
Oracle EF Core 3.1 support is taking longer as there have been numerous changes for provider writers between EF Core 2 and 3.
Any chance to get Oracle.EntityFrameworkCore 3 beta?
Email dotnet_us(at)oracle.com. Oracle will then inform you by email when the Oracle EF Core 3 beta and productions become available.
Just to provide an important clarification which few people seem to know..
Oracle.EntityFramework (e.g. 2.19.60) Core is compatible (working) with .NET core 3.1 !
Because EF 2.x is compatible with .NET core 3.1 !
We created a demo with ASP.NET core 3.1, and added the dependency to the Oracle EF provider named. It worked.
You can only not use EF 3.x, but this will be not the problem for a number of people (like us). We just want to work with a LT support version of .NET...
There are also guys like us who want to migrate to .net core 3 because on of their project dependencies has moved to .net core 3 and ef core 3...
I can't believe how oracle is lagging behind with this. We're in April and still nothing while Microsoft is already releasing beta of .NET Core 5.
I don't know what is the issue but why don't you do like everyone else and open source it on GitHub ? It would be way faster than now...
I guess you want to keep your products to yourself but you're annoying everyone by doing that. Just open your minds and evolve with the trends...
With the coronavirus pandemic spreading worldwide, EF Core 3 work has been delayed. The focus is now on customers that need immediate help with critical apps and the well being of our team members.
Could not Understand Why Oracle team is lagging behind far behind mysql and Postgre developers. these db already have started supporting the EF 3.1 envronment. Oracle might loose marker. COBIT pendemic is not for oracle deleopers where as the mysql and postgre team have already worked on it.
We cannot update nuget packages in our project because of odp.net dependency, this is annoying situation and I don't know how long we have to wait
Oracle database selection seems to be an error. It wasn't supposed to take so long, oracle lagged behind its rivals
Maybe @Alex Keh - Product Manager-Oracle can make a good suggestion about what we need to do
Right now, we're planning to release the Oracle EF Core 3 beta by the end of May.
ehh, again distress ! I am expecting to hear on 3.1
but still in plan for core 3 beta only, who knows when will work on 3.1 . In this pace; I think over a year or two more.
EF Core 3.1 will be supported in the beta. The term "Oracle EF Core 3" is referring to the entire family of EF Core 3.x.
I'll even take an alpha at this point . Stay safe and Stay Classy San Diego (Anchorman)
Hi Alex,
Could you please share us the nuget package link for Oracle EF Core 3 which supports .Net Core 3.0 and later. Appreciate if you could share steps document to generate entities.
Thanks,
Satish K
Hi Alex,
Could you please share us the nuget package link for Oracle EF Core 3 which supports .Net Core 3.0 and later. Appreciate if you could share steps document to generate entities.
Thanks,
Satish K
Hi Alex,
Could you please share us the nuget package link for Oracle EF Core 3 which supports .Net Core 3.0 and later. Appreciate if you could share steps document to generate entities.
Thanks,
Satish K
The beta will support EF Core 3.1 from the start.
Any timeline for this? I know it's been asked. Also, how do I get the beta? I would love to test it out. We have a project going on that won't be released for about 9 months, but it would be nice to have it developed from the ground-up with your beta EF Core 3.x provider.
The beta will be delivered on NuGet Gallery very soon. We've got a release candidate and are testing it out to ensure it passes our shipping criteria.
The Oracle EF Core 3.1 beta is now available for download from NuGet Gallery.
More info about the beta in this blog post.
Is it support generate view objects from ef scaffolding? I'm struggling with it right now and it seems like it doesn't.
Great! Thank you!
We have an bug with the Oracle.EntityFrameworkCore (3.19.80) at FirstOrDefault when two tables have a column with the same name.
For Example:
Ef Core turns the query _db.Users.Include(u => u.Profile).FirstOrDefault(u => u.Login == "Test");
the following SQL:
SELECT "t". "Id", ..., "t". "Login",
"t0". "Login,"...
FROM "UTEST" "USER" "t"
LEFT JOIN "UTEST". "USER PROFILES" "t0" ON "t". "Login" = "t0". "Login"
WHERE "t". "Login" = :login_0
FETCH FIRST 1 ROWS ONLY;
Because of the same column name the database throws the following exception
ORA-00918: "column ambiguously defined
Second Login column should have alias.
SELECT "t". "Id", ..., "t". "Login",
"t0". "Login" "Login0",...
FROM "UTEST" "USER" "t"
LEFT JOIN "UTEST". "USER PROFILES" "t0" ON "t". "Login" = "t0". "Login"
WHERE "t". "Login" = :login_0
FETCH FIRST 1 ROWS ONLY;
@Alex Keh - Product Manager-Oracle Any Chance for a Bugfix
If you are querying against DB version 12.1, then this is a known issue with the row limiting clause. The fix has not been backported to DB 12.1. It is available when using DB 12.2 or higher.
Thanks a lot, we were still using version 12.1. With 12.2 it works perfectly.