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