public SqlForeignKeyConstraintExpression(string constraintName, IReadOnlyList <string> columnNames, SqlReferencesColumnExpression referencesColumnExpression)
: base(typeof(void))
{
this.ConstraintName = constraintName;
this.ColumnNames = columnNames;
this.ReferencesColumnExpression = referencesColumnExpression;
}
public SqlForeignKeyConstraintExpression(string constraintName, IReadOnlyList<string> columnNames, SqlReferencesColumnExpression referencesColumnExpression)
: base(typeof(void))
{
this.ConstraintName = constraintName;
this.ColumnNames = columnNames;
this.ReferencesColumnExpression = referencesColumnExpression;
}
protected override Expression VisitReferencesColumn(SqlReferencesColumnExpression expression)
{
this.hashCode ^= expression.Deferrability.GetHashCode();
this.hashCode ^= expression.OnDeleteAction.GetHashCode();
this.hashCode ^= expression.OnUpdateAction.GetHashCode();
return(base.VisitReferencesColumn(expression));
}
protected override Expression VisitReferencesColumn(SqlReferencesColumnExpression referencesColumnExpression)
{
if (referencesColumnExpression.Deferrability != SqlColumnReferenceDeferrability.NotDeferrable)
{
return new SqlReferencesColumnExpression(referencesColumnExpression.ReferencedTable, SqlColumnReferenceDeferrability.NotDeferrable, referencesColumnExpression.ReferencedColumnNames, referencesColumnExpression.OnDeleteAction, referencesColumnExpression.OnUpdateAction);
}
return base.VisitReferencesColumn(referencesColumnExpression);
}
public SqlForeignKeyConstraintExpression UpdateColumnNamesAndReferencedColumnExpression(IEnumerable<string> columnNames, SqlReferencesColumnExpression sqlReferencesColumnExpression)
{
return new SqlForeignKeyConstraintExpression(this.ConstraintName, columnNames, sqlReferencesColumnExpression);
}
public SqlForeignKeyConstraintExpression(string constraintName, IEnumerable<string> columnNames, SqlReferencesColumnExpression referencesColumnExpression)
: this(constraintName, columnNames.ToReadOnlyList(), referencesColumnExpression)
{
}
protected override Expression VisitReferencesColumn(SqlReferencesColumnExpression expression)
{
this.hashCode ^= expression.Deferrability.GetHashCode();
this.hashCode ^= expression.OnDeleteAction.GetHashCode();
this.hashCode ^= expression.OnUpdateAction.GetHashCode();
return base.VisitReferencesColumn(expression);
}
protected override Expression VisitReferencesColumn(SqlReferencesColumnExpression expression)
{
SqlReferencesColumnExpression current;
if (!TryGetCurrent(expression, out current))
{
return expression;
}
if (!(this.result &= current.Deferrability == expression.Deferrability))
{
return expression;
}
if (!(this.result &= current.OnDeleteAction == expression.OnDeleteAction))
{
return expression;
}
if (!(this.result &= current.OnUpdateAction == expression.OnUpdateAction))
{
return expression;
}
if (!(this.result &= current.NodeType == expression.NodeType))
{
return expression;
}
if (!(this.result &= current.Type == expression.Type))
{
return expression;
}
this.currentObject = current.ReferencedTable;
this.VisitTable(expression.ReferencedTable);
if (!this.result)
{
return expression;
}
this.currentObject = current.ReferencedColumnNames;
this.VisitObjectList(expression.ReferencedColumnNames);
if (!this.result)
{
return expression;
}
this.currentObject = current;
return expression;
}
public SqlForeignKeyConstraintExpression UpdateColumnNamesAndReferencedColumnExpression(IEnumerable <string> columnNames, SqlReferencesColumnExpression sqlReferencesColumnExpression)
{
return(new SqlForeignKeyConstraintExpression(this.ConstraintName, columnNames, sqlReferencesColumnExpression));
}
public SqlForeignKeyConstraintExpression(string constraintName, IEnumerable <string> columnNames, SqlReferencesColumnExpression referencesColumnExpression)
: this(constraintName, columnNames.ToReadOnlyCollection(), referencesColumnExpression)
{
}
protected override Expression VisitReferencesColumn(SqlReferencesColumnExpression referencesColumnExpression)
{
this.Write("REFERENCES ");
this.Visit(referencesColumnExpression.ReferencedTable);
this.Write("(");
this.WriteDeliminatedListOfItems(referencesColumnExpression.ReferencedColumnNames, this.WriteQuotedIdentifier);
this.Write(")");
if (referencesColumnExpression.OnDeleteAction != SqlColumnReferenceAction.NoAction)
{
this.Write(" ON DELETE ");
this.Write(referencesColumnExpression.OnDeleteAction);
}
if (referencesColumnExpression.OnUpdateAction != SqlColumnReferenceAction.NoAction)
{
this.Write(" ON UPDATE ");
this.Write(referencesColumnExpression.OnUpdateAction);
}
if (this.sqlDialect.SupportsFeature(SqlFeature.Deferrability))
{
this.WriteDeferrability(referencesColumnExpression.Deferrability);
}
return referencesColumnExpression;
}
protected virtual Expression VisitReferencesColumn(SqlReferencesColumnExpression referencesColumnExpression)
{
return referencesColumnExpression;
}
private IEnumerable<SqlColumnDefinitionExpression> BuildForeignKeyColumnDefinitions(PropertyDescriptor referencingProperty, ColumnInfo[] columnInfos)
{
var relatedPropertyTypeDescriptor = this.model.GetTypeDescriptor(referencingProperty.PropertyType);
var referencedTableName = relatedPropertyTypeDescriptor.PersistedName;
var valueRequired = (referencingProperty.ValueRequiredAttribute != null && referencingProperty.ValueRequiredAttribute.Required)
|| referencingProperty.IsPrimaryKey;
var supportsInlineForeignKeys = this.sqlDialect.SupportsFeature(SqlFeature.InlineForeignKeys);
var foreignObjectConstraintAttribute = referencingProperty.ForeignObjectConstraintAttribute;
foreach (var foreignKeyColumn in columnInfos)
{
var retval = this.BuildColumnDefinition(foreignKeyColumn);
if (columnInfos.Length == 1 && supportsInlineForeignKeys)
{
var names = new[] { foreignKeyColumn.DefinitionProperty.PersistedName };
var newConstraints = new List<Expression>(retval.ConstraintExpressions);
var referencesColumnExpression = new SqlReferencesColumnExpression
(
new SqlTableExpression(referencedTableName),
SqlColumnReferenceDeferrability.InitiallyDeferred,
names,
FixAction((foreignObjectConstraintAttribute != null && ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction) != null) ? ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction).Value : (valueRequired ? SqlColumnReferenceAction.Restrict : SqlColumnReferenceAction.SetNull)),
FixAction((foreignObjectConstraintAttribute != null && ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction) != null) ? ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnUpdateAction).Value : SqlColumnReferenceAction.NoAction)
);
newConstraints.Add(referencesColumnExpression);
retval = new SqlColumnDefinitionExpression(retval.ColumnName, retval.ColumnType, newConstraints);
}
yield return retval;
}
if (columnInfos.Length > 1 || !supportsInlineForeignKeys)
{
var currentTableColumnNames = columnInfos.Select(c => c.ColumnName);
var referencedTableColumnNames = columnInfos.Select(c => c.GetTailColumnName());
var referencesColumnExpression = new SqlReferencesColumnExpression
(
new SqlTableExpression(referencedTableName),
SqlColumnReferenceDeferrability.InitiallyDeferred,
referencedTableColumnNames,
FixAction((foreignObjectConstraintAttribute != null && ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction) != null) ? ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction).Value : (valueRequired ? SqlColumnReferenceAction.Restrict : SqlColumnReferenceAction.SetNull)),
FixAction((foreignObjectConstraintAttribute != null && ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnDeleteAction) != null) ? ToSqlColumnReferenceAction(foreignObjectConstraintAttribute.OnUpdateAction).Value : SqlColumnReferenceAction.NoAction)
);
var foreignKeyConstraint = new SqlForeignKeyConstraintExpression(null, currentTableColumnNames, referencesColumnExpression);
currentTableConstraints.Add(foreignKeyConstraint);
}
}
protected virtual Expression VisitReferencesColumn(SqlReferencesColumnExpression referencesColumnExpression)
{
return(referencesColumnExpression);
}