dotnet / efcore

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
https://docs.microsoft.com/ef/
MIT License
13.71k stars 3.17k forks source link

Oracle support #4293

Closed nrkarthick closed 1 year ago

nrkarthick commented 8 years ago

The Oracle .NET team is evaluating EF Core support, but have not announced any timing. You can vote on the Oracle EF Core Provider feature request.

Please direct any questions about this provider, including the release timeline, to the Oracle Community Site.

erikbullens commented 8 years ago

Hi, Did you connect to Oracle with EF7?

ErikEJ commented 8 years ago

Oracle support for EF7 should be addressed with Oracle support https://community.oracle.com/message/13562069#13562069

nrkarthick commented 8 years ago

@erikbullens .. yes i successfully connect to oracle but with EF 6.1.3.. My problem here is, that the Identity 3.0 is not supporting EF 6.1.3..

erikbullens commented 8 years ago

So you don't use the version 7?

nrkarthick commented 8 years ago

Yes..

erikbullens commented 8 years ago

When are you planning to use it?

rowanmiller commented 8 years ago

@nrkarthick we have reached out to our provider writers about creating providers for EF7. Historically, our team has only implemented the SQL Server provider and the database vendors (or third parties) have implemented the providers for their database engines. We have been working with Oracle, but sharing anything along the lines of commitments/plans/timelines/etc. is really up to their team and not something I can comment on.

rowanmiller commented 8 years ago

Closing out as I don't think there is anything else to answer here. Feel free to re-open if you disagree :smile:

nrkarthick commented 8 years ago

@rowanmiller Thanks for the update.. Oracle is one of the most widely used databases on earth. Not sure why an oracle provider is not included in Beta stage itself.. Expecting the team to include as early as possible.

ghost commented 8 years ago

@alexkeh (Oracle Corp.), could you please provide some sort of hint whether Oracle team is interested in / working on delivering the EF7 provider sometime around the EF7 RTM (which is pretty soon now)? Is there anything the community can do to expedite this feature request?

alexkeh commented 8 years ago

Hi Peter, The Oracle .NET team is evaluating EF7 support, but we have not announced any timing.

The community can vote for the Oracle EF7 feature request here: https://apex.oracle.com/pls/apex/f?p=18357:39:105422858407495::NO::P39_ID:28241

That will help us prioritize the feature.

On 3/7/2016 2:11 AM, Peter Jas wrote:

@alexkeh https://github.com/alexkeh (Oracle Corp.), could you please provide some sort of hint whether Oracle team is interested in / working on delivering the EF7 provider sometime around the EF7 RTM (which is pretty soon now)? Is there anything the community can do to expedite this feature request?

— Reply to this email directly or view it on GitHub https://github.com/aspnet/EntityFramework/issues/4293#issuecomment-193190848.

nrkarthick commented 8 years ago

@alexkeh.. Any updates from your team.. ?

alexkeh commented 8 years ago

@nrkarthick No new info announced yet.

csmith93 commented 8 years ago

@alexkeh Anything new? If not, is there a place to check?

alexkeh commented 8 years ago

@nrkarthick No new info. I do have a follow up question that you and anyone else that reads this thread can answer.

Which platforms are you looking to use EF Core on: Windows, Linux, and/or Mac? If Linux, which Linux OSes?

csmith93 commented 8 years ago

Windows here. In particular, attempting to connect to a PeopleSoft Database.

ghost commented 8 years ago

@alexkeh, preferably all of them, but if the work is out in open, maybe community members such as myself can chime in and help you guys figuring out the entire dotnet-cli+project.json ecosystem.

If there already exists a GitHub repo where EF7 port is going on, please post the link and I would be happy to jump in. :swimmer:

alexkeh commented 8 years ago

@jasonwilliams200OK There are no current plans to open source Oracle EF7 provider support.

I understand you want all OSes supported. Do you have a priority list?

ghost commented 8 years ago

Thanks for clarification Alex!

Do you have a priority list?

Personally and going by CoreCLR platform support priority:

see: https://github.com/dotnet/coreclr#build-status & https://github.com/dotnet/corefx#build--test-status

@mmitche, @ellismg could you guys please confirm the CoreCLR platform support priority list for Oracle engineers (@alexkeh et al.)?

mmitche commented 8 years ago

@jasonwilliams200OK @leecow Is the right person to answer that question.

ghost commented 8 years ago

@mmitche, @leecow, for the context:

leecow commented 8 years ago

@jasonwilliams200OK @alexkeh - Here's the official list we're working toward.

