There are some Duplicate column between Foreign key and Navigation Property at locode, How to controll it just show one of them?

[1257960069]

[1257960069]

can we show name, ranther than foreign key id by default? if id add the Navigation Property, it will show 2 column.

[Layoric]

@1257960069 You can use the attribute [Format(FormatMethods.Hidden)] on the properties to handle the duplicates. You can take a look at how this was handled in our example app TalentBlazor.

For changing how the FK is used, you can use the Ref attribute, eg

public class Employee
{
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }

    [Ref(Model = nameof(Employee), RefId = nameof(Id), RefLabel = nameof(LastName))]
    public int ReportsTo { get; set; }
    //...
}

Hope that helps.

[1257960069]

[Ref(Model = nameof(Employee), RefId = nameof(Id), RefLabel = nameof(LastName))]
just work at creating and editing, not work at table column

[1257960069]

thanks, it worked with [Format(FormatMethods.Hidden)] to hide Navigation Property

[1257960069]

When filtering a foreign key column, can we show dialog to select a id, just like creating select foreign key id?

[mythz]

Please submit any feature requests to https://servicestack.net/ideas