Choosing Your Path

Strongly typed DataSet objects can help you build your application more quickly. They can also help you write efficient code more easily. But they don’t offer the best possible performance. You can build an application that will run faster if you use untyped DataSet objects along with intelligent code.

If you decide to use strongly typed DataSets, TableAdapters can simplify the process of retrieving data and submitting pending changes. While TableAdapters hide some of the complexity of SqlDataAdapters, they also hide some of the functionality you might want to access directly.

So what’s the right choice for you?

It all depends on the needs of your application. If performance and control of your application are the absolute highest ...

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.