public override void AddForeignKey(
string name,
SchemaQualifiedObjectName primaryTable,
string[] primaryColumns,
SchemaQualifiedObjectName refTable,
string[] refColumns,
ForeignKeyConstraint onDeleteConstraint = ForeignKeyConstraint.NoAction,
ForeignKeyConstraint onUpdateConstraint = ForeignKeyConstraint.NoAction)
{
throw new NotSupportedException("SQLite does not support foreign keys");
}
public void AddForeignKey(string name,
SchemaQualifiedObjectName primaryTable, string primaryColumn,
SchemaQualifiedObjectName refTable, string refColumn,
ForeignKeyConstraint onDeleteConstraint = ForeignKeyConstraint.NoAction,
ForeignKeyConstraint onUpdateConstraint = ForeignKeyConstraint.NoAction)
{
AddForeignKey(name,
primaryTable, new[] { primaryColumn },
refTable, new[] { refColumn },
onDeleteConstraint, onUpdateConstraint);
}
public virtual void AddForeignKey(string name,
SchemaQualifiedObjectName primaryTable, string[] primaryColumns,
SchemaQualifiedObjectName refTable, string[] refColumns,
ForeignKeyConstraint onDeleteConstraint = ForeignKeyConstraint.NoAction,
ForeignKeyConstraint onUpdateConstraint = ForeignKeyConstraint.NoAction)
{
string onDeleteConstraintResolved = fkActionMap.GetSqlOnDelete(onDeleteConstraint);
string onUpdateConstraintResolved = fkActionMap.GetSqlOnUpdate(onUpdateConstraint);
string sql = GetSqlAddForeignKey(name, primaryTable, primaryColumns, refTable, refColumns, onUpdateConstraintResolved, onDeleteConstraintResolved);
ExecuteNonQuery(sql);
}
public override void AddForeignKey(string name, SchemaQualifiedObjectName primaryTable, string[] primaryColumns, SchemaQualifiedObjectName refTable, string[] refColumns, ForeignKeyConstraint onDeleteConstraint = ForeignKeyConstraint.NoAction, ForeignKeyConstraint onUpdateConstraint = ForeignKeyConstraint.NoAction)
{
if (onUpdateConstraint != ForeignKeyConstraint.NoAction)
{
throw new NotSupportedException("Oracle does not support actions when updating a foreign key");
}
if (onDeleteConstraint == ForeignKeyConstraint.SetDefault)
{
throw new NotSupportedException("Oracle does not support SET DEFAULT when deleting a record referenced by a foreign key");
}
base.AddForeignKey(name, primaryTable, primaryColumns, refTable, refColumns, onDeleteConstraint, onUpdateConstraint);
}
