Dataset tools in Visual Studio

Dataset tools in Visual Studio


Datasets and related classes are legacy .NET technologies from the early 2000s that enable applications to work with data in memory while disconnected from the database. They are especially useful for applications that enable users to modify data and persist the changes back to the database. Although Datasets have proven to be a very successful technology, we recommend that new .NET applications use the Entity Framework. The Entity Framework provides a more natural way to work with tabular data as object models, and has a simpler programming interface.

A DataSet is an in-memory object that is essentially a mini-database. It contains DataTable, DataColumn and DataRow objects in which you can store and modify data from one or more databases without having to maintain an open connection. The dataset maintains information about changes to its data so updates can be tracked and sent back to the database when your application becomes reconnected.

DataSets and related classes are defined in the System.Data namespace in the .NET Framework class library. You can create and modify datasets dynamically in code; for more information about how to do that, see ADO.NET. The documentation in this section shows how to work with datasets with Visual Studio designers. One thing to know: Datasets made with designers use TableAdapters to interact with the database, whereas Datasets made programmatically use DataAdapters. For information against creating DataSets programmatically, see DataAdapters and DataReaders

If your application only needs to read data from a database, and not perform updates, adds, or deletes, then you can usually get better performance by using a DataReader to retrieve data into a generic List or other collection object. If you are displaying the data, you can data-bind the user interface to the collection.

Visual Studio provides a lot of tooling to simplify working with datasets. The basic end-to-end workflow is:


For information about datasets in N-Tier applications, see Working with datasets in N-tier applications

For information about converting datasets to and from XML, see Walkthrough: Reading XML data into a dataset and How to: Save a Dataset as XML.

© 2016 Microsoft