Which strategy should you recommend?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance. The application requires certain changes in the relationships represented in the data.

However, any changes to the database schema can break existing applications that share the database instance. You need to recommend a strategy that allows the application to make the required relationship changes without affecting the underlying database schema. You also need to ensure that the strategy uses the minimum amount of development effort. Which strategy should you recommend?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The ASP.NET application connects to a shared Microsoft SQL Server 2008 database instance. The application requires certain changes in the relationships represented in the data.

However, any changes to the database schema can break existing applications that share the database instance. You need to recommend a strategy that allows the application to make the required relationship changes without affecting the underlying database schema. You also need to ensure that the strategy uses the minimum amount of development effort. Which strategy should you recommend?

A.
Generate a model by using LINQ to SQL. Make the relationship changes to the model.

B.
Generate an ADO.NET Entity Framework model. Make the relationship changes in the model.

C.
Add an HTTP endpoint to SQL Server 2008 database to retrieve the data from the database in tabular format.

D.
Create a DataSet object and add a DataTable object for each table in the database. Create a DataRelation object for each relationship required for the application.



Leave a Reply 0

Your email address will not be published. Required fields are marked *