Category: Visual Studio

MySQL Real Escape Function in C#

If you need a similiar function to the mysql_real_escape_string() from php, you might could use this one: public static string MySQLEscape(string str) { return Regex.Replace(str, @"[\x00'""\b\n\r\t\cZ\\%_]", delegate(Match match) { string v = match.Value; switch (v) { case "\x00":            // ASCII NUL (0x00) character return "\\0"; case "\b":              // BACKSPACE character return "\\b"; case "\n":              //…