I dunno ... we seem to be ok with it. We are accessing our SQL Server only through SP's, so as far as the Command Builder goes, we're not using it ... we roll our own ... and it's not that difficult. Look into it. I think limiting DataSets to only one table is *not* the way to go. I am also a big advocate of using typed DataSets.
~~Bonnie
>>We have DataSets that contain many tables (a parent and many children).
>
>I had heard to specifically stay away from that model and limit datasets to one table - I believe primarily because of diffculty with data adapter or perhaps the command builder?