public MySqlView(MySqlCommand cmd, string viewName) { _name = viewName; string sqlShowCreate = string.Format("SHOW CREATE VIEW `{0}`;", viewName); System.Data.DataTable dtView = QueryExpress.GetTable(cmd, sqlShowCreate); _createViewSQL = dtView.Rows[0]["Create View"] + ";"; _createViewSQL = _createViewSQL.Replace("\r\n", "^~~~~~~~~~~~~~~^"); _createViewSQL = _createViewSQL.Replace("\n", "^~~~~~~~~~~~~~~^"); _createViewSQL = _createViewSQL.Replace("\r", "^~~~~~~~~~~~~~~^"); _createViewSQL = _createViewSQL.Replace("^~~~~~~~~~~~~~~^", "\r\n"); _createViewSQLWithoutDefiner = QueryExpress.EraseDefiner(_createViewSQL); }