internal void CreateManyToMany <T1, T2, T3>(Table <T1> table1, Table <T2> table2, Table <T3> relationalTable,
Expression <Func <T3, Guid> > foreignKey1, Expression <Func <T3, Guid> > foreignKey2, bool cascateDeletion = true)
where T1 : Entity
where T2 : Entity
where T3 : Entity
{
var compiledForeignKey1 = foreignKey1.Compile();
var compiledForeignKey2 = foreignKey2.Compile();
var relationProperties = new RelationProperties
{
RelationType = RelationType.ManyToMany,
TableWithDependency = table1.GetType(),
TableDependency = table2.GetType(),
RelationalTable = relationalTable.GetType(),
ForeignKey1 = entity => compiledForeignKey1(entity as T3),
ForeignKey2 = entity => compiledForeignKey2(entity as T3)
};
relationProperties.OnDeleteOperation((tableType, fk) =>
{
if ((tableType == table1.GetType() || tableType == table2.GetType()) && cascateDeletion)
{
relationalTable.Delete(t => relationProperties.ForeignKey1(t) == fk ||
relationProperties.ForeignKey2(t) == fk);
}
});
AddRelationProperties(table1.GetType(), relationProperties);
AddRelationProperties(table2.GetType(), relationProperties);
AddRelationProperties(relationalTable.GetType(), relationProperties);
}
internal void CreateOneToOne <T1, T2>(Table <T1> tableWithDependency, Table <T2> tableDependency,
Func <T1, Guid> foreignKey, bool cascateDeletion = true)
where T1 : Entity
where T2 : Entity
{
var relationProperties = new RelationProperties
{
RelationType = RelationType.OneToOne,
TableWithDependency = tableWithDependency.GetType(),
TableDependency = tableDependency.GetType()
};
relationProperties.OnDeleteOperation((tableType, fk) =>
{
if (tableType == tableDependency.GetType() && cascateDeletion)
{
tableDependency.Delete(fk);
}
});
relationProperties.OnForeignKey(entity => foreignKey(entity as T1));
AddRelationProperties(tableWithDependency.GetType(), relationProperties);
AddRelationProperties(tableDependency.GetType(), relationProperties);
}
private void AddRelationProperties(Type tableType, RelationProperties relationProperties)
{
if (_relations.ContainsKey(tableType))
{
_relations[tableType].Add(relationProperties);
}
else
{
_relations[tableType] = new List <RelationProperties> {
relationProperties
}
};
}
