Beispiel #1
0
        public static bool storedproceduresEqual(StoredProcedure storedprocedure1, StoredProcedure storedprocedure2)
        {
            string ddl1 = Regex.Replace(ddl(storedprocedure1, Dialect.generic), "\\s", "");
            string ddl2 = Regex.Replace(ddl(storedprocedure2, Dialect.generic), "\\s", "");

            return ddl1 == ddl2;
        }
Beispiel #2
0
        public static string ddl(StoredProcedure storedprocedure, Dialect dialect)
        {
            string sql = "";
            if (dialect == Dialect.db2)
                sql = storedprocedure.platformDdl.Replace(storedprocedure.schema + ".", "");
            else
                sql = storedprocedure.platformDdl;

            return sql;
        }