Is there a way to get the "recursive" results from a DataSet object in C# without having to call multiple queries?
I am trying to get a DataSet to act like Entity since, at this point, I cannot use Entity framework.
I have 2 tables in a database that are not linked with foreign keys. When I add them to my dataset designer, I make the link there.
When I run a query on the first table, I would like it to also return all results from the second table without having to run separate queries for the second table.
Is this possible? The issue I am having is, I have a DB with no foreign keys and I cannot change it in any way to use Entity.
See my other question related to this one: http://www.experts-exchange.com/Programming/Languages/.NET/Q_28157518.html