Overview: DataDirect Connect for .NET
DataDirect Connect for .NET is the industry's only suite of ADO.NET data providers with a 100% managed architecture, eliminating the need for database clients, boosting performance, and delivering a flexible, secure connection to Oracle, DB2, Microsoft SQL Server, and Sybase. Connect for .NET provides unparalleled interoperability for .NET applications by abstracting differences between different databases and database versions. Developers can use Connect for .NET to write and deploy applications that connect to multiple databases, while reducing the amount of code necessary to utilize features specific to each database. Without the need for database clients, Connect for .NET eliminates risks and closes holes that unmanaged code leaves exposed, and provides developers the most versatile deployment options available in both application- and client-server environments.
100% Managed Code for Better Security, Performance and Flexibility
DataDirect Connect for .NET is the only product to bring the power, performance, and security of 100% managed code to .NET data connectivity. Because it runs entirely within the protected environment of the .NET Framework, your applications can take advantage of the built-in reliability, security and management capabilities of the .NET Framework.
As a 100% managed code provider, DataDirect Connect for .NET eliminates the need for database client libraries such as Oracle Net for Oracle 10g. This not only improves performance, it enables applications to utilize different versions of the data providers in a shared environment. This architecture also reduces rollout time and maintenance costs, as it can be easily deployed through the No-Touch deployment method.
Quality and Advanced Functionality
DataDirect Connect for .NET providers are rigorously tested against DataDirect Technologies proprietary test suites under production conditions to ensure a superior quality product.
DataDirect Connect for .NET supports the latest database versions and features and advanced functionality across all major databases such as distributed transactions, connection pooling, Windows authentication for SQL Server, and connection failover and client-side load balancing.
Maximizes Interoperability Across Databases
DataDirect Connect for .NET enables applications to access multiple databases with fewer lines of code and less maintenance, ensuring consistent functionality and performance, regardless of the database.
Common code base across all providers reduces the amount of code necessary to access multiple databases, while providing consistent functionality
Standard “escape” syntax support for stored procedures, outer joins, scalar functions, and date, time and timestamps for all databases
Standard error code mappings (SQLStates)
Standardized parameter markers ("?") across all databases
Features
Does not require database client libraries, providing faster performance, faster deployment, and reduced maintenance; enables support for multiple versions of a database with a single provider
Interoperability features: Standardized parameter markers (“?”) for stored procedures across all databases; standard error code mappings (SQLStates); support of standard SQL escape syntax for stored procedures, outer joins, scalar functions and date, time and timestamps
Supports new Oracle 10g Float and Double Data types and supports Oracle RAC.
Connection failover support and client-side load balancing for all databases.
Distributed transaction support using Microsoft Distributed Transaction Coordinator (DTC) for all providers
Microsoft-compatible Connection Pooling
Supports Windows authentication for Microsoft SQL Server
Includes support for Command Builders for faster development
Built-in debugging tools and tracing capabilities for faster development
Databases
Oracle, DB2, Microsoft SQL Server, Sybase
100% Managed Code for Better Security, Performance and Flexibility
DataDirect Connect for .NET is the only product to bring the power, performance, and security of 100% managed code to .NET data connectivity. Because it runs entirely within the protected environment of the .NET Framework, your applications can take advantage of the built-in reliability, security and management capabilities of the .NET Framework.
As a 100% managed code provider, DataDirect Connect for .NET eliminates the need for database client libraries such as Oracle Net for Oracle 10g. This not only improves performance, it enables applications to utilize different versions of the data providers in a shared environment. This architecture also reduces rollout time and maintenance costs, as it can be easily deployed through the No-Touch deployment method.
Quality and Advanced Functionality
DataDirect Connect for .NET providers are rigorously tested against DataDirect Technologies proprietary test suites under production conditions to ensure a superior quality product.
DataDirect Connect for .NET supports the latest database versions and features and advanced functionality across all major databases such as distributed transactions, connection pooling, Windows authentication for SQL Server, and connection failover and client-side load balancing.
Maximizes Interoperability Across Databases
DataDirect Connect for .NET enables applications to access multiple databases with fewer lines of code and less maintenance, ensuring consistent functionality and performance, regardless of the database.
Common code base across all providers reduces the amount of code necessary to access multiple databases, while providing consistent functionality
Standard “escape” syntax support for stored procedures, outer joins, scalar functions, and date, time and timestamps for all databases
Standard error code mappings (SQLStates)
Standardized parameter markers ("?") across all databases
Features
Does not require database client libraries, providing faster performance, faster deployment, and reduced maintenance; enables support for multiple versions of a database with a single provider
Interoperability features: Standardized parameter markers (“?”) for stored procedures across all databases; standard error code mappings (SQLStates); support of standard SQL escape syntax for stored procedures, outer joins, scalar functions and date, time and timestamps
Supports new Oracle 10g Float and Double Data types and supports Oracle RAC.
Connection failover support and client-side load balancing for all databases.
Distributed transaction support using Microsoft Distributed Transaction Coordinator (DTC) for all providers
Microsoft-compatible Connection Pooling
Supports Windows authentication for Microsoft SQL Server
Includes support for Command Builders for faster development
Built-in debugging tools and tracing capabilities for faster development
Databases
Oracle, DB2, Microsoft SQL Server, Sybase
