Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge of "how to configure ADO.NET file connections". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Use connection

High-performance applications maintain connections to data sources that use the least number of times, and take advantage of performance enhancement techniques similar to connection pooling. The following tips help you get better performance when using ADO.NET class files. Connection pooling SQL Server, OLE DB, and .NET Framework component data providers implicitly provide connection pooling for ODBC. You can specify different properties in the connection string to control the behavior of the connection pool.

Optimize connections with DataAdapter

The Fill and Update methods of the data adapter automatically open a specific connection (if it is closed) for the relevant command properties. If the ADO.NET class file or the Update method opens the connection, Fill or Update closes it when the operation is complete. To improve performance, keep database connections open only when necessary, while reducing the number of times connections are opened and closed for multiple operations.

We recommend that if you only perform a single Fill or Update method call, you should allow Fill or Update to implicitly open and close the connection. If there are a large number of calls to Fill or Update, we recommend that you explicitly open it, make Fill or Update calls, and then explicitly close the connection.

In addition, when performing a transaction, the ADO.NET class file explicitly opens the connection before starting the transaction and explicitly closes the connection after the transaction is completed. For example:

PublicSubRunSqlTransaction (daAsSqlDataAdapter, myConnectionAsSqlConnection,dsAsDataSet) myConnection.Open () DimmyTransAsSqlTransaction=myConnection.BeginTransaction () myCommand.Transaction=myTrans Try da.Update (ds) myTrans.Commit () Console.WriteLine ("Updatesuccessful.") CatcheAsException Try myTrans.Rollback () CatchexAsSqlException IfNotmyTrans.ConnectionIsNothingThen Console.WriteLine ("Anexceptionoftype" & ex.GetType (). ToString () & _ "wasencounteredwhileattemptingtorollbackthetransaction.") EndIf EndTry Console.WriteLine ("Anexceptionoftype" & e.GetType (). ToString () & "wasencountered." Console.WriteLine ("Updatefailed.") That's all for EndTry myConnection.Close () EndSub, "how to configure ADO.NET class file connections". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.