how to save soap response in to the sql server database (sav

Question

how to save soap response in to the sql server database (save rendered xml that want to save in database) using C#

Ramesh Maruthi · Answer

You could use SOAP extension that store the SOAP request message into XML file, here is a MSDN sample about it, once you get the XML file then load it into XmlDocument and use XPATH to extract data from SOAP message. http://msdn.microsoft.com/en-us/library/system.web.services.protocols.soapextension.aspx http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/thread/3b3f3cae-713e-48e6-8576-d1e96a4fac79 Otherwise you can stylustudio for sql/xml http://www.stylusstudio.com/sqlxml_tutorial.html Otherway : you can generally store XML in a SQL Server table using normal CRUD procs. The example below uses an XmlDocument as the source but XML from any source may be used. CREATE TABLE dbo.XMLTable( XMLTableID int NOT NULL IDENTITY(1, 1) CONSTRAINT PK_XMLTable PRIMARY KEY ,XMLColumn xml ); GO CREATE PROC dbo.InsertXML @XmlParameter XML AS INSERT INTO dbo.XMLTable (XMLColumn) VALUES(@XmlParameter); SELECT CAST(SCOPE_IDENTITY() AS int) AS XMLTableID; GO var xmlObject = new XmlDocument(); xmlObject.LoadXml(" child text "); var connection = new SqlConnection(@"Data Source=MyServer;Initial Catalog=MyDatabase;Integrated Security=SSPI"); connection.Open(); var command = new SqlCommand("dbo.InsertXML", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@XMLParameter", SqlDbType.Xml); command.Parameters["@XMLParameter"].Value = xmlObject.OuterXml; int XmlTableID = (int)command.ExecuteScalar(); connection.Close();

how to save soap response in to the sql server database (sav

Answers (1)