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