Communication Penton Style
First off....I know I badly need to blog more. Life just keeps running me over (enough of the excuses). My friend Steve Schofield wanted me to blog more on inserting XML into SQL Server. So, I am going to post a number of things. All that actually work by downloading the files.
[1] Table layout (dbo.TestMessages.TAB)
[2] Stored Procedure (dbo.InsertMessageXml.PRC)
[3] C# code with some XML
I am also posting a zip of everything (compiled EXE also). Please change XmlInsert.exe.config file to point to your database. Then, take the dbo.InsertMessageXml.PRC and dbo.TestMessages.TAB files and execute them to put those objects in your database.
These files are based on the code in my previous blog entry.