Related DataTables vs Linked Servers
I'm trying to build a report in an ASP.NET 2.0 application. I have 2 datasources that I am trying to combine (JOIN) to produce the rows for the report. One datasource is completely under my control in a local SQL Server 2005 database. The other is a ISAM data source accessed via a 3rd party ODBC driver over virtual connection. I have little or no control over this second source and am limited to read-only (not a problem for creating reports). Records in my SQL Server database may have a corresponding record in the ISAM database, and if so, I want to present columns from each in a homogenous report. So here's my question: is it better to use two DataTables, one for each datasource, and joined using a System.Data.DataRelation within ASP.NET, or better to use a linked server in SQL Server so that I can use a stored proc to perform a SQL JOIN on the data? I've tried a test using both and can't see much performance difference using WAS. I'm not very familiar with linked servers, so are there any pitfalls to look out for or obvious advantages with either approach?
Any help much appreciated.