Developing ASP.NET MVC Web Applications — Question 47

You are designing a data-oriented application that features a variety of storage schemas.
The application object model must be mapped to the various storage schemas.
You need to enable developers to manipulate the data.
Which ADO.NET data access strategy should you use? (Each correct answer presents a complete solution. Choose all that apply.)

Answer options

• A. LINQ to SQL
• B. Entity Framework
• C. DataAdapter
• D. DataReader

Correct answer: A, B, C

Explanation

LINQ to SQL and Entity Framework are both ORM strategies that facilitate mapping application models to database schemas, making them ideal for this scenario. DataAdapter is also a viable option as it enables data manipulation through data sets. DataReader, however, is primarily for reading data in a forward-only manner and does not support manipulation, making it unsuitable here.