You are creating a Windows application by using the .NET Framework 3.5.
The application creates lookup fields by using data from a database within the corporate network.
You use the DataAdapter object to retrieve data as a DataSet from the database.
You need to reduce the network bandwidth that is used by the application.
What should you do?
A.
Use a DataReader object instead of the DataAdapter object to retrieve data.
B.
Use a LINQ to SQL query to retrieve data. Defer loading the data until required.
C.
Create a local database cache in the application by using a Microsoft SQL Server 2008 Compact 3.5
database.
D.
Create a Windows Communication Foundation (WCF) service to return the data. Use the service from
the application.