public override string EnableFKConstraints(EntityStructure t1)
{
try
{
this.ExecuteSql($"SET FOREIGN_KEY_CHECKS=1;");
DMEEditor.ErrorObject.Message = "successfull Enabled Mysql FK Constraints";
DMEEditor.ErrorObject.Flag = Errors.Ok;
}
catch (Exception ex)
{
DMEEditor.AddLogMessage("Fail", "Enabing Mysql FK Constraints" + ex.Message, DateTime.Now, 0, t1.EntityName, Errors.Failed);
}
return(DMEEditor.ErrorObject.Message);
}
public override string EnableFKConstraints(EntityStructure t1)
{
try
{
string consname = null;
foreach (var item in this.GetTablesFKColumnList(t1.EntityName, GetSchemaName(), null))
{
consname = item.RalationName;
this.ExecuteSql($"ALTER TABLE {t1.EntityName} DISABLE CONSTRAINT {consname}");
}
DMEEditor.ErrorObject.Message = "successfull Enabled Oracle FK Constraints";
DMEEditor.ErrorObject.Flag = Errors.Ok;
}
catch (Exception ex)
{
DMEEditor.AddLogMessage("Fail", "Enabing Oracle FK Constraints" + ex.Message, DateTime.Now, 0, t1.EntityName, Errors.Failed);
}
return(DMEEditor.ErrorObject.Message);
}