Windows - 32bit and 64bit

Linux - 64bit only

Mac - 64bit only

alexkeh commented 8 years ago

@leecow That appears to be a somewhat alphabetical list. Do you have a priority for which OSes should be certified first?

leecow commented 8 years ago

@alexkeh The list is alphabetical for convenience and is the set of distros we are bringing up for the release of .NET Core, ASP.NET Core and EF Core 1.0.0.

alexkeh commented 8 years ago

@leecow Ok. You're a MS PM and you provided the official planned support list. I initially thought you were a customer.

Thanks for the list. My team will take it under advisement. We're glad to see Oracle Linux is planned. ;-)

ghost commented 8 years ago

We're glad to see Oracle Linux is planned.

True, Oracle Linux is one of the official runtime targets and has series of RIDs listed here: https://github.com/dotnet/corefx/blob/4ddf773/pkg/Microsoft.NETCore.Platforms/runtime.json (all the ol* IDs are of Oracle Linux: runtime.json#L203-L236)

ghost commented 8 years ago

@leecow, 1.0 RTM is announced. I can't find Oracle Linux package of dotnet core at https://www.microsoft.com/net/download#core. Is it yet to arrive?

rowanmiller commented 8 years ago

Oracle has not released a provider for .NET Core/EF Core as yet. You could follow up with Oracle at https://community.oracle.com/ and add your voice to the request for a provider. I can't share any plans with you as it is up to their team what they make public etc.

ghost commented 8 years ago

@rowanmiller, the status of Oracle Provider is and should be very obvious to me if you follow the conversation on this thread. My question to @leecow wasn't about the provider, I was referring to his comment above https://github.com/aspnet/EntityFramework/issues/4293#issuecomment-224981380 which indicates that "Oracle Linux" is one of the target distros for v1.0 RTM of .net core.

rowanmiller commented 8 years ago

@jasonwilliams200OK sorry about that, you're right, it was pretty obvious (I was skim reading)

leecow commented 8 years ago

@jasonwilliams200OK - Use the CentOS packages for Oracle Linux. Step by step is available at https://www.microsoft.com/net/core#centos. I'll have the folks also add an appropriate row to the download table at https://www.microsoft.com/net/download#core

ghost commented 8 years ago

Thanks; would be nice to enlist it in the table :)

nrkarthick commented 8 years ago

@leecow .. expecting the EF7 Oracle provider (for windows) will be released before July 2016.. :)

leecow commented 8 years ago

Thanks @nrkarthick !

flts commented 8 years ago

@nrkarthick Any news / ETA on a version of the EF Core Oracle provider? Thanks!

nrkarthick commented 8 years ago

@flts I am also waiting for the EF Core Oracle provider. @alexkeh/@leecow may answer your question...

alexkeh commented 8 years ago

@nrkarthick @flts No new info to report. When an announcement is ready, you'll see it tweeted out at @oracledotnet https://twitter.com/oracledotnet

nate98 commented 8 years ago

I saw a new update to Oracle Developer Tools for VS 2015 dated Sept 17th, but still no mention of EF 7 support. Can we hope to hear an announcement coming out of this week's OOW conference?

nrkarthick commented 8 years ago

@nate98 , whether EF7 supported in the latest update ? Have u tried ?

nate98 commented 8 years ago

I tried the latest update. It does not work. Here is the error I see after adding references in my project:

screen shot 2016-09-29 at 10 28 21 am
alexkeh commented 8 years ago

@nate98 The 9/17 release does not include EF7 support.

nrkarthick commented 8 years ago

@alexkeh .. thank you.. but Devart released the paid version of the provider (read here) .. and finally requesting the Oracle team to release atleast the beta version of Oracle EF core..

nrkarthick commented 8 years ago

@rowanmiller Hi.. why the name changed ?

csmith93 commented 8 years ago

@nrkarthick Probably because it's already in the aspnet/EntityFramework repo. Additionally, EF 7 was renamed EF Core months ago.

nrkarthick commented 8 years ago

ok..

nrkarthick commented 7 years ago

Hi folks .. any updates ?..

vilinski commented 7 years ago

any updates for Oracle on .NET Core?

csmith93 commented 7 years ago

@nrkarthick, @vilinski this was closed as it's a vendor issue, not a EF Core issue. It's Oracle's responsibility to make their platform work with EF, not the other way around. @alexkeh has mentioned in this thread where you can find updates, and you can also request this to be prioritized here: https://apex.oracle.com/pls/apex/f?p=18357:39:105422858407495::NO::P39_ID:28241.