You are designing a SharePoint 2010 Internet site for e-commerce. The site shows pricing
information retrieved from a Microsoft SQL Server database for the deals featured each day
on the home page. You need to cache the pricing data for each featured deal on the server
and refresh the data with a minimum amount of network traffic. Which approach should you
recommend?
A.
Cache the data and use a lock to control the refresh of the cache data.
B.
Use the server session state to cache the data.
C.
Use LINQ to SharePoint from a query of the database server for the pricing data.
D.
Use AJAX code on the client from the database server.