ODP.NET Managed Driver Beta - Quick Start

What people said

Recommends b_levitt · 2013-07 · Stack Overflow · on “Oracle ODP.net Managed vs Unmanaged Driver”

Bullets from the quick start video [this video] : Fewer files (1 or 2 dlls at most) Smaller footprint (10 MB compared to 200 MB) Easier side by side deployment Same assembly for 32 and 64 bit (except for second MTS assembly). Code Access Security I'm not sure about performance but I doubt it will be much different either way. My guess is that the two drivers communicate in an identical way over "Oracle Net." While there might be minor differences in the in-memory client side operations done to prepare a command and process the results, this overhead typically only represents a fraction of the time relative to the entire transaction. Most of the cost/time is spent on the server in physical IO and

Recommends Riju · 2013-08 · Stack Overflow · on “Does ODP.NET require Oracle Client installation”

you can get managed ODP.NET using NuGet too [LINK] PM> Install-Package odp.net.managed Watch the quick start video on using ODP.NET Managed Driver! (copied from [LINK] ) [this video] Update: NuGet for Official Oracle ODP.NET, Managed Driver [LINK] Or Package Manager Console PM> Install-Package Oracle.ManagedDataAccess

Cites user1756858 · 2012-10 · Stack Overflow · on “Need to deploy .net application (that queries oracle database from server) in "oracle-less" machine?”

I'm a junior .net developer.I have developed a simple client application (.net3.5) which needs to gets its results from the 10g oracle database server. This application is to be deployed in 100 32-bit systems who do not have oracle installed but they have access to the server.We don't intend the users to have oracle installed in their machine. Is that possible? I followed [LINK] whatever is said in this link,and it generates the version mismatch error mentioned in the bottom of the link. Does it work without having oracle client in the user's machine, cos it is working fine in my machine as it has oracle installed.Is there any other way to work around this? My connectiopn string is : OracleC

Cites b_levitt · 2013-01 · Stack Overflow · on “What is the minimum that a client needs to install to use a program that uses Entity Framework 4 to connect to Oracle 11.2.0.3.20?”

I should also mention that oracle is working on a fully managed driver which is currently in beta: [LINK] Not sure if a beta product is acceptable to you but it's worth noting. Here is a youtube video as well: [this video]

Cites Stritof · 2013-04 · Stack Overflow · on “Oracle instant client with C# windows forms application”

There is also fully managed .net connector aka ODP.NET Managed Driver: Installation instructions, Release Notes [LINK] Download [LINK] [this video] I've tested it on Windows 8 and Windows XP SP3 with .NET 4.0 framework installed - all working as expected. For deploying, only 1 dll is needed (Oracle.ManagedDataAccess.dll) which weights 6 MB (in comparison with instant client lite which was almost 40 MB). UPDATE: Probably the best way to use managed oracle driver is via NuGet ( ODP.NET @ nuget [LINK] )

Cites b_levitt · 2013-08 · Stack Overflow · on “ODP.NET avoid conflict with existing oracle client”

Use the tnsadmin environment variable (your tnsnames.ora and sqlnet.ora should be in folder you specify): Also keep in mind that I don't believe that copying the unmananged dlls is a supported deployment option (though I have seen other people do exactly that). These days I'd recommend the managed provider: [LINK] [this video]

Cites b_levitt · 2013-10 · Stack Overflow · on “How to embed ODP.NET Oracle Data Client with Windows Setup”

You have two choices outside of installing the full oracle client: Use the new managed provider [this video] Use the "xcopy" installation which can be installed with a batch file. [LINK]