getting error in datamodel in mvc4

vidhya

13y3.4k.NET

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'.

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
ok. good

Regards,
Iftikar
vidhya13y ago
i found it, i removed that , its working fine now. thanks.
Iftikar Hussain13y ago
I can see there are some duplicate datamodel. Can you delete this datamodel and recreate again?

Regards,
Iftikar
vidhya13y ago
i have shared my datamodel
Iftikar Hussain13y ago
can you share your data model?

Regards,
Iftikar
vidhya13y ago
s i have been loaded. but i am getting the error. i cant able to identify what wrong i did.
Iftikar Hussain13y ago
Have you load all these four table in your datamodel?

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

Regards,
Iftikar
vidhya13y ago
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.
vidhya13y ago
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 Hussain13y ago
your table is fine. How you are calling your sql query from MVC?

Regards,
Iftikar
vidhya13y ago
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 Hussain13y ago
Hi,
Can you provide more details? Where exactly you are getting this error?

Regards,
Iftikar