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

This article mainly explains "what are the shortcomings of ADO". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what are the shortcomings of ADO.

ADO disadvantages of parameterized query

When it comes to programming, each method has its advantages and disadvantages, and the decision to apply parameterized queries is no exception. One of its main disadvantages is that because the query is embedded in the application code, it may end up with the same query in several places. I can establish a central location for storing queries to eliminate this duplication. This location can be an XML file, a class with public static string members in the application, a custom .NET property, or an empty file. By applying these techniques, you can find the query you need before execution.

Another potential problem with applying 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 mean special (inline) code, not parameterized queries. Such rules also give DBA more control over code execution on SQL servers, which is a disadvantage of ADO, which is good for large databases.

When should I use a parameterized query?

You can apply parameterized queries in any case where you need to perform operations on the SQL server. However, parameterized queries are mainly applied to create, read, update, and delete (CRUD) operations that need to be performed. If you are performing a complex operation that takes a long time or consists of different SQL statements, * keep this operation on the SQL server.

Although parameterized query is convenient to use in many cases, because it can disrupt your application code, I do not recommend you to apply it in complex data manipulation logic. When your application code is disrupted, you are bound to encounter serious code maintenance problems.

In many cases of writing data access programs, the disadvantage of ADO is that parameterized processes are a better choice than special queries and stored procedures. Parameterized query is between the other two choices, and if applied properly, it can significantly improve the efficiency of development.

At this point, I believe you have a deeper understanding of "what are the shortcomings of ADO?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.