8:You are creating a Windows application by using the .NET Framework 3.5. The application will be used to retrieve information about the technical skills of the employees. The data will be retrieved from the following related tables on a Microsoft SQL Server 2008 database instance by using LINQ to SQL:
* EmployeeSkills table
* TechnicalSkills table
The application must retrieve data from the TechnicalSkills table only when the correspondingEmployeeSkills rating value is 3. In addition, the application must
minimize data returned and prevent duplicate information from being returned.
You need to meet the outlined requirements in one roundtrip to the database.What should you do?
A.
Use a LINQ query to join EmployeeSkills data to TechnicalSkills data based on the skill rating level.
B.
Use a LINQ query along with a Where clause to select EmployeeSkills records only when the skills rating value is equal to 3.
C.
Set the DataContext. DeferredLoadingEnabled setting to False. Allow the records to be accessed by the caller on demand.
D.
Set the DataContext. DeferredLoadingEnabled setting to True. Use the DataContext.DataLoadOptions.AssociateWith method to associate
EmployeeSkills data with TechnicalSkills data based on the skill rating value.