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