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 corresponding
EmployeeSkills 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.