For the integration of data there are many techniques of using SQLXML and .net the sql client data provider supports execute xml reader it can consume directly the result of it to do the xml query the user can use xml directly, the role of XML query in reinventing the wheel is very large the overlap between the xquery and xslt is too great for W3C to recommend both as separate languages if the XSLT is not considered enough as an XML query language then its development should be built from the same and semantic syntactic base as XSLTThe most
There are many techniques of using SQLXML and .NET for data integration let us have glance at all those ways in a nutshell the sql client data provider supports Execute xml reader it can consume directly the result of it in order to do the xml query the xml reader might be used directly. In order to serialize the resulting document to a stream for transmission to a biz talk server. The document can be serialized to disk by using an xml text reader. And this can be read directly into the data set.Certain precautions should be taken before
"The SqlClient data provider supports ExecuteXmlReader, a provider-specific method on the SqlCommand class. Rather than provide a SqlDataReader to process the result of a SQL query, ExecuteXmlReader produces an XmlReader, which can be used to directly consume the results of a SELECT ... FOR XML query. The XmlReader might be used directly—for example, to serialize the resulting document to a Stream for transmission to a BizTalk server. The document could be serialized to disk by using an XmlTextReader. It could be read directly into the DataSet by
RSS/XML