You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database.
The application uses the ADO.NET LINQ to SQL model to retrieve data from the database.
The application will not modify retrieved data. You need to ensure that all the requested data is retrieved.
You want to achieve this goal using the minimum amount of resources. What should you do?
A.
Set ObjectTrackingEnabled to true on the DataContext class.
B.
Set ObjectTrackingEnabled to false on the DataContext class.
C.
Set DeferredLoadingEnabled to true on the DataContext class.
D.
Set DeferredLoadingEnabled to false on the DataContext class.
Explanation:
Setting property ObjectTrackingEnabled to false improves performance at retrieval time, because there are fewer items to track.DataContext.ObjectTrackingEnabled Property
(http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.objecttrackingenabled.aspx)