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; }
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; }