public static bool viewsEqual(View view1, View view2) { string ddl1 = Regex.Replace(ddl(view1, Dialect.generic),"\\s",""); string ddl2 = Regex.Replace(ddl(view2, Dialect.generic),"\\s",""); return ddl1 == ddl2; }
public static string ddl(View view, Dialect dialect) { string sql = ""; if (dialect == Dialect.sqlServer) { sql = view.platformDdl; } else { // sql = view.platformDdl.Replace(view.schema + ".", ""); sql = view.platformDdl; sql = System.Text.RegularExpressions.Regex.Replace(sql, @"""", ""); sql = sql.Replace(view.schema + ".", ""); } //sql = view.platformDdl.Replace(view.schema + ".",""); return sql; }