private void ProcessManyToOneReference( Entity entity, DirectedReference directedReference, Action<object> addItem, string cascade, string collectionCascade, string lazy, string orderByClause, bool inverse) { if (directedReference.FromEndEnabled == false) return; ITable referenceMappedTable = directedReference.Reference.MappedTable(); DirectedRelationship directedRelationship = null; if (referenceMappedTable == null) directedRelationship = GetDirectedMappedRelationship(entity, directedReference.Reference); if (directedReference.FromEndCardinality == Cardinality.One) { 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; if (referenceMappedTable == null) manyToOneNode = CreateManyToOneNode(directedReference, directedRelationship, cascade); else manyToOneNode = CreateManyToOneNode(directedReference, referenceMappedTable); manyToOneNode.fetch = fetchMode; manyToOneNode.fetchSpecified = true; manyToOneNode.insert = insert; manyToOneNode.update = update; addItem(manyToOneNode); } else { key keyNode = new key(); if (referenceMappedTable == null && directedRelationship.ToKey.Columns.Count > 1) { foreach (var columnNode in GetColumnNodes(directedRelationship.ToKey.Columns)) keyNode.AddColumn(columnNode); } else if (referenceMappedTable != null) { ITable toPrimaryMappedTable = EntityMapper.GetPrimaryTable(directedReference.ToEntity); var toColumnsInPrimaryKey = referenceMappedTable.Relationships.First(t => t.PrimaryTable == toPrimaryMappedTable || t.ForeignTable == toPrimaryMappedTable).ForeignKey.Columns; foreach (var columnNode in GetColumnNodes(toColumnsInPrimaryKey)) keyNode.AddColumn(columnNode); } else keyNode.column1 = directedRelationship.ToKey.Columns[0].Name.BackTick(); onetomany oneToManyNode = new onetomany(); oneToManyNode.@class = directedReference.ToEntity.Name; collectionFetchMode collFetchMode; if (directedReference.Entity1IsFromEnd) collFetchMode = (collectionFetchMode)Enum.Parse(typeof(collectionFetchMode), directedReference.Reference.GetReferenceEnd1CollectionFetchMode().ToString(), true); else collFetchMode = (collectionFetchMode)Enum.Parse(typeof(collectionFetchMode), directedReference.Reference.GetReferenceEnd2CollectionFetchMode().ToString(), true); AssociationType type = NHCollections.GetAssociationType(directedReference); switch (type) { case AssociationType.None: Log.WarnFormat("No association type was set on reference {0} for the end {1}. This is usually an error.", directedReference.Reference.Name, directedReference.Entity1IsFromEnd ? "1" : "2"); return; case AssociationType.Set: var set = CreateSetNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); set.Item = oneToManyNode; if (orderByClause.Length > 0) set.orderby = orderByClause; addItem(set); break; case AssociationType.Map: var mapNode = CreateMapNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); mapNode.Item = new index { column1 = NHCollections.GetIndexColumnName(directedReference), type = NHCollections.GetIndexColumnTypeName(directedReference, EntityMapper.GetPrimaryTable(directedReference.ToEntity)) }; mapNode.Item1 = oneToManyNode; if (orderByClause.Length > 0) mapNode.orderby = orderByClause; addItem(mapNode); break; case AssociationType.Bag: var bag = CreateBagNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); bag.Item = oneToManyNode; if (orderByClause.Length > 0) bag.orderby = orderByClause; addItem(bag); break; case AssociationType.List: list listNode = CreateListNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); listNode.Item = new index { column1 = NHCollections.GetIndexColumnName(directedReference) }; listNode.Item1 = oneToManyNode; if (orderByClause.Length > 0) listNode.orderby = orderByClause; addItem(listNode); break; case AssociationType.IDBag: idbag idbagNode = CreateIdBagNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); idbagNode.collectionid = new collectionid { column1 = NHCollections.GetIndexColumnName(directedReference), generator = new generator { @class = "sequence" }, type = NHCollections.GetIndexColumnTypeName(directedReference, EntityMapper.GetPrimaryTable(directedReference.ToEntity)) }; addItem(idbagNode); break; default: throw new ArgumentOutOfRangeException("AssociationType not handled yet: " + type.ToString()); } } }
private void ProcessOneToOneReference(Entity entity, DirectedReference directedReference, Action<object> addItem, string cascade, string lazy) { if (directedReference.FromEndEnabled == false) return; DirectedRelationship directedRelationship = GetDirectedMappedRelationship(entity, directedReference.Reference); fetchMode fetchMode; if (directedReference.Entity1IsFromEnd) fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd1FetchMode().ToString(), true); else fetchMode = (fetchMode)Enum.Parse(typeof(fetchMode), directedReference.Reference.GetReferenceEnd2FetchMode().ToString(), true); // if this side has the foreign key, it gets the many to one node if (directedRelationship.FromKey.Keytype == DatabaseKeyType.Foreign) { manytoone manyToOneNode = CreateManyToOneNode(directedReference, directedRelationship, cascade); manyToOneNode.unique = true; manyToOneNode.fetch = fetchMode; manyToOneNode.fetchSpecified = true; addItem(manyToOneNode); } else { onetoone oneToOneNode = new onetoone(); oneToOneNode.@class = directedReference.ToEntity.Name; oneToOneNode.name = directedReference.FromName; oneToOneNode.propertyref = directedReference.ToName; oneToOneNode.fetch = fetchMode; oneToOneNode.fetchSpecified = true; addItem(oneToOneNode); } }
private set CreateSetNode(DirectedReference reference, key keyNode, string cascade, collectionFetchMode colFetchMode, string lazyString, bool inverse) { var lazy = (collectionLazy)Enum.Parse(typeof(collectionLazy), lazyString.ToString().Replace("_", ""), true); set setNode = new set(); setNode.name = reference.FromName; setNode.key = keyNode; setNode.cascade = cascade == "none" ? null : cascade; setNode.inverse = inverse; setNode.fetchSpecified = colFetchMode != collectionFetchMode.select; setNode.fetch = colFetchMode; setNode.lazySpecified = lazy != collectionLazy.@true; setNode.lazy = (collectionLazy)Enum.Parse(typeof(collectionLazy), lazy.ToString().Replace("_", ""), true); var sqlWhereClause = NHCollections.GetSqlWhereClause(reference); if (string.IsNullOrEmpty(sqlWhereClause) == false) setNode.where = sqlWhereClause; return setNode; }
private void ProcessManyToManyReference( Entity entity, DirectedReference directedReference, Action<object> addItem, Dictionary<ITable, int> manyToManySameTableProcessingCounts, string collectionCascade, string lazy, string orderByClause, bool inverse) { if (directedReference.FromEndEnabled == false) return; ITable referenceMappedTable = directedReference.Reference.MappedTable(); ITable fromPrimaryMappedTable = EntityMapper.GetPrimaryTable(entity); ITable toPrimaryMappedTable = EntityMapper.GetPrimaryTable(directedReference.ToEntity); Cardinality cardinalityPrimary; Cardinality cardinalityForeign; IKey mainKey; IKey associationKey; ITable associationTable = entity.GetAssociationTable(directedReference.ToEntity, out cardinalityPrimary, out cardinalityForeign, out mainKey, out associationKey); key keyNode = new key(); List<IColumn> fromInPrimaryKey = new List<IColumn>(); List<IColumn> toInPrimaryKey = new List<IColumn>(); if (fromPrimaryMappedTable == toPrimaryMappedTable) { // This many-to-many relationship is to the same table if (manyToManySameTableProcessingCounts.ContainsKey(toPrimaryMappedTable)) { int index = manyToManySameTableProcessingCounts[toPrimaryMappedTable]; index++; fromInPrimaryKey.AddRange(referenceMappedTable.Relationships.Where(t => t.PrimaryTable == fromPrimaryMappedTable).ElementAt(index).PrimaryKey.Columns); toInPrimaryKey.AddRange(referenceMappedTable.Relationships.Where(t => t.PrimaryTable == toPrimaryMappedTable).ElementAt(index).ForeignKey.Columns); manyToManySameTableProcessingCounts[toPrimaryMappedTable] = index; } else { fromInPrimaryKey.AddRange(referenceMappedTable.Relationships.Where(t => t.PrimaryTable == fromPrimaryMappedTable).ElementAt(0).PrimaryKey.Columns); toInPrimaryKey.AddRange(referenceMappedTable.Relationships.Where(t => t.PrimaryTable == toPrimaryMappedTable).ElementAt(0).ForeignKey.Columns); manyToManySameTableProcessingCounts.Add(toPrimaryMappedTable, 0); } } else { foreach (var coll in referenceMappedTable.Relationships.Where(t => t.PrimaryTable == fromPrimaryMappedTable).Select(r => r.ForeignKey.Columns)) foreach (var c in coll) fromInPrimaryKey.Add(c); foreach (var coll in referenceMappedTable.Relationships.Where(t => t.PrimaryTable == toPrimaryMappedTable).Select(r => r.ForeignKey.Columns)) foreach (var c in coll) toInPrimaryKey.Add(c); } if (fromInPrimaryKey.Count() == 1) keyNode.column1 = fromInPrimaryKey.First().Name.BackTick(); else foreach (var columnNode in GetColumnNodes(fromInPrimaryKey)) keyNode.AddColumn(columnNode); manytomany manyToManyNode = new manytomany(); manyToManyNode.@class = directedReference.ToEntity.Name; if (toInPrimaryKey.Count() == 1) manyToManyNode.column = toInPrimaryKey.First().Name.BackTick(); else foreach (var columnNode in GetColumnNodes(toInPrimaryKey)) keyNode.AddColumn(columnNode); collectionFetchMode collFetchMode; if (directedReference.Entity1IsFromEnd) collFetchMode = (collectionFetchMode)Enum.Parse(typeof(collectionFetchMode), directedReference.Reference.GetReferenceEnd1CollectionFetchMode().ToString(), true); else collFetchMode = (collectionFetchMode)Enum.Parse(typeof(collectionFetchMode), directedReference.Reference.GetReferenceEnd2CollectionFetchMode().ToString(), true); AssociationType type = NHCollections.GetAssociationType(directedReference); switch (type) { case AssociationType.None: Log.WarnFormat("No association type was set on reference {0} for the end {1}. This is usually an error.", directedReference.Reference.Name, directedReference.Entity1IsFromEnd ? "One" : "Two"); return; case AssociationType.Set: set setNode = CreateSetNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); setNode.table = referenceMappedTable.Name.BackTick(); setNode.Item = manyToManyNode; if (orderByClause.Length > 0) setNode.orderby = orderByClause; addItem(setNode); break; case AssociationType.Bag: bag bagNode = CreateBagNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); bagNode.table = referenceMappedTable.Name.BackTick(); bagNode.Item = manyToManyNode; if (orderByClause.Length > 0) bagNode.orderby = orderByClause; addItem(bagNode); break; case AssociationType.Map: map mapNode = CreateMapNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); mapNode.table = referenceMappedTable.Name.BackTick(); mapNode.Item = new index { column1 = NHCollections.GetIndexColumnName(directedReference), type = NHCollections.GetIndexColumnTypeName(directedReference, toPrimaryMappedTable /*fromPrimaryMappedTable*/) }; mapNode.Item1 = manyToManyNode; if (orderByClause.Length > 0) mapNode.orderby = orderByClause; addItem(mapNode); break; case AssociationType.List: list listNode = CreateListNode(directedReference, keyNode, collectionCascade, collFetchMode, lazy, inverse); listNode.table = referenceMappedTable.Name.BackTick(); listNode.Item = new index { column1 = NHCollections.GetIndexColumnName(directedReference), }; listNode.Item1 = manyToManyNode; if (orderByClause.Length > 0) listNode.orderby = orderByClause; addItem(listNode); break; // case AssociationType.IDBag: // throw new NotImplementedException( // string.Format("Have not implemented {0} association type for Many To Many relationships", type)); default: throw new NotImplementedException("AssociationType not handled yet: " + type.ToString()); } }
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; }
private void mnuMergeEntity_Click(object sender, EventArgs e) { BusyPopulating = true; try { DirectedReference dr = new DirectedReference(TheEntity, SelectedReference); Entity entityToMerge = dr.ToEntity; List<ITable> mappedTables = entityToMerge.MappedTables().ToList(); foreach (var table in mappedTables) foreach (var column in table.Columns) { Property newProperty = Controller.MappingLayer.OneToOneEntityProcessor.CreatePropertyFromColumn(column); newProperty.Name = newProperty.Name.GetNextName(TheEntity.Properties.Select(p => p.Name)); TheEntity.AddProperty(newProperty); newProperty.SetMappedColumn(column); } entityToMerge.DeleteSelf(); } finally { BusyPopulating = false; Populate(); } }
public static string ProcessReferenceTemplate(Entity entity, DirectedReference reference) { System.Text.StringBuilder sb = new StringBuilder(((SourceCodeMultiLineType)SharedData.CurrentProject.GetUserOption("ReferenceTemplate")).Value); string typeName; if (reference.FromEndCardinality == ArchAngel.Interfaces.Cardinality.Many) typeName = NHCollections.GetCollectionType(reference).Replace(SharedData.CurrentProject.GetUserOption("ProjectNamespace").ToString() + ".Model.", ""); else typeName = reference.ToEntity.Name; sb.Replace("#entity.Name#", entity.Name); sb.Replace("#reference.Name#", reference.FromName); sb.Replace("#reference.Type#", typeName); bool usePrivateSetter = (bool)SharedData.CurrentProject.GetUserOption("UsePrivateSettersOnProperties") || (reference.Entity1IsFromEnd ? (bool)reference.Reference.GetUserOptionValue("End1UsePrivateSetter") : (bool)reference.Reference.GetUserOptionValue("End2UsePrivateSetter")); ProcessIfStatement(sb, "reference.SetterIsPrivate", usePrivateSetter); return RemoveTrailingLineBreaks(sb.ToString()); }
private static void ProcessOneToManyReference(MappingSet set, Reference reference) { var manyEnd = reference.Cardinality1 == Cardinality.Many ? reference.Entity1 : reference.Entity2; var directedRef = new DirectedReference(manyEnd, reference); var oneEnd = directedRef.ToEntity; var oneEndTable = oneEnd.MappedTables().First(); var manyEndTable = manyEnd.MappedTables().First(); IKey primaryKey = oneEndTable.FirstPrimaryKey; // Create a foreign key on the Many side Key foreignKey = CreateForeignKey(set, oneEndTable, manyEndTable); // Create the relationship between the two. var relationship = oneEndTable.CreateRelationshipUsing(primaryKey, foreignKey); set.ChangeMappingFor(reference).To(relationship); }