Coming October 25: PeerSpot Awards will be announced! Learn more
2017-07-19T14:25:00Z
it_user705228 - PeerSpot reviewer
User at a tech company with 51-200 employees
  • 9
  • 1086

ADO.NET VS ODP.NET - Which is better?

Which do you recommend? Reasons? Thanks!

9
PeerSpot user
9 Answers
PeerSpot user
Talend developer at a tech vendor with 501-1,000 employees
Vendor
2017-07-20T13:15:00Z
20 July 17

The ADO provider is the standard data access code for Oracle from .NET:
Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including
Real Application Clusters
XML DB
The Oracle Providers for ASP.NET you mention, is a specific release for helping with things like ASP.NET State Management, Membership and Roles:

ASP.NET provider developers will discover the Oracle Providers for ASP.NET are easy to learn and use as they share a common schema and API with existing ASP.NET providers. They integrate seamlessly with existing ASP.NET services and controls, just like other ASP.NET providers.

Oracle offers the following providers:
Membership Provider
Role Provider
Site Map Provider
Session State Provider...

PeerSpot user
Senior Developer at a tech services company
Consultant
2017-07-20T11:28:38Z
20 July 17

ODP.NET is better in case of working with multiple databases as well as in complicated cases. For simple cases or microsoft environments, you can go with ADO.NET

Ahsan Nabi Khan - PeerSpot reviewer
Postgraduate Research at University of Derby
Real User
2017-07-20T10:51:20Z
20 July 17

ADO.NET is simpler than ODP.NET. You should start with the first in case you have all microsoft based applications. In the minor case your company requirements are in big data terabytes you use Oracle ODP.NET as a adapter to .NET Common Language Runtime

PeerSpot user
Technical Consultant at a tech services company with 1,001-5,000 employees
Consultant
2017-08-02T08:16:50Z
02 August 17

ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, and fast connection failover.

PeerSpot user
Manager, Data Engineering Unit at a financial services firm with 1,001-5,000 employees
Vendor
2017-07-22T18:41:42Z
22 July 17

Talking about an oracle provider, Microsoft cannot possibly do a better job than than the owners of the database(Oracle). ODP is if feature-rich and supports a host of features that ADO simply doesn't (After all there is no point in going through all that for a competitor). ADO.NET is just fine for simple database operations. Check link below for a detailed comparison.
http://www.oracle.com/technetwork/topics/dotnet/index-154765.html

Ajitsingh Thakur - PeerSpot reviewer
Associate (MS) at a tech services company with 501-1,000 employees
Real User
2017-07-22T08:34:33Z
22 July 17

Hello,
ADO.NET is better for some client in application development if you are start with Microsoft based application.
ADO.NET provider developed by Microsoft and its as a part of .NET Framework. Microsoft continue to provide support for issues in Oracle Client .NET Framework 4.0.

AND
ODP.NET is the .NET provider for Oracle database developed by Oracle.
Oracle provides .NET classes for accessing an Oracle databaMicrosoft is removing the Oracle data provider from its ADO.NET roadmap.

I heard that "Microsoft it decided discontinue its System.Data.OracleClient because a significant percentage of its MVPs tend to use alternative third-party offering are derived from ADO.NET base classes. This library is sometimes referred to as ODP.NET."
Is it correct ?

Find out what your peers are saying about ASP.NET vs. Microsoft Visual Studio and other solutions. Updated: September 2022.
634,775 professionals have used our research since 2012.
it_user705228 - PeerSpot reviewer
User at a tech company with 51-200 employees
Vendor
2017-07-20T19:12:36Z
20 July 17

Thanks you all for your answers! I appreciate it and have have passed them along!

PeerSpot user
Software Developer at a media company with 1-10 employees
Vendor
2017-07-20T11:16:06Z
20 July 17

.NET ORM COMPARISON

1. ENTITY FRAMEWORK – have used and I like it (especially entity framework core)
2. ADO.NET (have used a little and cant complain but cant prefer it entity framework)
3. ODP.NET (have never used)

PeerSpot user
Software Engineer at a tech vendor with 51-200 employees
Vendor
2017-07-20T11:15:10Z
20 July 17

What is database? Oracle?

Related Questions
Ariel Lindenfeld - PeerSpot reviewer
Director of Content at PeerSpot (formerly IT Central Station)
Feb 16, 2019
Let the community know what you think. Share your opinions now!
2 out of 14 answers
PeerSpot user
Digital Strategist & Product Owner, Enterprise at a tech services company with 51-200 employees
10 January 17
Deep integration knowledge with other platforms and services with excellent mobile development experience.
PeerSpot user
Owner at a tech services company
27 January 17
SHORT VERSION: Broad knowledge of .net Frameworks for developers and deep knowledge of platforms for integrator. LONG VERSION: If development focused do they demonstrate understanding of OOP concepts, ability to apply common development patterns in .net and explain their methodology to manage the dev life-cycle such as their flavor of agile. A warrior's arrow fired without fins to guide it is a dangerous thing. Do they think about the .net world? Curious developers will always evolve and that's a good thing. Ask which two emerging .net frameworks in two years will be on the rise and which two will be on the way to the grave, then ask the dreaded why? Ask them what platforms they have worked with, when, and if they had to work with that platform again what would they not look forward to doing? Some providers will be specialists, some generalists, depends on your project's needs, both have their place. If they haven’t used Quartz.NET and are building you a scheduling application, not the end of the world but if they don’t at least know it exists along with similar frameworks, that might be a warning flag. In summary, determine if their knowledge of frameworks or platforms is sufficient for your project.