单项选择题
A. Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
B. Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
C. Run the two SqlDataReader objects by using a single SqlCommand object.
D. Enable Multiple Active Result Sets (MARS) in the connection string of the application.
单项选择题 You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The user name and password that is kept by the connection string is stored directly in the code of the application. You want to make sure that the password in the connection string is as protected. What should you do? ()
单项选择题 You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. The application uses an XML file that contains product data. Furthermore, a corresponding XSD file contains the schema of the XML file. You want the application to do the following: Loads the XML file in a typed DataSet and validates it against the schema provided in the XSD file. What should you do? ()
单项选择题 You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. The application fills a DataSet object named cust with customer records. Your application contains the following code. (Line numbers are for reference only.) 01 System.IO.StreamWriter sw = 02 new System.IO.StreamWriter("Customers.xml"); 04 sw.Close(); You want to write the content of the cust object to the Customers.xml file as XML data along with inline XML schema. What should you do?()