I think it's due to the schema not being dbo
my tables are in a custom schema - i just tried creating them in dbo in a dummy database and blazor studio identified the relationships correctly
my copy of blazor studio does not pick up the following relationships correctly - it identifies theres a relationship but there's no drop down to select the 'label' field when generating CRUD pages (like in the screenshot i pasted above)
create schema test authorization dbo
go
/****** Object: Table [test].[child_table] Script Date: 5/11/2024 11:25:24 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [test].[child_table](
[id] [int] IDENTITY(1,1) NOT NULL,
[parent_id] [int] NOT NULL,
[child_code] [nchar](10) NOT NULL,
CONSTRAINT [PK_child_table] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [test].[grandchild_table] Script Date: 5/11/2024 11:25:24 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [test].[grandchild_table](
[id] [int] IDENTITY(1,1) NOT NULL,
[child_id] [int] NOT NULL,
[grandchild_code] [nchar](10) NOT NULL,
CONSTRAINT [PK_grandchild_table] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [test].[parent_table] Script Date: 5/11/2024 11:25:24 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [test].[parent_table](
[Id] [int] IDENTITY(1,1) NOT NULL,
[name] [nchar](10) NOT NULL,
CONSTRAINT [PK_parent_table] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [test].[child_table] ON
GO
INSERT [test].[child_table] ([id], [parent_id], [child_code]) VALUES (1, 1, N'strat_01 ')
GO
INSERT [test].[child_table] ([id], [parent_id], [child_code]) VALUES (2, 1, N'strat_02 ')
GO
INSERT [test].[child_table] ([id], [parent_id], [child_code]) VALUES (4, 2, N'strat_08 ')
GO
INSERT [test].[child_table] ([id], [parent_id], [child_code]) VALUES (3, 3, N'strat_04 ')
GO
SET IDENTITY_INSERT [test].[child_table] OFF
GO
SET IDENTITY_INSERT [test].[grandchild_table] ON
GO
INSERT [test].[grandchild_table] ([id], [child_id], [grandchild_code]) VALUES (1, 1, N'net_01 ')
GO
INSERT [test].[grandchild_table] ([id], [child_id], [grandchild_code]) VALUES (2, 2, N'net_02 ')
GO
SET IDENTITY_INSERT [test].[grandchild_table] OFF
GO
SET IDENTITY_INSERT [test].[parent_table] ON
GO
INSERT [test].[parent_table] ([Id], [name]) VALUES (1, N'project 1 ')
GO
INSERT [test].[parent_table] ([Id], [name]) VALUES (2, N'project 2 ')
GO
INSERT [test].[parent_table] ([Id], [name]) VALUES (3, N'project 3 ')
GO
SET IDENTITY_INSERT [test].[parent_table] OFF
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IX_child_table] Script Date: 5/11/2024 11:25:25 AM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_child_table] ON [test].[child_table]
(
[parent_id] ASC,
[child_code] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object: Index [IX_grandchild_table] Script Date: 5/11/2024 11:25:25 AM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_grandchild_table] ON [test].[grandchild_table]
(
[child_id] ASC,
[grandchild_code] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [test].[child_table] WITH CHECK ADD CONSTRAINT [FK_child_table_parent_table] FOREIGN KEY([parent_id])
REFERENCES [test].[parent_table] ([Id])
GO
ALTER TABLE [test].[child_table] CHECK CONSTRAINT [FK_child_table_parent_table]
GO
ALTER TABLE [test].[grandchild_table] WITH CHECK ADD CONSTRAINT [FK_grandchild_table_grandchild_table] FOREIGN KEY([child_id])
REFERENCES [test].[child_table] ([id])
GO
ALTER TABLE [test].[grandchild_table] CHECK CONSTRAINT [FK_grandchild_table_grandchild_table]
GO
