IEnumerable Tricks 1 : DataTable and DataColumn

Tricks of TSQL type subqueries with IEnymerable extention methods OfType and Cast 

and using String function Join().

Simplify logic, to use sub queries in business layer's managed code your component

over Datatables  and datasets.