public ICreateConstraints AddForeignKeyOn(string columnNames, string parentTable, string parentColumns, ForeignKeyRelationCascade onUpdate = ForeignKeyRelationCascade.NoAction, ForeignKeyRelationCascade onDelete = ForeignKeyRelationCascade.NoAction, string keyName = null) { _current = Schema.AddForeignKey(columnNames, parentTable, parentColumns, onUpdate, onDelete, keyName); return(this); }
public IConfigureColumns IsForeignKeyFrom(string parentTable, string parentColumns, ForeignKeyRelationCascade onUpdate = ForeignKeyRelationCascade.NoAction, ForeignKeyRelationCascade onDelete = ForeignKeyRelationCascade.NoAction, string keyName = null) { _table.Constraints.AddForeignKey(_currentColumn.Name, parentTable, parentColumns, onUpdate, onDelete, keyName); return this; }
public IConfigureColumns IsForeignKeyFrom(string parentTable, string parentColumns, ForeignKeyRelationCascade onUpdate = ForeignKeyRelationCascade.NoAction, ForeignKeyRelationCascade onDelete = ForeignKeyRelationCascade.NoAction, string keyName = null) { _table.Constraints.AddForeignKey(_currentColumn.Name, parentTable, parentColumns, onUpdate, onDelete, keyName); return(this); }
public static string ToString(ForeignKeyRelationCascade relation) { switch (relation) { case ForeignKeyRelationCascade.Cascade: return "CASCADE"; case ForeignKeyRelationCascade.Restrict: return relation.ToString(); case ForeignKeyRelationCascade.SetDefault: return "SET DEFAULT"; case ForeignKeyRelationCascade.SetNull: return "SET NULL"; default: return "NO ACTION"; } }
public static string ToString(ForeignKeyRelationCascade relation) { switch (relation) { case ForeignKeyRelationCascade.Cascade: return("CASCADE"); case ForeignKeyRelationCascade.Restrict: return(relation.ToString()); case ForeignKeyRelationCascade.SetDefault: return("SET DEFAULT"); case ForeignKeyRelationCascade.SetNull: return("SET NULL"); default: return("NO ACTION"); } }
public ConstraintDefinition AddForeignKey(string columnNames, string parentTable, string parentColumns, ForeignKeyRelationCascade onUpdate = ForeignKeyRelationCascade.NoAction, ForeignKeyRelationCascade onDelete = ForeignKeyRelationCascade.NoAction, string keyName = null) { columnNames.MustNotBeEmpty(); parentTable.MustNotBeEmpty(); parentColumns.MustNotBeEmpty(); var fk = new ForeignKeyConstraint { Columns = columnNames, ParentTable = parentTable, Name = keyName ?? GenerateForeignKeyName(columnNames, parentTable, parentColumns), ParentColumn = parentColumns, OnUpdate = onUpdate, OnDelete = onDelete }; ForeignKeys.Add(fk); return fk; }
public ConstraintDefinition AddForeignKey(string columnNames, string parentTable, string parentColumns, ForeignKeyRelationCascade onUpdate = ForeignKeyRelationCascade.NoAction, ForeignKeyRelationCascade onDelete = ForeignKeyRelationCascade.NoAction, string keyName = null) { columnNames.MustNotBeEmpty(); parentTable.MustNotBeEmpty(); parentColumns.MustNotBeEmpty(); var fk = new ForeignKeyConstraint { Columns = columnNames, ParentTable = parentTable, Name = keyName ?? GenerateForeignKeyName(columnNames, parentTable, parentColumns), ParentColumn = parentColumns, OnUpdate = onUpdate, OnDelete = onDelete }; ForeignKeys.Add(fk); return(fk); }
public IConfigureForeignKeys <T, TParent> OnDelete(ForeignKeyRelationCascade action) { _data.OnDelete = action; return(this); }