Renaming lookup objetcs

Radzen Studio Blazor Server
1

I have a table of Measurements, each measurement record has 3 relations with the Unit table:

  • Measurement Unit (foreign key field is UnitID)
  • Tolerance Unit (foreign key field is ToleranceUnitID)
  • Print Unit (foreign key field is PrintUnitID)

When I display the Measurement records in a grid and I want to display Unit related information, I can choose between Unit, Unit1 and Unit2 but have no way of knowing which one is which. In LightSwitch I could have named those related records as Unit, ToleranceUnit and PrintUnit...

Is there a way to do this in Radzen?

2

Hi @semafox,

No, there is no way to rename those in Radzen at the moment. How did you use to name those in LightSwitch? We may want to implement something similar in the future but are not that familiar with LightSwitch and most related resources are no longer available.

3

That feature were great! im struggeling often with finding the correct relationships when i have more than on with the same table names.

I think the only way is that we have a "FK Name" for columns that are involved in FK's. Perhaps in the "Infer" Page? And perhaps a filter to only show columns that are involved in FK's. Or a list with only this columns?!

image
image738×162 18.7 KB

Radzen must save the given "FK Name" and use it for future infers

Thomas

4

Or is it possible to simply use the Constraint Name? This name is unique is SQL Server.

CREATE TABLE [dbo].[PartnerPartner] (
[PartnerPartnerId] INT NOT NULL PRIMARY KEY IDENTITY
,[PartnerVonId] INT NOT NULL
,[PartnerZuId] INT NOT NULL
,[RechnungAnZentrale] BIT NULL DEFAULT (1)
,CONSTRAINT [PartnervonPartner] FOREIGN KEY ([PartnerVonId]) REFERENCES Partner ON DELETE CASCADE
,CONSTRAINT [PartnerzuPartner] FOREIGN KEY ([PartnerZuId]) REFERENCES Partner
)

5

If this can help, below is a video that illustrates:

  1. How Lightswitch lets us rename lookup objects
  2. How Lightswitch lets us use enumerated values.

I hope this helps.