private manytoone CreateManyToOneNode(DirectedReference directedReference, ITable referenceMappedTable) { fetchMode fetchMode; bool insert; bool update; if (directedReference.Entity1IsFromEnd) { fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd1FetchMode().ToString(), true); insert = directedReference.Reference.GetReferenceEnd1Insert(); update = directedReference.Reference.GetReferenceEnd1Update(); } else { fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd2FetchMode().ToString(), true); insert = directedReference.Reference.GetReferenceEnd2Insert(); update = directedReference.Reference.GetReferenceEnd2Update(); } manytoone manyToOneNode = new manytoone(); manyToOneNode.@class = directedReference.ToEntity.Name; manyToOneNode.name = directedReference.FromName; //bool notNullableColumnsExist = directedRelationship.MappedColumns.Any(mc => !mc.Source.IsNullable); manyToOneNode.notnull = true; manyToOneNode.notnullSpecified = true; manyToOneNode.fetch = fetchMode; manyToOneNode.fetchSpecified = true; manyToOneNode.insert = insert; manyToOneNode.update = update; ITable fromPrimaryMappedTable = EntityMapper.GetPrimaryTable(directedReference.FromEntity); List<IColumn> fromKeyColumns = referenceMappedTable.Relationships.First(t => t.PrimaryTable == fromPrimaryMappedTable || t.ForeignTable == fromPrimaryMappedTable).ForeignKey.Columns.ToList(); if (fromKeyColumns.Count > 1) foreach (var columnNode in GetColumnNodes(fromKeyColumns)) manyToOneNode.AddColumn(columnNode); else manyToOneNode.column = fromKeyColumns[0].Name.BackTick(); return manyToOneNode; }
private manytoone CreateManyToOneNode(DirectedReference directedReference, DirectedRelationship directedRelationship, string cascade) { fetchMode fetchMode; bool insert; bool update; if (directedReference.Entity1IsFromEnd) { fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd1FetchMode().ToString(), true); insert = directedReference.Reference.GetReferenceEnd1Insert(); update = directedReference.Reference.GetReferenceEnd1Update(); } else { fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd2FetchMode().ToString(), true); insert = directedReference.Reference.GetReferenceEnd2Insert(); update = directedReference.Reference.GetReferenceEnd2Update(); } manytoone manyToOneNode = new manytoone(); manyToOneNode.@class = directedReference.ToEntity.Name; manyToOneNode.name = directedReference.FromName; bool notNullableColumnsExist = directedRelationship.MappedColumns.Any(mc => !mc.Source.IsNullable); manyToOneNode.notnull = notNullableColumnsExist; manyToOneNode.notnullSpecified = true; manyToOneNode.fetch = fetchMode; manyToOneNode.fetchSpecified = true; manyToOneNode.insert = insert; manyToOneNode.update = update; manyToOneNode.cascade = cascade == "none" ? null : cascade; if (directedRelationship.ToTable == directedRelationship.FromTable) { if (directedRelationship.ToKey.Keytype == Providers.EntityModel.Helper.DatabaseKeyType.Primary) if (directedRelationship.FromKey.Columns.Count > 1) foreach (var column in GetColumnNodes(directedRelationship.FromKey.Columns)) manyToOneNode.AddColumn(column); else manyToOneNode.column = directedRelationship.FromKey.Columns[0].Name.BackTick(); else if (directedRelationship.ToKey.Columns.Count > 1) foreach (var column in GetColumnNodes(directedRelationship.ToKey.Columns)) manyToOneNode.AddColumn(column); else manyToOneNode.column = directedRelationship.ToKey.Columns[0].Name.BackTick(); } else { if (directedRelationship.FromKey.Columns.Count > 1) foreach (var column in GetColumnNodes(directedRelationship.FromKey.Columns)) manyToOneNode.AddColumn(column); else manyToOneNode.column = directedRelationship.FromKey.Columns[0].Name.BackTick(); } return manyToOneNode; }