Improve navigation property names when reverse engineering a database

by

There a few things you need to change inside the .tt file. I choose to use the third solution you suggested but this requires to be formatted like FK_CollectionName_RelationName. I split them up with ‘_’ and use the last string in the array.
I use the RelationName with the ToEndMember property to create a property name. FK_Projects_TechnicalContact will result in 

//Plularized because of EF. 
public virtual Contacts TechnicalContactContacts { get; set; }

and your projects will be like this. 

public virtual ICollection<Projects> SalesContactProjects { get;  set; }
public virtual ICollection<Projects> TechnicalContactProjects { get;  set; }

Now the code you may ask. Ive added 2 functions to the CodeStringGenerator class in the T4 file. One which builds the propertyName recieving a NavigationProperty. and the other one generating the code for the property recieving a NavigationProperty and the name for the property. 

//CodeStringGenerator class
public string GetPropertyNameForNavigationProperty(NavigationProperty navigationProperty)
{
    var ForeignKeyName = navigationProperty.RelationshipType.Name.Split('_');
    var propertyName = ForeignKeyName[ForeignKeyName.Length-1] + navigationProperty.ToEndMember.Name;
    return propertyName;
}

public string NavigationProperty(NavigationProperty navigationProperty, string name)
{
    var endType = _typeMapper.GetTypeName(navigationProperty.ToEndMember.GetEntityType());
    return string.Format(
        CultureInfo.InvariantCulture,
        "{0} {1} {2} {{ {3}get; {4}set; }}",
        AccessibilityAndVirtual(Accessibility.ForProperty(navigationProperty)),
        navigationProperty.ToEndMember.RelationshipMultiplicity == RelationshipMultiplicity.Many ? ("ICollection<" + endType + ">") : endType,
        name,
        _code.SpaceAfter(Accessibility.ForGetter(navigationProperty)),
        _code.SpaceAfter(Accessibility.ForSetter(navigationProperty)));
}

If you place the above code in the class you still need to change 2 parts. You need to find the place where the constructor part and the navigation property part are being build up of the entity. In the constructor part (around line 60) you need to replace the existing code by calling the method GetPropertyNameForNavigationProperty and passing this into the escape method. 

      var propName = codeStringGenerator.GetPropertyNameForNavigationProperty(navigationProperty);
#>
      this.<#=code.Escape(propName)#> = new HashSet<<#=typeMapper.GetTypeName(navigationProperty.ToEndMember.GetEntityType())#>>();
<#

And in the NavigationProperties part (around line 100) you also need to replace the code with the following.

    var propName = codeStringGenerator.GetPropertyNameForNavigationProperty(navigationProperty);
#>
    <#=codeStringGenerator.NavigationProperty(navigationProperty, propName)#>
<#

I hope this helps and you can always debug the GetPropertyNameForNavigationProperty function and play a little with the naming of the property.

More Related Contents:

  1. EF5 Code First Enums and Lookup Tables
  2. Debug code-first Entity Framework migration codes
  3. Entity Framework Code First Using Guid as Identity with another Identity Column
  4. Code-first vs Model/Database-first [closed]
  5. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  6. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  7. Unique Key constraints for multiple columns in Entity Framework
  8. Entity Framework 6 Code first Default value
  9. Batch update/delete EF5
  10. EntityFramework code-first custom connection string and migrations
  11. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  12. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  13. How do I detach objects in Entity Framework Code First?
  14. How to include a child object’s child object in Entity Framework 5
  15. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  16. Entity framework code-first null foreign key
  17. Entity Framework loading child collection with sort order
  18. How do I singularize my tables in EF Code First?
  19. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  20. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  21. mapping private property entity framework code first [duplicate]
  22. What is the syntax for self referencing foreign keys in EF Code First?
  23. How to create index in Entity Framework 6.2 with fluent configuration
  24. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  25. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  26. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  27. DbContext AutoDetectChangesEnabled set to false detecting changes
  28. LINQ To Entities + Include + Anonymous type issue
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment