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
Moving from ADO to ADO.NET
Let’’s face it—most Microsoft Visual Basic applications have some sort of data access. If your application uses ActiveX Data Objects (ADO), you probably want to know what improvements you can make now that you are upgrading to Visual Basic .NET. The .NET Framework offers a whole new set of controls and services, including ADO.NET.
Read more
Data Access with ADO.NET
ADO.NET
3
= Is the .NET technology for accessing structured data
= Uniform object oriented interface for different data sources
– relational data bases
– XML data
– other data sources
= Designed for distributed and Web applications
= Provides 2 models for data access
– connection-oriented
– connectionless
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