SQL Anywhere and the ADO.NET Entity Framework
This whitepaper describes how database application developers can use SQL Anywhere 11 and the ADO.NET Entity Framework to build database-driven applications. This whitepaper also describes how the Language Integrated Query (LINQ) to Entities, Object Services, and the EntityClient Provider methodologies can be used to access data stored inside a SQL Anywhere database.
Read more
ADO.NET in Disconnected Mode
You see how ADO.NET differs from its predecessor when you start working in disconnected mode. ADO 2.x permits you to work in disconnected mode using client-side static recordsets opened in optimistic batch update mode. This was one of the great new features of ADO that has proved to be a winner in client/ server applications of any size. As a matter of fact, working in disconnected mode is the most scalable technique you can adopt because it takes resources on the client (instead of on the server) and, above all, it doesn”t enforce any locks on database tables (except for the short-lived locks that are created during the update operation).
Read more
Using DataDirect Connect for ADO.NET with Oracle Real Application Clusters (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 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 fi
Read more
ADO and ADO.NET Object Model Comparisons: A Relational Perspective
Microsoft has, and still is, a significant contributor toward the development and innovation of software technology. An important aspect to any software technology is the creation, storage, processing and transfer of data. This paper focuses on two Microsoft data-access technologies, ADO and ADO.NET, the later being the more recent technology. ADO is an acronym for ActiveX Data Objects and though the literal ”ADO” is used in both, ADO.NET is a part of the new .NET platform, a different architecture to the one in which ADO was designed. ADO and ADO.NET are part of two different Microsoft technology infrastructure strategies.
Read more
Develop a sample application using LINQ programming and the ADO.NET Entity Framework with IBM DB2, IDS, and U2 servers
The IBM Data Server Provider for .NET enables application developers to take advantage of the Microsoft? Entity Framework and LINQ. You can easily develop data access .NET applications using one of the IBM data servers (DB2, Informix Dynamic Server, or U2), the Microsoft ADO.NET Entity Framework, and LINQ. This article shows you how to get started using the Entity Framework with one of the IBM data servers, walking you step-by-step through the process of creating your own application.
Read more