What does EDM stand for in the context of ADO.NET?
- Entity Data Model
- Extended Data Model
- Entity Definition Model
- Entity Descriptor Model
The correct option is Entity Data Model. EDM (Entity Data Model) is an abstract conceptual representation of the data in a database. It provides a consistent and uniform way to access and manipulate data across various data sources.
What is the difference between a dataset and a data reader in ADO.NET?
- Dataset can only hold a single result set while a data reader can hold multiple result sets
- Dataset is forward-only and read-only while a data reader is updateable
- Dataset is optimized for performance while a data reader is optimized for memory usage
- Dataset provides disconnected access to data while a data reader provides connected access
The primary difference between a dataset and a data reader in ADO.NET is that a dataset provides disconnected access to data, meaning it retrieves and stores data in memory independently of the data source. On the other hand, a data reader provides connected access to data, requiring an active connection to the data source while reading data sequentially. This fundamental distinction impacts factors such as performance, memory usage, and flexibility in data manipulation.
What does LINQ stand for in C#?
- Language Integrated Query
- Link Integrated Query
- List Integrated Query
- Logical Integrated Query
LINQ stands for "Language Integrated Query". It allows developers to query various data sources using a syntax similar to SQL.