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

This article introduces the relevant knowledge of "what are the skills for using ADO.NET". In the operation of actual cases, many people will encounter such a dilemma. Next, 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!

After opening the connection, the ADO.NET trick causes the local OLE DB to call IDBProperties.GetProperties to the DATASOURCEINFO property set to get the DBPROP_CONNECTIONSTATUS property, which may cause the data source to be returned. In other words, checking the State property can be expensive.

Integrate with XML

ADO.NET provides extensive XML integration in the dataset and exposes some of the XML capabilities provided by SQL Server 2000 and above. You can use SQLXML 3.0 to access the XML features provided by SQL Server 2000 and above. Here are some and information about using XML and ADO.NET techniques.

Datasets are tightly integrated with XML datasets and XML, providing the ability to load the outline or relational structure of the dataset from the XSD outline and the contents of the dataset from the XML.

When no outline is provided, the outline of the dataset is inferred from the contents of the XML document, and the outline of the dataset is written as an XSD outline. Write the contents of the dataset as XML. ADO.NET techniques use datasets to synchronize the performance of accessing data, and hierarchical performance of accessing data using XmlDataDocument.

Note: you can use this synchronization to apply XML functions (such as Xpath queries and XSLT transformations) to the data in the dataset, or to provide all relational views, or to provide a subset of the data in the XML document while leaving the original XML unchanged.

Outline interface

When loading a dataset from a XML file, you can load the outline of the dataset from ADO.NET tips, or predefine tables and columns before loading the data. If there is no XSD outline, and you do not know what tables and columns are defined for the contents of the XML file, you can infer the outline from the structure of the XML document.

Outline reasoning is useful as a migration tool, but due to the following limitations in the reasoning process, ADO.NET techniques are limited to application design: the introduction of additional processing by the inference outline will degrade the application's performance. All inference columns are of string type.

The reasoning process is uncertain. That is to say, it is based on the XML file rather than the scheduled outline. The result is that you may have two XML files that have the same predetermined outline, but form two completely different reasoning outlines because of their different contents.

SQL Server for XML query service

If you return the results of ADO.NET tricks for XML queries, you can use the .NET Framework component SQL Server data provider to create a XmlReader directly using the SqlCommand.ExecuteXmlReader method.

This is the end of the content of "what are the skills for using ADO.NET". Thank you for your 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.