You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.
You create a class that contains the following code segment. (Line numbers are included for reference only.)
01 Public Function GetCachedProducts(conn As sqlConnection) As Object
02
03 If Cache("products") Is Nothing Then
04 Dim cmd As New SqlCommand("SELECT * FROM Products", conn)
05 conn.Open()
06 Cache.Insert("products", GetData(cmd))
07 conn.Close()
08 End If
09 Return Cache("products")
10 End Function
11
12 Public Function GetData(prodCmd As SqlCommand) As Object
13
14 End Function
Each time a Web form has to access a list of products, the GetCachedProducts method is called to provide this list from the Cache object.
You need to ensure that the list of products is always available in the Cache object.
Which code segment should you insert at line 14?
A.
Return prodCmd.ExecuteReader()
Dim dr As SqlDataReader
prodCmd.CommandTimeout = Integer.MaxValue
B.
dr = prodCmd.ExecuteReader()
Return dr
C.
Dim da As New SqlDataAdapter()
da.SelectCommand = prodCmd
Dim ds As New DataSet()
Return ds.Tables(0)
D.
Dim da As New SqlDataAdapter(prodCmd)
Dim ds As New DataSet()
da.Fill(ds)
Return ds