Chapter 3. Working with Strongly Typed DataSets
In This Chapter
Creating
DataSets in a class libraryUsing the DataSet Designer
Accessing data with
TableAdaptersDigging into the code of a typed
DataSetConsuming typed
DataSets
Programmers have always needed a way to work with data in their applications. Accessing data from files or databases every time you need data is impractical. To accommodate the need to have programs access data quickly, programmers store data in memory, using everything from arrays to integers to custom data structures.
Instead of making you spend lots of time thinking about how to store data in memory, Microsoft created the DataSet to provide a standardized means of storing data in memory for quick access.
A DataSet works like an in-memory database. The DataSet has tables with columns and rows, and you create relations between tables. You can load data into a DataSet from a database, or you can enter new data into the DataSet. You can insert, delete, and update records. After you make all the changes to records in your DataSet, you commit those changes to the actual database.
Visual Studio provides the DataSet Designer for creating and manipulating DataSets. This chapter explains what a DataSet is and shows you how to use the DataSet Designer to create a special kind of DataSet, the strongly typed DataSet.
Understanding the DataSet
A DataSet is a resource provided by the Microsoft .NET Framework for storing data in memory. DataSets store data in tables, and you can ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access