Which two actions should you perform?

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application uses LINQ to SQL to retrieve and modify data from a Microsoft SQL Server 2008 database.

Queries will be frequently executed in the application. However, concurrency validation is not required on the data.

You need to optimize the performance of the application.

Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application uses LINQ to SQL to retrieve and modify data from a Microsoft SQL Server 2008 database.

Queries will be frequently executed in the application. However, concurrency validation is not required on the data.

You need to optimize the performance of the application.

Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

A.
Execute compiled LINQ queries by using the CompiledQuery class.

B.
Ensure that the AttachAll method is invoked when updating the data.

C.
Set the ObjectTrackingEnabled property of the DataContext instance to false.

D.
Set the UpdateCheck property of the Column attributes on each LINQ data class to UpdateCheck.Never.



Leave a Reply 0

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