Your application connects to a Microsoft SQL Server 2008 database and executes the following query to return a DataReader:

SELECT ProductId, Photo FROM Products

The Photo column contains large binary bitmaps. You need to ensure that you can buffer the binary data and read the data as it is received and not a row at a time.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 960 | Points: 40
Select from following answers:
  1. Specify CommandBehavior.SequentialAccess.
  2. Use the BeginExecuteReader method.
  3. Specify CommandBehavior.SingleRow.
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response