多项选择题
You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）
A. Ensure that the Close method is called on each connection object after it has finished executing.
B. Ensure that each connection object is left open after it has finished executing.
C. Increase the Max Pool Size value inside the connection string.
D. Increase the Min Pool Size value inside the connection string.
E. Increase the Connection Lifetime value inside the connection string.
F. Increase the value of the ConnectionTimeout property of the SqlConnection object.
相关考题
-
单项选择题
You create a Web Form. The Web Form uses the FormView control to enable a user to edit a record in the database. When the user clicks the Update button on the FormView control, the application must validate that the user has entered data in all of the fields. You need to ensure that the Web Form does not update if the user has not entered data in all of the fields. Which code segment should you use? （）
A.protectedvoidFormView1_ItemUpdating（objectsender，FormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.Keys）{if（entry.Value.ToString（）==System.String.Empty）{e.Cancel=true；return；}}}
B.protectedvoidFormView1_ItemUpdated（objectsender，FormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.NewKeys）{if（entry.Value.Equals（“”））{e.KeepEditMode=true；return；}}}
C.protectedvoidFormView1_ItemUpdating（objectsender，FormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.NewValues）{if（entry.Value.Equals（“”））{e.Cancel=true；return；}}}
D.protectedvoidFormView1_ItemUpdating（objectsender，FormViewUpdateEventArgse）{foreach（DictionaryEntryentryine.Keys）{if（entry.Value.ToString（）==System.String.Empty）{e.KeepInEditMode=true；return；}}} -
单项选择题
You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader();You need to execute a method named Do Work() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use? （）
A.while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
B.while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
C.while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
D.while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）； -
单项选择题
You create an application. The application processes hundreds of XML documents per minute. The XML documents are validated against inline schemas. You need to load XML documents from the file system and read them as quickly as possible. XML comments must be ignored while reading the XML documents.What should you do? （）
A. Create an instance of the XmlReader class by using the XmlReader Create method with an instance of the XmlReaderSettings class.
B. Create an instance of the XmlReader class with an instance of the XmlTextReader class.
C. Create an instance of the XmlDocument class and specify a location for the application schema.
D. Create an instance of the XmlReader class with an instance of the XmlNodeReader class.
