Search Results for "sql query"

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