You create Web-based client applications. You are designing a new Web site for your company. You need to evaluate the design concept for the main page, default.aspx. The default.aspx page contains static information, except for one data grid that displays information about the companys products. The data grid will retrieve the data from a component. The component will retrieve the data from a stored procedure. The page has the appropriate permissions to the Microsoft SQL Server database.
The application design must achieve the following goals without altering the data component:
The default.aspx page must load quickly.
The default.aspx page must contain the latest data from the database.
You decide to use a sqlCacheDependency attribute to ensure that the default.aspx page always displays the latest data in the grid. You need to ascertain whether the use of the sqlCacheDependency attribute meets the requirements of this application. Which rationale should you choose?
A.
The use of the sqlCacheDependency attribute is not feasible. The sqlCacheDependency attribute must be used in the component and not on the page.
B.
The use of the sqlCacheDependency attribute is not feasible. The sqlCacheDependency attribute cannot be used with a stored procedure.
C.
The use of the sqlCacheDependency attribute is feasible. The sqlCacheDependency attribute can be used by including a sqlDependency attribute in the @OutputCache directive of the page.
D.
The use of the sqlCacheDependency attribute is feasible. The sqlCacheDependency attribute can be linked to the data component that is used on the page.