Hi There,
Just wondering if Radzen Blazor Studio latest versions are capable to handle Key-Less SQL Tables for its Automated Crud page creation? Or part of Master-Detail Crud Page creation?
For example, below is the code given for source tables. I'd like to see this in Master-Detail Hierarchy Crud, where T_DM_SCHEDULE_TYPES table represents the master and T_DM_MAPSCHEDULEJOB is the detail. Here as you see T_DM_MAPSCHEDULEJOB having no primary key, but 2 columns one of which is a Foreign key to the Primary Key (SCHEDULE_ID) of Master table i.e. T_DM_SCHEDULE_TYPES.
/***** Object: Table [dbo].[T_DM_SCHEDULE_TYPES] Script Date: 3/26/2024 6:12:10 PM *****/
/ MASTER TABLE /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[T_DM_SCHEDULE_TYPES](
- [SCHEDULE_ID] [int] IDENTITY(1,1) NOT NULL,*
- [SCHEDULE_DESCRIPTION] varchar NULL,*
- [START_CONDITION] varchar NULL,*
- [EXECUTION_ORDER] [int] NULL,*
- CONSTRAINT [Pk_T_DM_SCHEDULE_TYPES_SCHEDULE_ID] PRIMARY KEY CLUSTERED *
( - [SCHEDULE_ID] ASC*
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/**** Object: Table [dbo].[T_DM_MAPSCHEDULEJOB] Script Date: 3/26/2024 6:11:58 PM ****/
/ CHILD TABLE /
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[T_DM_MAPSCHEDULEJOB](
** [SCHEDULE_ID] [int] NULL,**
** [JOB_NAME] varchar NOT NULL**
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_DM_MAPSCHEDULEJOB] WITH CHECK ADD CONSTRAINT [FK_T_DM_MAPSCHEDULEJOB_SCHDULE_ID] FOREIGN KEY([SCHEDULE_ID])
REFERENCES [dbo].[T_DM_SCHEDULE_TYPES] ([SCHEDULE_ID])
GO
ALTER TABLE [dbo].[T_DM_MAPSCHEDULEJOB] CHECK CONSTRAINT [FK_T_DM_MAPSCHEDULEJOB_SCHDULE_ID]
GO