getting error in datamodel in mvc4

Question

I am getting this error how to resolve this Schema specified is not valid. Errors: The relationship 'Edu2Model.FK_TestQuestion_Test' was not loaded because the type 'Edu2Model.TestQuestion' is not available. The following information may be useful in resolving the previous error: The required property 'TestQuestionShort' does not exist on the type 'MavinLMSDAL.DataModels.TestQuestion'.

Iftikar Hussain · Answer

ok. good Regards Iftikar

vidhya · Answer

i found it i removed that  its working fine now. thanks.

Iftikar Hussain · Answer

I can see there are some duplicate datamodel. Can you delete this datamodel and recreate again? Regards Iftikar

vidhya · Answer

i have shared my datamodel

Iftikar Hussain · Answer

can you share your data model? Regards Iftikar

vidhya · Answer

s i have been loaded. but i am getting the error. i cant able to identify what wrong i did.

Iftikar Hussain · Answer

Have you load all these four table in your datamodel? Regards Iftikar

Iftikar Hussain · Answer

are you using ADO.NET or Entity Framework? Regards Iftikar

vidhya · Answer

through datamodel. After creating this 2 tables TestQuestionShort and TestQuestionShortAnswer . i am getting the error so only i placed my sql query for your reference.

vidhya · Answer

USE [Edu2] GO /****** Object: Table [dbo].[TestQuestion] Script Date: 07/23/2013 10:54:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[TestQuestion]( [TestQuestionId] [uniqueidentifier] NOT NULL [TestId] [uniqueidentifier] NOT NULL [QuestionTitle] [nvarchar](255) NOT NULL [QuestionText] [nvarchar](max) NOT NULL [FeedbackCorrect] [nvarchar](max) NULL [FeedbackIncorrect] [varchar](max) NULL [InstructorNotes] [nvarchar](max) NULL [Points] [int] NOT NULL [ListNumber] [int] NOT NULL [ExtraCredit] [bit] NOT NULL [FileName] [nvarchar](255) NULL [FileData] [varbinary](50) NULL [WebLink] [nvarchar](255) NULL [LinkName] [nvarchar](255) NULL CONSTRAINT [PK_TestQuestion] PRIMARY KEY CLUSTERED ( [TestQuestionId] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[TestQuestion] WITH CHECK ADD CONSTRAINT [FK_TestQuestion_Test] FOREIGN KEY([TestId]) REFERENCES [dbo].[Test] ([TestId]) GO ALTER TABLE [dbo].[TestQuestion] CHECK CONSTRAINT [FK_TestQuestion_Test] GO

Iftikar Hussain · Answer

your table is fine. How you are calling your sql query from MVC? Regards Iftikar

vidhya · Answer

while running my application i am getting the above error.my sql query for your reference. USE [Edu2] GO /****** Object: Table [dbo].[TestQuestionShort] Script Date: 07/23/2013 09:54:12 ******/ SET ANSI_NULLS ON GO drop table [TestQuestionShort] SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TestQuestionShort]( [TestQuestionId] [uniqueidentifier] NOT NULL CONSTRAINT [PK_TestQuestionShort] PRIMARY KEY CLUSTERED ( [TestQuestionId] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TestQuestionShort] WITH CHECK ADD CONSTRAINT [FK_TestQuestionShort_TestQuestion] FOREIGN KEY([TestQuestionId]) REFERENCES [dbo].[TestQuestion] ([TestQuestionId]) GO ALTER TABLE [dbo].[TestQuestionShort] CHECK CONSTRAINT [FK_TestQuestionShort_TestQuestion] GO USE [Edu2] GO /****** Object: Table [dbo].[TestQuestionShortAnswer] Script Date: 07/23/2013 09:55:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TestQuestionShortAnswer]( [TestQuestionShortAnswerId] [uniqueidentifier] NOT NULL [TestQuestionId] [uniqueidentifier] NOT NULL [Answer] [nvarchar](50) NOT NULL CONSTRAINT [PK_TestQuestionShortAnswer] PRIMARY KEY CLUSTERED ( [TestQuestionShortAnswerId] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO

Iftikar Hussain · Answer

Hi Can you provide more details? Where exactly you are getting this error? Regards Iftikar