Hello,

I have a BO (my first, yea!) that grabs the data I'm looking for and all is well in the universe.

Now, I have a requirement to combine data from multiple data sources (same table structure, but the data is living on different SQL Servers) and I'm figuring a UNION would give me what I need.  This is a read-only scenario, so I don't need to worry about updates being sent back to the different servers (yet).

I have not gone through the process of adding additional data sources to my project yet, but I will review the documentation on how to set that up. After that, I guess the trick is how to select data from different servers into the BO dataset...

Any suggestions?

Thanks.

Yes, the chained linked servers has me stumped too.

The CopyDataFrom BO approach works, so I'll move in that direction for now.

Thank you.

The logic behind the SF Business Object is pretty cool.  I have been able to do some complex routine with data manipulation using all available methods of the SF Business Object including the AcceptChanges, Sort, Filter and of course the bo.GetEnumerable().

In your case you can probably build a Stored Procedure to get the data from different sources and use the BusinessLayer.FillMultipleDataTable() to get all the data at once.

Edhy Rijo