Reading Data from Remote Sources at the Middle Tier
Let’s go back for a moment to using ADO.NET. To read data from remote sources from a middle-tier component, you need to open a Connection object to each of the different data sources that you want to communicate with and query each one of them independently for the data that you want to extract.
As Figure 8-1 shows, when taking this approach, the middle-tier code has to deal with querying each of the different data sources using each data source’s access API and merging the collected result sets into a single result set.
Figure 8-1. Architectural model for reading data from remote sources at the middle tier.
Reading Data from Remote Data Sources Using ADO.NET at the Middle Tier
Your middle-tier ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
