|
Performance
|
|
|
Security
|
- Operating system authentication (aka Single Sign-On) via Kerberos
- SSL data encryption
- Optimal use of .NET Framework security controls
|
|
Enterprise Application Functionality
|
- Connection failover and load balancing
- Bulk load operations via ADO.NET Bulk APIs
- Side-by-side installation
- Load balancing
- ClickOnce deployment
- SQL up-leveling
- Interoperability between databases and different versions of each database
- Single Sign-On
- Statistics in Entity Framework
|
|
ADO.NET Programmability
|
- ADO.NET 3.5
- ADO.NET Entity Framework (EF 4.0 and 1.0) support - Quickly develop robust enterprise applications using LINQ and Entity SQL Queries (view tutorial), and ADO.NET Data Services (view tutorial)
- Enterprise Libraries 5.0 including the Data Access Application Block (DAAB) and the Logging Application Block (LAB)
NHibernate
|
|
Provider Functionality
|
- Support for LINQ, Entity SQL, and Microsoft Enterprise Libraries
- Seamless integration with Visual Studio 2005, 2008, and 2010
- One provider supports all versions of Oracle
- Statistical counters integrated with Windows perfmon
- Full Unicode and ANSI character set support
- Built-in runtime troubleshooting and tracing capabilities
- Advanced data type support
- Distributed transaction support
|
|
Oracle Features
|
- Broad support for Oracle data types: all timestamp data types, NChar, NVarchar, NClob, ROWID, Binary Float, Binary Double
- Oracle RAC support
- TNSNAMES.ORA support
- Tunable and fine-grained control of meta-data schema options
- Oracle-style REF Cursors support – Can use overloaded stored procedure using REF Cursors. This allows Oracle-based applications to more easily migrate to DataDirect Connect for ADO.NET.
- Ability to execute PL/SQL upon connection
- Ability to use native Named Parameter format in stored procedure calls
- Support for PL/SQL Associative Arrays (Table type) as input parameters to Stored Procedures
- Support for multiple TNS Names files for failover purposes
- Supports the ability to execute a single SQL statement using multiple rows of values
- SYSDBA / SYSOPER login support – Associates the SYSDBA and / or SYSOPER role with a user. This is necessary since some database operations require privileged access.
- Server-side result set caching to boost performance for specific application operations connecting to Oracle 11g without changes to the application code
- Transparent Data and Tablespace Encryption support
- SECUREFILE LOB Storage support
|
|
.NET Framework
|
- Support for .NET Framework 2.0, 3.0, 3.5, and 4.0
- 32-bit and 64-bit version support
- Support for .NET Framework 1.x
- Silverlight Support
|
