Your application executes the following query:

SELECT ProductId, Photo FROM Products

You retrieve the result set by calling DbCommand.ExecuteReader specifying CommandBehavior.SequentialAccess. You need to read column values and buffer the binary data in the Photo column.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 1123 | Points: 40
Select from following answers:
  1. Read the ProductId column before reading the Photo column.
  2. Read the Photo column before accessing the ProductId column.
  3. Read the columns using the SqlDataReader.GetSqlBinary method.
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response