From everything I have read I stay away from TA's ( they are slow and just another layer ) and use the xxxDataAdapter class to load the table into a dataset object and access that object.

If you are loading read only data try using a SqlDataReader.