Your application connects to a Microsoft SQL Server 2008 database. You use the following query to return a SqlDataReader:

SELECT MediaFile.PathName(), GET_FILESTREAM_TRANSACTION_CONTEXT()
FROM Media WHERE MediaId = @MediaId

The column named MediaFile is a FILESTREAM column. You need to retrieve the contents of the file referenced by this column.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 2433 | Points: 40
Select from following answers:
  1. Use a SqlFileStream to read the data returned by GET_FILESTREAM_TRANSACTION_CONTEXT().
  2. Save the value of the first column to a local media file.
  3. Use the value of the first column to open a stream and write this stream to a local media file.
  4. All Above

Show Correct Answer


Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response