Zentity Data Extensibility User Guide Problems
Question
All replies
-
To fix the bug, you need to place one more variable to the Core.CretaeOrUpdateResourceType stored procedure. Please see the stored procedure file attached. The source of the bug is the dynamic stored procedure created in the Zentity.Core.SqlScriptGenerator class in the ../Product/Zentity.Core/DataModelling folder. The 8th parameter(configXML, see attached screenshot) has other dependencies, removing it will require changes in many other places.
USE [Zentity] GO /****** Object: StoredProcedure [Core].[CreateOrUpdateResourceType] Script Date: 10/06/2011 14:24:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [Core].[CreateOrUpdateResourceType] @Id UNIQUEIDENTIFIER, @DataModelModuleId UNIQUEIDENTIFIER, @BaseTypeId UNIQUEIDENTIFIER, @Name NVARCHAR (100), @Uri NVARCHAR (1024), @Description NVARCHAR (4000), @Discriminator INT, @configXml NVARCHAR (4000) AS BEGIN IF (SELECT COUNT(1) FROM [Core].[ResourceType] WHERE Id = @Id) = 0 BEGIN INSERT INTO [Core].[ResourceType] ([Id] ,[DataModelModuleId] ,[BaseTypeId] ,[Name] ,[Uri] ,[Description] ,[Discriminator]) VALUES (@Id ,@DataModelModuleId ,@BaseTypeId ,@Name ,@Uri ,@Description ,@Discriminator); END ELSE BEGIN UPDATE [Core].[ResourceType] SET [DataModelModuleId] = @DataModelModuleId ,[BaseTypeId] = @BaseTypeId ,[Name] = @Name ,[Uri] = @Uri ,[Description] = @Description ,[Discriminator] = @Discriminator WHERE [Id] = @Id END -- Update the max discriminator value. DECLARE @MaxDiscriminator [int]; DECLARE @ConfigurationExists [bit]; SELECT @ConfigurationExists = 1, @MaxDiscriminator = [ConfigValue] FROM [Core].[Configuration] WHERE [ConfigName] = 'MaxDiscriminator'; IF @ConfigurationExists IS NULL BEGIN INSERT INTO [Core].[Configuration] SELECT 'MaxDiscriminator', CASE WHEN MAX([Discriminator]) > @Discriminator THEN MAX([Discriminator]) ELSE @Discriminator END FROM [Core].[ResourceType]; END ELSE BEGIN UPDATE [Core].[Configuration] SET [ConfigValue] = CASE WHEN CAST([ConfigValue] AS [int]) > @Discriminator THEN [ConfigValue] ELSE @Discriminator END WHERE [ConfigName] = 'MaxDiscriminator'; END END
