概览

提供快速、先进的ADO.NET
dotConnect for Oracle不仅可以高效地连接到Oracle数据库，还提供了新的开发工具和技术。它支持大部分Oracle中特有的功能，如高级队列、提醒、通道、直接路径加载、更改通知、程序故障轻松恢复、REF游标、对象、包，等等。

RAD方法
大量的GUI工具集成在Visual Studio Server Explorer和一些其他的工具中。通过这些先进的可视化编辑器组件来简化工作，提高工作效率。这些数据集工具（例如DataSet Wizard, DataSet Editor, DataSet Manager），使您创建和编辑类型化和非类型化的数据集更简便。

ORM解决方案
dotConnect for Oracle提供了可视化设计的ORM模型—实体开发。dotConnect for PostgreSQL支持ADO.NET实体框架，NHibernate和LinqConnect（原名LINQ to PostgreSQL）。我们的ORM解决方案，可以很好的兼容Microsoft LINQ to SQL，并增强了其功能。

		Direct模式 允许直接通过直接通过TCP/ IP使用Oracle，而不用通过Oracle的客户端。
		ASP.net 实现角色，会话状态，会员资格，资料，网站地图和提供其他ASP2.0。
		企业库 能与Microsoft Enterprise Library Data Access Application Block一起使用。
		BIS 可以在集成服务器和Oracle服务器之间导入和导出数据。
		监控 允许数据库的每个组件跟踪事件有一个自由的dbMonitor程序。
		兼容性 支持Oracle12C、11G、10G、9i、8i、8.0、.NET 7.3、.NET Compact Framework2.0及以上版本和Mono。

不同版本功能对比

功能	开发版	专业版	标准版	移动版	精简版
.NET Framework支持
.NET Core支持
.NET Compact Framework支持
ADO.NET core classes
Native data types类与结构
Direct mode
OracleScript class
OracleMonitor class
OracleDataTable class
OracleDataSet class
OracleLoader class
OraclePackage class
OracleAlerter class
OraclePipe class
OracleTrace class
OracleDependency class
OracleDatabase class
DataLink class
OracleDataSource component for web applications
Design-time features, including component editors and property editors
Oracle Advanced Queue technology 支持
Entity Framework 支持
LinqConnect 支持
NHibernate 支持
Entity Developer
Workflow Foundation 支持
Advanced Visual Studio 2008 - 2017 integration
ASP.NET providers 支持
SQL Server Business Intelligence Solutions 支持
Sync Framework 支持
Enterprise Library 支持
InterForm technology
DataSet Manager and Editor
DataSet Wizard
Oracle Package Wizard
Oracle Object Wizard
Migration Wizard
dbForge Fusion for Oracle Standard Edition
dbMonitor 支持

Following the main features of the dotConnect for Oracle Data Provider.

• Direct mode to access without Oracle client
• 100% managed code
• High performance
• Supports Oracle 10g, 9i, 8i and 8.0, including Personal and Express editions
• All Oracle data types support
• Support Oracle object types OBJECT, VARRAY, TABLE, REF
• Support Oracle XML type
• Easy to deploy
• .NET Compact Framework support
• OracleScript component to execute scripts
• OracleLoader component for fast loading data
• OraclePackage component for easy working with PL/SQL packages
• OracleDataTable component to retrieve and manipulate data from Oracle server data source
• Metadata retrieval support
• Ability of monitoring query and stored procedures execution by DBMonitor
• Array binding feature
• PL/SQL tables support
• PL/SQL records support
• Transparent Application Failover support
• OS authentication enabled
• DBA privileges to open a session with
• Fill DataSet with several REF CURSOR
• Fill DataSet with object, array and nested table data
• Structural representation and editing of Oracle objects with OracleDataTable component
• Advanced connection pooling
• Paginal access to query result
• Asynchronous execution support
• Ability to store data in OracleDataReader object
• Base-Class-Based provider model
• Working with Oracle homes
• Advanced design-time editors
• Dataset Wizard to leverage design-time setup
• Generate DataSet Wizard
• Support for Data Access Application Block in Enterprise Library
• ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
• TableMapping editor
• Data preview
• Advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
• Integration with OraDeveloper Tools for browsing database schema, manipulating database objects and visual building of queries
• Wrapping PL/SQL packages with Package Wizard
• Easy migration from MS OracleClient and ODP.NET with Migration Wizard
• Help integrated into IDE
• Free support for registered users during 1 year
• Licensed per a developer without royalty fee