VS2017开发C#连接Oracle12c：官方ODT安装是否必要？

Great question—this is a common point of confusion for .NET developers working with Oracle, so let’s break it down simply:

Short Answer #

• ODT for VS2017 is NOT required for basic C# database connectivity and operations with Oracle 12c.
• Using only NuGet packages is fully sufficient if all you need is to write code that connects to, queries, and modifies your Oracle database.

Longer Explanation #

Let’s unpack why your initial ODT installation didn’t resolve the OracleConnection issue, and what each option actually provides:

1. Why your ODT install didn’t fix the type recognition #

ODT (Oracle Developer Tools for Visual Studio) installs a set of VS-integrated tools and adds Oracle assemblies to your system’s GAC (Global Assembly Cache). However, just installing it doesn’t automatically add references to your project—you’d still need to manually browse to the GAC or use the VS reference manager to add Oracle.ManagedDataAccess or Oracle.DataAccess.

NuGet packages, by contrast, directly add the required assembly references to your project and manage dependencies for you, which is why it worked immediately for you.

2. What ODT actually offers (when it’s useful) #

While ODT isn’t mandatory for code-level database work, it does add valuable developer tools if you want a more integrated VS experience:

• Visual Oracle database connection manager (browse schemas, tables, procedures directly in VS)
• PL/SQL editor with syntax highlighting and debugging support
• Entity Framework (EF) designer support for Oracle models
• Oracle-specific database project templates
• Integration with VS’s Server Explorer for database objects

If you don’t need any of these visual tools and just want to write raw ADO.NET code or use EF Core with Oracle, you can skip ODT entirely.

3. NuGet package recommendations #

For your VS2017 and Oracle 12c setup, stick with Oracle.ManagedDataAccess from NuGet—it’s the fully managed (no native Oracle client required) assembly that handles all core database operations. If you ever move to newer .NET versions (like .NET Core/.NET 5+), you’d switch to Oracle.ManagedDataAccess.Core, but the managed package works perfectly for .NET Framework in VS2017.

Final Verdict #

Use NuGet alone if you only need to implement database logic in code. Install ODT only if you want the extra VS-integrated development tools to streamline your workflow. You don’t need both to get your C# project up and running with Oracle 12c.

内容的提问来源于stack exchange，提问作者user1205746