N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

SQL SERVER PROVIDER FOR .NET

The Only 100% Managed Code SQL Server Provider for All SQL Server Versions

100% Managed vs. Unmanaged Provider SQL Server Provider
Click to Enlarge

The Progress DataDirect Connect SQL Server provider for .NET is thoroughly proven in data transaction intensive environments in which high performance, stability and security are mission-critical requirements.  

Try it now – SQL Server provider download. 




Improves the Performance and Scalability of .NET SQL Server Applications
  • Outperforms other providers in throughput capacity and memory / CPU utilization
  • 100% managed, making no calls outside the .NET runtime environment. Completely eliminating reliance on non-managed components dramatically improves application performance and scalability.
  • High-performance Bulk Load capability enables loading large amounts of data into SQL Server very quickly, without requiring application code changes or additional bulk load tools.
Provides Comprehensive Database / Platform Coverage from One Vendor DataDirect can serve all your data connectivity needs, for any API (JDBC, ODBC, .NET) for any major database—SQL Server, Oracle, DB2, Sybase, and more, while offering extensive platform support.
Makes It Easy and Cost Effective to Support Multiple Databases and Database Versions One DataDirect provider supports simultaneous connections to SQL Server 2000, 2005, and 2008, which significantly reduces the cost of deploying and testing applications against multiple versions of SQL Server.
Ensures Secure, End-to-End Application Data Access

DataDirect providers include advanced, industry-standard security mechanisms:

  • SSL data encryption to secure the integrity of your data and provide client/server authentication
  • Operating system authentication via Kerberos, allowing you to include database access in a Single Sign-On environment

In addition, 100% managed code ensures no reliance on components outside the .NET managed environment, allowing the application to take full advantage of the security controls in .NET.
Guarantees Reliability for Demanding Production Environments DataDirect providers are quality tested and certified using our extensive ADO.NET Verification Suite (ADOVS), verifying all supported Windows platforms and SQL Server database versions. We also test ADO.NET conformance using the Microsoft LTM (Local Test Manager). This comprehensive testing ensures that you can develop the most robust SQL Server .NET application.
Offers 100% Specification Compliance and Robust Functionality

DataDirect providers are certified for use with .NET Framework versions 2.0, 3.0, 3.5 and 4.0 (32-bit and 64-bit), are fully compliant with ADO.NET 2.0, and offer advanced functionality such as:
Reduces Total Cost of Ownership through Superior Technical Support Focused on database connectivity, our award-winning support includes 24x7 phone, web, email, forum, and an extensive knowledgebase. Superior technical support is essential to resolve data connectivity issues quickly, thereby reducing the total cost of ownership of software.

 

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

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 SQL Server
  • 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

SQL Server Features

  • Managed code assemblies – Call procedures that are defined as .NET Managed Code Assemblies in the same fashion that stored procedures are invoked. This allows you to leverage the advantages of the 100% managed run-time.
  • Triggers on DDL Events – Associate a trigger with Data Definition Language (DDL) statements such as CREATE TABLE.
  • Support for Snapshot transaction isolation level – Support for new transaction isolation levels introduced in the SQL Server 2005 release: Read Committed with Snapshots and Snapshot Isolation Level. These new transaction isolation levels provide optimistic locking capabilities, allowing greater application transaction control.

.NET Framework

  • Support for .NET Framework 2.0, 3.0, 3.5, and 4.0
  • Support for .NET Framework 1.x
  • ADO.NET 2.0 conformance
  • Support for version 5.0 of the Enterprise Library including the Data Access Application Block (DAAB) and the Logging Application Block (LAB)