ADO.NET Tutorials

100% Managed Code Access To Oracle From NHibernate

Want to simplify and increase the performance of your NHibernate deployment? Now you can use 100% managed code ADO.NET providers from Progress® DataDirect® that allow you to avoid using client libraries such as Oracle OCI.

Learn More

ADO.NET No-Touch Deployment

Traditional methods of deploying applications for a large user groups require significant effort to ensure that all users have the correct version, and problems are resolved uniformly across the installation.

Learn More

ASP.NET to Sybase 15.5 with the ADO.NET Entity Data Framework

In this tutorial, we demonstrate how you can easily connect Microsoft Visual Studio to a Sybase 15.5 server by using DataDirect's Connect for ADO.NET in conjunction with the ADO.NET Entity Framework. This configuration lets you fully exploit the power of Microsoft's ADO.NET Entity Data Framework when working with Sybase without needing to write any code.

Learn More

Code Examples - Microsoft SQL Server

Since the release of our first ADO.NET data providers in June, 2002, DataDirect Technologies has been fully committed to boosting operational performance in real-world environments such as Microsoft SQL Server.

Learn More

Connection Pooling in .NET Applications

Connecting to a database is the single slowest operation performed by a data-centric application. This document describes how reusing pooled connections, can improve .NET application performance, describes the performance advantages of DataDirect's technique of handling dead connections in a connection pool, provides tips on opening and closing connections, and includes C# code examples illustrate how to create connection pools and handle distributed transactions when using a connection pool.

Learn More

Converting .NET Applications to Use Connect for ADO.NET

This page is about data providers that work with the Microsoft .NET Framework 1.1, see the DataDirect Connect for ADO.NET product page for information about data providers that support Microsoft .NET Framework 2.0 and higher.

Learn More

Designing Performance-Optimized .NET Applications

This document presents some general guidelines to help you improve the performance of your .NET applications. In addition, it contains C# code examples that illustrate best practices for optimizing performance.

Learn More

Failover Support in DataDirect ADO.NET Data Providers

In today's business environment, you need to ensure that the data on which your critical .NET applications depend is always available. This document describes why it is important that your ADO.NET data provider includes connection failover support.

Learn More

Getting Started with LINQ and Entity SQL Queries to Oracle 11g

In this tutorial, we explore how easy it is to connect Microsoft Visual Studio to an Oracle 11g server by using DataDirect’s Connect for ADO.NET in conjunction with the ADO.NET Entity Framework. This configuration lets you fully exploit the power of the Microsoft ADO.NET Entity Data Framework when working with Oracle.

Learn More

IBM DB2 ADO.NET Data Provider Code Examples

This page is about data providers that work with the .NET Framework 1.1, see the DataDirect Connect for ADO.NET product page for information about data providers that support .NET Framework 2.0 and higher.

Learn More

Interoperability Across Data Access APIs through SQL Up-leveling

SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2. Each of the major database vendors implements certain functionality in a unique proprietary format.

Learn More

Interoperability and Microsoft .NET

Microsoft's decision to have a flexible specification for the way that data providers access databases means that the implementations of ADO.NET data providers for different databases can vary widely. Even when using the Common Model for ADO.NET 2.0 to write provider independent code, programmers who switch to different data stores must expect to change their code, or even their coding logic.

Learn More

LINQ and Entity SQL to Oracle Using the ADO.NET Entity Framework

In this article, we explore how easy it is to connect Microsoft Visual Studio to a Sybase 15.5 server by using DataDirect’s Connect for ADO.NET in conjunction with the ADO.NET Entity Framework. This configuration lets you fully exploit the power of Microsoft’s ADO.NET Entity Data Framework when working with Sybase.

Learn More

Microsoft Enterprise Library DAAB

Microsoft Enterprise Library Data Access Application Block (DAAB) is an assembly that encapsulates the logic used to perform common enterprise-level data access tasks.

Learn More

Support for 2007 Daylight Saving Time (DST) in ADO.NET products

The United States has planned a change to its Daylight Saving Time (DST) observance beginning in 2007. The Energy Policy Act of 2005 mandates that DST will start on the second Sunday in March and end on the first Sunday in November. For 2007, this means that DST will start and end on the following dates:

Learn More

The Importance of Using 100% Managed Code

This tutorial reviews the benefits and advantages of using managed code in .NET applications. Managed code runs in the Common Language Runtime (CLR), which provides services such as automatic memory management, platform-neutrality, and cross-language integration.

Learn More

Using Datadirect Connect for ADO.NET with Oracle RAC

Oracle RAC, as implemented in Oracle 9i and Oracle 10g, allows a single physical Oracle database to be accessed by concurrent instances of Oracle running across different CPUs. This document explains how the Progress DataDirect Connect for ADO.NET Oracle data provider can connect to an Oracle RAC system as if it was a single instance of an Oracle database. The data provider can use a connection string or retrieve specific connection information from a tnsnames.ora file.

Learn More

Using ODBC/JDBC SQL Escape Sequences in .NET Applications

ADO.NET does not define a query language; therefore, data providers are not required to mask the differences in supported SQL statements between databases. DataDirect Technologies™ provides support for ODBC/JDBC SQL escapes for scalar functions, outer joins, and stored procedures in our providers. This means that developers can pass standardized SQL statements to all our data providers.

Learn More