Use DataSet over DataTable

[Michael]

Is there ever any reason to use a DataSet over a DataTable, if I will only
be working with one sql server table throughout my system?

Thanks,
--Michael

 

[William Ryan]

It really depends on your needs...but the first thing that comes to mind is
a request a month from now that involves another table. Then you'd have to
create a dataset, change your logic etc. Either way you'd have some coding
to do, but things tend to grow...

Another thing is that Datasets allow you to write them to XML with their
respective diffgram in place...so if your connection fails and you can't
update a record (or anything else that stops you from updating) you could
write things to XML and pull them back in at a later time.

However, if you are definitely only ever going to work with one table, and
you don't need any failover support, AFAIK, you shouldn't have any issues.