N/APosted on - 06/14/2012
I want to know some basic stuff of SQL. Suppose I use WCF SQL adapter to store the log messages to database. But some characters are needed to be skipped in XML. Is there any way to other than typed store procedure to avoid the characters?
Type store procedure for WCF SQL adapter
Some web servers allow you to use certain type of scripts that skip such invalid characters that might cause the problem. Since you might not own such type of server, it means that you either have to stick with the stored procedures or with the option of switching to a new server.
The last possibility is if you think to make the script yourself.
First see what type of characters you want to skip.
Then define a script that would check each message before entering in the log.
The script must not change the other elements of the message as it defeats the purpose of having it.
After the script has been written, use it to see if it is working.