You are implementing an application that must use a trusted connection to access data from a SQL Server database named NorthWind on a server called dataServer. You need to ensure that the application can have more than one pending request per connection, and, in particular, have more than one active default result set per connection

What should you do?

 Posted by Rajkatie on 8/30/2012 | Category: ADO.NET Interview questions | Views: 1051 | Points: 40
Select from following answers:
  1. Integrated Security=SSPI;database=northwind;server=dataServer;MultipleActiveResultSets=true
  2. Integrated Security=SSPI;database=northwind;server=dataServer;Max Pool Size=100
  3. Create the SqlConnection as a singleton.
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response