SYBASE .NET DATA PROVIDER

100% managed code
Only DataDirect providers are 100% managed, making no call outside the .NET runtime environment.

This improves application performance, scalability, stability, and security by eliminating the application’s reliance on components that reside outside the managed environment.

Sybase’s provider is not 100% managed because it relies on the Open Client libraries, which means it makes calls to unmanaged code.

If you’re deploying many .NET applications, or if your applications need to handle large amounts of data, these numerous calls outside the CLR can seriously degrade performance and become a scalability nightmare.

No database client libraries required
Cost to develop, test, and deploy are significantly reduced because the database client libraries aren’t needed. It also eliminates application issues related to client version conflicts.

Sybase providers require native database clients be installed.

Best ADO.NET provider performance and scalability
DataDirect providers outperform other providers in throughput capacity and memory and CPU utilization.

DataDirect providers expose the full range of Sybase features to ADO.NET Entity Framework (EF 4.2 and 1.0) applications. By leveraging a 100% managed code architecture, there is absolutely no need to deploy the Sybase client libraries with Entity Framework applications. In addition, this architecture delivers the best possible runtime performance to all Entity Framework (EF 4.2 and 1.0) applications.

DataDirect providers are optimized for best possible performance in the most common application scenarios, especially those handling large amounts of data.

The provider is tunable for an infinite variety of application usage scenarios so your application will always run faster and support more users with the same hardware resources.

Sybase providers do not offer any support for the Entity Framework (EF 4. and 1.0) at all. Instead, they require calls to Open Client libraries, causing it to bridge into unmanaged code. Client libraries are not optimized for ADO.NET and create communication overhead on the network that degrades performance and impacts scalability.

Faster, more flexible application deployment
Because it does not require database client libraries, the DataDirect provider supports “side-by-side” installation, allowing you to run multiple applications using different versions of the database on the same machine. This eliminates the need to re-qualify unrelated applications if an application is updated.

Requires different client libraries on each machine where the data provider is deployed.

If multiple applications are running on the same machine, they will all be forced to use the same underlying client libraries. This can be painful if there are several applications that need to be certified for a particular version of the client libraries.

Robust security features
100% managed code ensures no reliance on components outside the .NET managed environment and allows your application to take full advantage of the security controls in .NET.

DataDirect providers include advanced security features such as SSL (Secure Socket Layer) data encryption and operating system authentication (aka Single Sign-On) via Kerberos.

Calls to unmanaged code in the client libraries bypasses the .NET CLR security. This opens a door to potential compromise via code that uses pointers or has direct access to memory or machine registers. Once that unmanaged code is executing, the CLR can no longer check it.

One provider supports multiple Sybase versions
One DataDirect provider supports simultaneous connections to Sybase 11.x, 12.x, and 15.0, which significantly reduces the cost of deploying and testing applications against multiple versions of Sybase and its client libraries.

This significantly reduces the costs of deploying and testing applications against multiple versions of Sybase and multiple versions of its client libraries.

Requires different providers for different versions of Sybase.

DataDirect Bulk Load
Includes a high-performance bulk load capability for loading large amounts of data very quickly. This can boost application performance for parameter array insert operations without requiring code changes or additional bulk load tools.

Requires a proprietary tool from Sybase or your own homegrown tool.

Complete interoperability between databases
SQL up-leveling and other interoperability features make it easy and cost effective for an application to support multiple databases (Sybase, Oracle, DB2, and SQL Server).

This interoperability reduces the total cost of development, testing, and deployment for heterogeneous environments.

Interoperability is not provided because the Sybase provider is designed to work only with Sybase. Organizations that need to access more than Sybase will be forced to use providers from different vendors, requiring a learning curve for each one.

Reliability for demanding production environments
DataDirect providers are quality tested and certified using the DataDirect ADO.NET Verification Suite (ADOVS).

This comprehensive testing ensures that you can develop the most robust Sybase .NET application.

Sybase’s testing infrastructure for data access components is unknown.

Comprehensive Technical Support
Focused on database connectivity, our award-winning support includes 24x7 phone, web, email, forum, and an extensive knowledgebase.

Fast, high-quality technical assistance from data connectivity experts is essential for critical systems.

Because Sybase is not focused on data connectivity, troubleshooting can be more difficult and may take longer.