Chapter 2. Consuming and Manipulating DataSets

Terms you'll need to understand:

  • Concurrency control

  • Primary key

  • Metadata

  • DataSet

  • Schema

  • XML attribute

  • XML element

Techniques you'll need to master:

  • Accessing and manipulating data from a Microsoft SQL Server database

  • Knowing how to work with a DataSet object

  • Knowing how to handle database-related errors in your code

  • Creating strongly typed DataSet objects, DataSet Schemas, and DataSet relationships

In this chapter, you learn how to use ADO.NET to access and manipulate data in relational databases such as Microsoft SQL Server. You also learn how to work with DataSet schemas and how to use a DataSet schema to instantiate a strongly typed DataSet object.

The ADO.NET Object Model

ADO.NET is the overall name for the ...

Get Developing XML Web Services and Server Components with Visual C# .NET and the .NET Framework, Exam Cram 2 (Exam 70-320) 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.

Start your free trial