Hi guys,

Is there a way to get a FK name if I know entity and relationshipInfo?

    _project = _executingGenerator.ProjectDefinition;
    var entities = _project.GetAllEntities();
    
    foreach(var entity in entities)
    {
        var allRelationshipInfosToTraverse = GeneratorUtils.GetAllRelationshipInfosForEntity(_executingGenerator, entity)
                                                        .Where(ri => ((ri.RelationshipType == EntityRelationshipType.ManyToMany) && ((IndirectRelationshipEdge)ri.Relationship).IsPureManyToMany) ||
                                                                    ((ri.RelationshipType != EntityRelationshipType.ManyToMany) && !ri.NormalRelationship.EntityFkSide.IsPureManyToManyIntermediate))
                                                        .ToList();
        foreach(var relationshipInfo in allRelationshipInfosToTraverse)
        {
                       ///// Here I want to get a constraint name for this relation
        }
    }

You have the following methods:

relationshipInfo.GetRelationshipFieldPairs() relationshipInfo.GetFkFieldsAsStringFromFkSide()

all FK constraints do have a name in the relational model. Do you want to generate new ones? Could you elaborate a bit what is the purpose of the template ?