Which of the following operations can you NOT perform on an ADO.NET DataSet?
-
A DataSet can be synchronised with the database.
-
A DataSet can be synchronised with a RecordSet.
-
A DataSet can be converted to XML.
-
You can infer the schema from a DataSet.
ADO.NET DataSets and classic ADO RecordSets are fundamentally different technologies that cannot be directly synchronized. DataSets are XML-based, disconnected data containers from .NET, while RecordSets are COM-based objects from classic ADO. You can sync DataSets with databases, convert them to XML, and infer schemas, but there's no direct DataSet-to-RecordSet synchronization mechanism.
An ADO.NET DataSet is a disconnected, in-memory cache of data — it can be filled from and reconciled back to a database (synchronized with the DB), converted to/from XML, and it supports schema inference (ReadXmlSchema/InferSchema). What it cannot do is synchronize with a classic ADO Recordset, because Recordset is a COM-era, connection-oriented object model that DataSet was designed to replace, not interoperate with directly. So 'synchronised with a RecordSet' is the operation you cannot perform.