C# string - creating an unescaped backslash

Question

I am using .NET (C#) code to write to a database that interfaces with a Perl application. When a single quote appears in a string, I need to "escape" it. IOW, the name O'Bannon should convert to O\'Bannon for the database UPDATE. However, all efforts at string manipulation (e.g. .Replace) generate an escape character for the backslash and I end up with O\\'Bannon.

I know it is actually generating the second backslash, because I can read the resulting database field's value (i.e. it is not just the IDE debug value for the string).

How can I get just the single backslash in the output string?

R

Answer 1

Well I did

"O'Bannon".Replace("'","\\'")

and result is

"O\'Bannon"

Is this what you want?

Answer 2

You can use "\\", which is the escape char followed by a backslash.

See the list of Escape Sequences here: http://msdn.microsoft.com/en-us/library/h21280bw.aspx