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