Working with Data in ASP.NET 2.0 - Efficiently Paging Through Large Amounts of Data
As we discussed in the preceding tutorial, paging can be implemented in one of two ways:
- Default Paging – can be implemented by simply checking the Enable Paging option in the data Web control’’s smart tag? however, whenever viewing a page of data, the ObjectDataSource retrieves all of the records, even though only a subset of them are displayed in the page
- Custom Paging – improves the performance of default paging by retrieving only those records from the database that need to be displayed for the particular page of data requested by the user? however, custom paging involves a bit more effort to implement than default paging
Read more
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
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