Disadvantages of using ADO and fixing problems

In the process of using ADO, we found many disadvantages of ADO. It is a very simple process to establish and execute parameterized queries. This process can be further simplified with the help of the data access library, such as Microsoft's Data Application Block.

650) This. width = 650; "src =" http: // 183.61.143.148/group1/m00/02/28/tz2plfqiicca70fhaab74ysiiqk755.png "/>

Ado disadvantage of parametric Query

When it comes to programming, each method has its own advantages and disadvantages, and it is no exception to deciding to apply parameterized queries. One of its major disadvantages is that the query may end with the same query in several places because it is embedded in the application code. I can create a central location for storage query to eliminate such duplication. This location can be an XML file, a class with public static string members in the application, a custom. Net attribute, or an empty file. With these skills, you can find the desired query before execution.

Experts explain how to use the ADO. Net Model
Detailed description of ADO access interface usage skills
How to Design the ADO code operation Solution
Introduction to the object description of the ADO. Net class library
About ADO. Net Parameters

Another potential problem with application parameterized queries is that many companies do not allow inline SQL in their applications (and data layers. I think this is because when people talk about inserting SQL into application code, they refer to special (Inline) code rather than parameterized queries. This rule also gives DBAs greater control over code execution on SQL servers. The disadvantage of ADO is very beneficial to large databases.

When should parameterized queries be used?

If you want to perform operations on the SQL server, you can apply parameterized queries. However, parameterized queries are mainly used for the creation, reading, updating, and deletion (crud) operations to be executed. If you want to perform complex operations that take a long time or make up of different SQL statements, it is best to keep this operation on the SQL server.

Although parametric query is very convenient to use in many cases, it may disrupt your application code, so I do not recommend that you apply it in complex data operation logic. When your application code is disrupted, you will inevitably encounter serious code maintenance problems.

In many cases of writing data access programs, compared with the special query and storage process, the parameterized process is a good choice. Parameterized query is between the other two options. if used properly, the development efficiency can be significantly improved. Learn moreProgramming Language tutorialAnd knowledge, please log on to e liangshi Yiyou network.

This article is from the blog, please be sure to keep this source http://yuguotianqing.blog.51cto.com/9292883/1558206

Disadvantages of using ADO and fixing problems