You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the number of pools to a minimum.
Which code segment should you use?
A.
command.CommandText = “USE [pubs]; exec uspLoginAudit;”;
using (SqlConnection connection = new SqlConnection( “Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True”)) {
connection.Open();
command.ExecuteNonQuery();
}
B.
command.CommandText = “exec uspLoginAudit;”;
using (SqlConnection connection = new SqlConnection( “Integrated Security=SSPI;”)) {
connection.Open();
command.ExecuteNonQuery();
}
C.
command.CommandText = “USE [pubs]; exec uspLoginAudit;”;
using (SqlConnection connection = new SqlConnection( “Integrated Security=SSPI; Initial Catalog=AdventureWorks”)) {
connection.Open();
command.ExecuteNonQuery();
}
D.
command.CommandText = “exec uspLoginAudit;”;
using (SqlConnection connection = new SqlConnection( “Integrated Security=SSPI; Initial Catalog=pubs”)) {
connection.Open();
command.ExecuteNonQuery();
}
Explanation:
Working with Multiple Active Result Sets
(http://msdn.microsoft.com/en-us/library/yf1a7f4f(v=vs.80).aspx)SSPI
(http://msdn.microsoft.com/en-us/library/windows/desktop/aa380493(v=vs.85).aspx)