MSDN Magazine: ADO / ADO.NET
All MSDN Magazine Topics
Under the Table: How Data Access Code Affects Database Performance
Bob Beauchemin - August 2009
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More
Scott Mitchell - July 2009
If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.
Entity Framework: Anti-Patterns To Avoid In N-Tier Applications
Daniel Simmons - June 2009
Danny Simmons explores some anti-patterns you should look out for when building n-tier applications with the Entity Framework.
Extreme ASP.NET: The Life And Times of an ASP.NET MVC Controller
Scott Allen - May 2009
Here the author dissects the ASP.NET MVC framework and looks at how controllers work. He then explains how the framework interacts with your controllers and how you can influence those interactions.
Sync Up: Manage Your Data Effectively With The Microsoft Sync Framework
James Yip - April 2009
Synchronization Services for ADO.NET provide a set of tools to help you synchronize data between two database sources, synchronize files between machines, and synchronize with an RSS or ATOM feed. Learn more here.
Toolbox: Microsoft Chart Controls, Visual Studio Automatic Code Snippets, And More
Scott Mitchell - April 2009
In this installment we look at the Microsoft Chart Controls; Snippet Designer, a free, add-in for Visual Studio 2008 for creating and editing Code Snippets; refactoring SQL applications; and this month’s favorite blog.
Data Points: Using Silverlight 2 With ADO.NET Data Services
John Papa - April 2009
ADO.NET Data Services and Silverlight make a powerful combination, but to make them work well together, there are a few things you need to understand. Here, John Papa explains.
SOA Data Access: Flexible Data Access With LINQ To SQL And The Entity Framework
Anthony Sneed - December 2008
Building a data access layer using LINQ to SQL and the ADO.NET Entity Framework allows you to decouple your application from the persistence technology you're using.
Data Services: Create Data-Centric Web Applications With Silverlight 2
Shawn Wildermuth - September 2008
ADO.NET Data Services provide Web-accessible endpoints that allow you to filter, sort, shape, and page data without having to build that functionality yourself.
Data Points: Service-Driven Apps With Silverlight 2 And WCF
John Papa - September 2008
Here John Papa demonstrates how to build a Silverlight 2 user interface that communicates through WCF to interact with business entities and a database.
Data 2.0: Expose And Consume Data in A Web Services World
Elisa Flasko and Mike Flasko - August 2008
The goal of the ADO.NET Data Services Framework is to create a simple REST-based framework for exposing and consuming data-centric services easily.
ADO.NET: Achieve Flexible Data Modeling with the Entity Framework
Elisa Flasko - July 2008
Here the author answers questions regarding the Entity Framework and provides an understanding of how and why it was developed.
Data Points: The Entity Framework in Layered Architectures
John Papa - July 2008
Here we build a solution that fits the Entity Framework into an n-tier architecture that uses WCF and WPF and the MVP pattern.
Data Points: Entity Framework Q&A
John Papa - May 2008
The Entity Framework is a hot topic, but how do you know when to use EntityClient, Object Services, Entity SQL, or LINQ? Find out here.
Test Run: Testing SQL Stored Procedures Using LINQ
Dr. James McCaffrey - April 2008
Language Integrated Query makes lots of things easier. Here we put LINQ, or more specifically the LINQ to SQL provider, to use testing SQL stored procedures.
Data Points: Standard Query Operators with LINQ
John Papa - March 2008
LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.
Data Points: Accessing Data from a Mobile Application
John Papa - January 2008
This month John Papa takes a look at developing a mobile application that can access data on your application server.
Data Points: ADO.NET Entity Framework Overview
John Papa - July 2007
The new Entity Framework in ADO.NET will let you manipulate data using an object model. John Papa explains.
Data Points: SQL Server Management Objects
John Papa - June 2007
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
Data Points: Data Bound Applications with ADO.NET and Custom Objects
John Papa - February 2007
In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.
Data Points: Column Expressions, DataRelations, and Computations
John Papa - January 2007
This month John Papa fields some of his favorite questions regarding data manipulation with ADO.NET.
Enterprise Library: Take Exception To Critical Errors With Custom Application Blocks
Jay Hilyard - September 2006
Enterprise Library is a collection of application functionality blocks that you can re-use in your application for common functionality you'd otherwise have to write again and again. Here Jay Hilyard explains how to use them.
Data Points: SqlConnectionStringBuilder, DataView, and More
John Papa - January 2006
Several significant enhancements have been made to ADO. NET 2. 0 in the areas of improved performance, increased flexibility, and added features. In my last column (Data Points: DataSet and DataTable in ADO.
Data Points: DataSet and DataTable in ADO.NET 2.0
John Papa - November 2005
ADO. NET 2. 0 sports some exciting enhancements to the core classes found in ADO. NET 1. x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency.
Data Points: The Enterprise Library Data Access Application Block, Part 3
John Papa - October 2005
E nterprise applications can have a wide variety of data update requirements. Sometimes you need to save multiple rows of changes at once within a single transaction. Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.
Wicked Code: Asynchronous Pages in ASP.NET 2.0
Jeff Prosise - October 2005
ASP.NET 2.0 is replete with new features ranging from declarative data binding and Master Pages to membership and role management services. But my vote for the coolest new feature goes to asynchronous pages, and here's why.
Data Points: The Enterprise Library Data Access Application Block, Part 2
John Papa - August 2005
Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).
Cutting Edge: DataSets vs. Collections
Dino Esposito - August 2005
In software, five years is like a geological era. Five years ago, the Microsoft® . NET Framework had just been announced. Since then, the DataSet has emerged as the key object for performing a variety of data-related tasks in .
Data Points: The Enterprise Library Data Access Application Block, Part 1
John Papa - July 2005
A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.
Know Thy Code: Simplify Data Layer Unit Testing using Enterprise Services
Roy Osherove - June 2005
If you want to employ unit testing and test-driven development techniques in your database application development process, you'll have different factors to consider than you do when you're not involving a database. For example, you have to maintain a consistent state within the database and be able to roll back transactions when necessary. This article shows you how to get the best of unit testing for your database apps in a safe, usable manner.
Mine Your Business: AMO Lets You Dig Deeper into Your Data from Your Own Applications
Liu Tang and Paul Bradley - June 2005
Analysis Management Objects (AMO) for SQL Server 2005 facilitates client-side custom programming as Decision Support Objects (DSO), the object model in SQL Server 2000 Analysis Services. With AMO, a whole range of data mining questions can be answered at the operational level. This means that sales and marketing departments get answers more quickly and thus can make informed decisions.
Cutting Edge: Collections and Data Binding
Dino Esposito - May 2005
When it's time to design the Data Access Layer (DAL) of your distributed Microsoft® . NET Framework-based app, one of the key decisions you'll make is how you'll pass data to and from methods of DAL classes.
Data Points: Data Access Strategies Using ADO.NET and SQL
John Papa - May 2005
When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy. You can't just do some testing on your production machines and rely on the results.
Extreme ASP.NET: A Little Bit of Control for Your Controls
Rob Howard - May 2005
Having worked for so many years designing and developing ASP. NET while at Microsoft, it's exciting now to have a venue in which to talk about it. In this new column, Extreme ASP. NET, I'll discuss and demonstrate time-tested techniques and approaches to implementing high-performance, reliable, secure, and user-friendly Web applications with ASP.
Flex Your Data: Teach Old Data New Tricks with the Fully Loaded Advances in ADO.NET 2.0
Julia Lerman - April 2005
ADO.NET 2.0 will streamline your data access development efforts. Its new features let you work better with XML and SQL Server, and they offer lots of other improvements as well. This article takes a detailed look at some of the more interesting enhancements and focuses on performance and flexibility.
Web Q&A: Data Integrity Over HTTP, IIS Credentials, DataGrids, and More
Edited by Nancy Michell - March 2005
Test Run: Automate Your ASP.NET Web Services Testing
James McCaffrey - March 2005
It's no exaggeration to say that Web services are revolutionizing application-to-application communication. Web services are already being used extensively in corporate intranet environments and are making their way into commercial use, too.
Office: Relive the Moment by Searching Your IM Logs with Custom Research Services
John R. Durant - February 2005
Often, IM conversations contain important information you'd like to keep and reuse. Fortunately, MSN Messenger 6.2 has a feature to keep a conversation history permanently in XML format. This article shows you how to leverage that conversation history by consolidating IM exchanges so they are indexed, searchable, and ultimately reusable using the Microsoft Office 2003 Research and Reference task pane.
Data Points: ADO.NET and System.Transactions
John Papa - February 2005
The Microsoft® . NET Framework versions 1. 0 and 1. 1 represented major changes in software development. However, one important thing that did not change much was support for distributed transactions.
ASP.NET: 10 Tips for Writing High-Performance Web Applications
Rob Howard - January 2005
Writing a Web application with ASP.NET is unbelievably easy. So many developers don't take the time to structure their applications for great performance. In this article, the author presents 10 tips for writing high-performance Web apps. The discussion is not limited to ASP.NET applications because they are just one subset of Web applications.
Web Q&A: Caching and Expiration, Connection Pools, and More
Edited by Nancy Michell - January 2005
Data Points: Efficient Coding With Strongly Typed DataSets
John Papa - December 2004
Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.
Web Q&A: ADO.NET Joins, HTML to XHTML, ASP.NET ViewState, and More
Edited by Nancy Michell - November 2004
Web Q&A: Refreshing Web Pages, Spyware, Group Policy, and More
Edited by Nancy Michell - October 2004
Data Points: Handling Data Concurrency Using ADO.NET, Part 2
John Papa - October 2004
Enterprise development has been moving towards a discon-nected model in recent years and ADO. NET development is no exception. While the disconnected model of the ADO. NET DataSet offers great flexibility, that adaptability also means looser control over data updates than you get with a connected data access model.
Data Security: Stop SQL Injection Attacks Before They Stop You
Paul Litwin - September 2004
To execute a SQL injection attack, a hacker writes a Web page that captures text in a textbox to be used to execute a query against a database. The hacker enters a malformed SQL statement into the textbox that causes the back-end database to perform operations the owners did not intend it to perform, like making unauthorized updates. This article explains how you can protect against the all too common SQL injection attack in your own database. The steps covered include data validation, proper exception handing, and much more.
Web Q&A: Caching Transforms, Connection Sharing, and More
Edited by Nancy Michell - September 2004
Data Points: Handling Data Concurrency Using ADO.NET
John Papa - September 2004
One of the key features of the ADO. NET DataSet is that it can be a self-contained and disconnected data store. It can contain the schema and data from several rowsets in DataTable objects as well as information about how to relate the DataTable objects—all in memory.
Data Points: Migrating from ADO to ADO.NET, Part 2
John Papa - August 2004
As you move forward with your use of ADO. NET, you'll need to know how to approach situations that you previously learned to handle in ADO and now have to tackle with ADO. NET. Just as n-tiered solutions developed using Visual Basic®, C++, and ASP often rely on ADO for their data access needs, Windows® Forms, Web Forms, and Web services rely on ADO.
Web Q&A: Pop-Ups, Encrypting an ADO.NET Data Stream, and More
Edited by Nancy Michell - July 2004
Data Points: Migrating from ADO to ADO.NET
John Papa - July 2004
In recent years ADO has taken the lead as the preferred method for implementing data access in Windows®-based applications. Huge numbers of ADO applications are in use today and many developers are well versed in ADO development.
Cutting Edge: Implement Custom Cache Dependencies in ASP.NET 1.x
Dino Esposito - July 2004
One of the most compelling improvements that ASP. NET brought to ASP programming was the Cache object. The Cache has some similarities to the Application object and is a container of global data (as opposed to session-specific data) that features a fair number of innovative characteristics.
Data Points: Contrasting the ADO.NET DataReader and DataSet
John Papa - June 2004
Web Q&A: Request Timeouts, Byte Array Conversion, and More
Edited by Nancy Michell - May 2004
Data Points: Saving Parent-child Data in a Multitiered App Using ADO.NET
John Papa - May 2004
Web Q&A: JScript Leaks, Getting the XmlDataDocument, and ASPX Includes
Edited by Nancy Michell - April 2004
Web Q&A: Virtual Directories, Releasing DB Connections, and More
Edited by Nancy Michell - December 2003
Advanced Basics: Windows Forms Q&A
Ken Spencer - December 2003
Web Q&A: Schema From a DataSet, Exporting SQL Data to Excel, and More
Edited by Nancy Michell - October 2003
Data Points: Exploring the ADO.NET DataRow
John Papa - October 2003
Data Points: Developing Apps with the .NET Compact Framework, SQL Server CE, and Replication
John Papa - September 2003
ASP.NET: Jump Start Your Web Site Development with the ASP.NET Starter Kits
Paul Litwin - August 2003
If you're building an ASP.NET Web site you could probably use a good, solid code foundation to start with and build upon. Wouldn't it be nice to start with a complete site, make a few tweaks and customizations, and go live? The ASP.NET Starter Kits are packaged solutions that let you do just that. The five kits—Community, Reports, Commerce, Portal, and Time Tracker—supply full, reusable code that can be easily customized. In addition, there are a number of ISPs that support automatic deployment of ASP.NET Starter Kit Web sites, leaving you with little left to do when you have to get there fast. Here, the author introduces the ASP.NET Starter Kits and builds a community Web site with lots of advanced features such as ratings, user polls, upload quotas, change notifications, and themes.
DataGrid: Tailor Your DataGrid Apps Using Table Style and Custom Column Style Objects
Kristy Saunders - August 2003
One of the most enduring challenges in writing user interfaces is figuring out how to display large amounts of data efficiently and intuitively without bewildering the user. The problem becomes particularly thorny when the interface must reflect hierarchical relationships within the data that the user needs to modify. The Windows Forms DataGrid control gives developers a powerful and flexible tool to meet this challenge. This article explains its basic operations and shows how to extend the DataGrid to display columns of data in an application-appropriate manner.
Data Points: Managing Hierarchical Inserts in ASP.NET and ADO.NET
John Papa - July 2003
Data Points: Managing Hierarchical Inserts in ASP.NET and ADO.NET
John Papa - July 2003
Data Points: Techniques in Filling ADO.NET DataTables: Performing Your Own Analysis
John Papa - June 2003
How do you know which technique is best for retrieving data and populating a DataSet in ADO.NET?. Since the Microsoft .NET Framework offers so many choices on how to write the code, many developers are now taking a close look at the different options. See what they are.
Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000
Alok Mehta and Ricardo Rodriguez - May 2003
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
ADO.NET: Tackle Data Concurrency Exceptions Using the DataSet Object
David Burgett - April 2003
ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. This article examines the common causes behind data concurrency exceptions and presents techniques for overcoming them.
Data Access: Implement a Data Access Layer for Your App with ADO.NET
Dan Fox - April 2003
Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelines, and carefully examining your needs before deciding on a presentation method and external interface.
The XML Files: Web Services and DataSets
Aaron Skonnard - April 2003
Programmers using Visual Basic® 6. 0 have long bowed to the altar of the ADO recordset. It's probably the most commonly used data structure in Windows®-based applications today. The ADO. NET DataSet is poised to play a similar role in the realm of managed Windows-based applications.
Wicked Code: Supporting Database Cache Dependencies in ASP.NET
Jeff Prosise - April 2003
Developers love the ASP. NET application cache. One reason they love it is that ASP. NET lets them create dependencies between items placed in the cache and files in the file system. If a file targeted by a dependency changes, ASP.
Data Points: Expressions in ADO.NET
John Papa - January 2003
Managing relations in a database became a whole lot easier with ADO. NET. Instead of returning a single rowset to a data store, you can return a series of rowsets and relate them within a DataSet. There are numerous advantages to using related DataTables in ADO.
Web Farms: Use Data Caching Techniques to Boost Performance and Ensure Synchronization
David Burgett - December 2002
Performance is an important concern for any application, but becomes critical when the app is a Web Service accessed by thousands of clients simultaneously. One hardware approach to distributing Web Services requests evenly is a Web farm consisting of multiple servers. Once on a Web farm, Web Service performance can be improved by using ADO.NET DataSet objects to cache frequently accessed data, reducing round-trips to the database. Here the author describes data caching in a Web farm environment and discusses how to avoid the cross-server synchronization problems inherent in this approach.
Cutting Edge: Binary Serialization of ADO.NET Objects
Dino Esposito - December 2002
One of the key elements that makes ADO. NET superior to ADO is the level of integration with XML. In ADO, XML is just an I/O format. In addition, the ADO XML format is totally inflexible and doesn't allow any type of customization.
Data Points: DataRelations in ADO.NET
John Papa - November 2002
One of the biggest differences between traditional ADO and ADO. NET is that the rowsets stored within ADO. NET can be truly relational. For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders.
Spider in .NET: Crawl Web Sites and Catalog Info to Any Data Store with ADO.NET and Visual Basic .NET
Mark Gerlach - October 2002
Visual Basic .NET comes loaded with features not available in previous versions, including a new threading model, custom class creation, and data streaming. Learn how to take advantage of these features with an application that is designed to extract information from Web pages for indexing purposes. This article also discusses basic database access, file I/O, extending classes for objects, and the use of opacity and transparency in forms.
Commerce with ASP.NET: Leverage the Authentication and Form Validation Features of ASP.NET to Bolster Your Commerce App
Jason Lefebvre and Robert Lair - August 2002
If you're planning to build an e-commerce site, you'll be pleased to see that ASP.NET makes it easier than ever. Existing controls can be used and extended to add a great deal more functionality than you might expect. In this article, forms-based authentication is used to verify the identity of users and make certain areas of the site, such as the check-out page, inaccessible to unauthorized users. The power and flexibility of validation controls are demonstrated using the CustomValidator control to connect to a Web Service that verifies addresses. A shopping cart is then implemented in ASP.NET using the DataGrid, and finally, credit card authorization and billing are performed.
.NET Reflection: Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection
Atif Aziz - August 2002
One major inconvenience of using SQL stored procedures from code is having to match type information. You have to write long wrapper functions around the procedures just to expose the data types. In the .NET Framework, however, the reflection services of the System.Reflection namespace allow you to query rich metadata that describe data types. This article explains how to use reflection in .NET to end your stored procedure nightmares. The author creates four custom classes, including one that generates a SQLCommand object based on the metadata of a method. Using this library, you'll be on your way to automating the generation of stored procedures.
Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT
Roy Margolis - July 2002
One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.
Advanced Basics: Viewing the Values of a DataSet in a Debug Window
Ken Spencer - July 2002
SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000
Christian Thilmany - May 2002
XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.
The XML Files: XSLT Processing, Processing Instructions in XML, Parameterizing Statements in XML, and More
Aaron Skonnard - May 2002
Cutting Edge: ASP.NET Data Shaping
Dino Esposito - March 2002
The XML Files: Publishing and Discovering Web Services with DISCO and UDDI
Aaron Skonnard - February 2002
Data Points: Establishing Relationships Between Rowsets with ADO.NET
John Papa - February 2002
Data Points: Using the ADO.NET DataSet for Multitiered Apps
John Papa - January 2002
Advanced Basics: Namespaces, Cursors, ADO.NET, Web Services, Inheritance, and More
Ken Spencer - January 2002
ADO.NET: Building a Custom Data Provider for Use with the .NET Data Access Framework
Bob Beauchemin - December 2001
The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers.
Cutting Edge: Using Session and Application Objects in ASP.NET, Part 2
Dino Esposito - December 2001
Data Points: Abstracting ADO.NET
John Papa - November 2001
ASP.NET: Collect Customer Order Information on an Internet Site Using XML and Web Forms
Jeff Jorczak - September 2001
XML has quickly become the new data structure standard for everything from database access to cross-platform computing. XML is typically considered to be a vehicle for data exchange, dynamic data presentation, and data storage. However, the potential of XML far surpasses those limited applications. This article examines one new use: the gathering of data across a number of forms in an ASP.NET Beta 1 framework application. The sample program is a Web app used for ordering pizza. It uses ASP and C# to gather order information and then stores it in XML. To build the application, several concepts are explained, including data collection, order persistence using cookies, grouping input forms, and formatting the data for display.
Data Points: ADO to XML: Building a Data Access Tier with the DataManager Component
John Papa - August 2001
Data Points: Revisiting the Ad-Hoc Data Display Web Application
John Papa - June 2001
Cutting Edge: DataGrid In-place Editing
Dino Esposito - June 2001
Cutting Edge: Server-side ASP.NET Data Binding
Dino Esposito - March 2001
Introducing ADO+: Data Access Services for the Microsoft .NET Framework
Omri Gazitt - November 2000
ADO+ is the new set of data access services for the .NET Framework. ADO+ is a natural evolution of ADO, built around n-tier development and architected with XML at its core. This article presents the design motivations behind ADO+, as well as a brief introduction to the various classes in the two layers that comprise the ADO+ framework-the connected Managed Providers and the disconnected DataSet. A drilldown into DataSets that covers populating data stores, relationships, filtering, searching and data views is provided. Finally, a discussion of the integration of ADO+ with the .NET XML Framework is presented.
Taming the Stateless Beast: Managing Session State Across Servers on a Web Farm
John Papa - October 2000
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.
Serving the Web: XML Data Manipulation with ADO 2.5
Ken Spencer - August 2000
House of COM: Using ADO to Create XML-based Recordsets
Don Box - July 2000
Advanced Basics: Transactional Programming Design and Optimization
Jason Masterman - June 2000
B2B Frontiers in E-Commerce: Implement Affiliate Programs to Create New Partnerships and Generate Business
Ted Coombs - May 2000
Like the Internet itself, e-commerce is evolving. Today's e-commerce companies are allowing their customers to plug into existing catalogs and ordering systems, creating new synergistic relationships. Some companies are even adding real-time chat with customer service personnel. This article gives you an overview of some of the new e-commerce concepts and implementations that are helping forge those new relationships with customers, vendors, and shipping companies. The importance of these relationships, as well as the specific technologies used to encourage communication and collaboration are discussed and illustrated with representative code samples.
Serving the Web: Building and Testing ADO Components with Visual Basic
Ken Spencer - May 2000
Cutting Edge: Accessing Recordsets over the Internet
Dino Esposito - March 2000