error while adding values into database

i cannot find the table name TestQuestionShort for mapping

Error1Error 3005: Problem in mapping fragments starting at lines 2161, 2179, 2186:Must specify mapping for all types in Set TestQuestion.

An Entity with Key (PK) will not round-trip when:

Entity is type [Edu2Model.TestQuestion]

D:\MavinLMS\MavinLMSDAL\DataModels\EduDataModel.edmx216215MavinLMSDAL

Error2Error 3005: Problem in mapping fragments starting at lines 2161, 2179, 2186:Must specify mapping for all types in Set TestQuestion.

An Entity with Key (PK) will not round-trip when:

Entity is type [Edu2Model.TestQuestionShort]

D:\MavinLMS\MavinLMSDAL\DataModels\EduDataModel.edmx216215MavinLMSDAL

13y ago

No. No inheritance set to TestQuestionShort and TestQuestion.

Iftikar Hussain13y ago

yes

Regards,
Iftikar

vidhya13y ago

-- Creating table 'TestQuestion_TestQuestionShort'

CREATE TABLE [dbo].[TestQuestion_TestQuestionShort] (

[TestQuestionId] uniqueidentifier NOT NULL

);

-- Creating primary key on [TestQuestionId] in table 'TestQuestion_TestQuestionShort'

ALTER TABLE [dbo].[TestQuestion_TestQuestionShort]

ADD CONSTRAINT [PK_TestQuestion_TestQuestionShort]

PRIMARY KEY CLUSTERED ([TestQuestionId] ASC);

-- Creating foreign key on [TestQuestionId] in table 'TestQuestion_TestQuestionShort'

ALTER TABLE [dbo].[TestQuestion_TestQuestionShort]

ADD CONSTRAINT [FK_TestQuestionShort_inherits_TestQuestion]

FOREIGN KEY ([TestQuestionId])

REFERENCES [dbo].[TestQuestion]

([TestQuestionId])

ON DELETE NO ACTION ON UPDATE NO ACTION;

Is this dispalying correctly according to the query

13y ago

Right click in the EDMX-->Add Entity -->Base type should be TestQuestion and follow the wizard.

Iftikar Hussain13y ago

is it possible for you provide the complete project?

Regards,
Iftikar

vidhya13y ago

I deleted ,how do i create a new class with inheritance from TestQuestion.

vidhya13y ago

i tried like this

-- Creating foreign key on [TestQuestionId] in table 'TestQuestion_TestQuestionShort'

ALTER TABLE [dbo].[TestQuestion_TestQuestionShort]

ADD CONSTRAINT [FK_TestQuestionShort_inherits_TestQuestion]

FOREIGN KEY ([TestQuestionId])

REFERENCES [dbo].[TestQuestion]

([TestQuestionId])

ON DELETE NO ACTION ON UPDATE NO ACTION;

I get error:
Cannot find the object "dbo.TestQuestion_TestQuestionShort" because it does not exist or you do not have permissions.

13y ago

Delete TestShortQuestion from the model and create a new class with inheritance from TestQuestion.

13y ago

In your repository code, AddQuestion method will support TestQuestion or any child of TestQuestion.

Please let me know, if you not clear.

vidhya13y ago

Iftikar,

I cant inherit testquestionblank. i can inherit testquestion.

inheritance is missing in the datamodel for testquestionshort. How can i inherit it.

13y ago

It won't work, because TestQuestionBlank is a type (or you can say sub-type) of TestQuestion via inheritance. But, TestQuestionShort is a separate entity and it does not have any relationshipt with TestQuestion class.

vidhya13y ago

Murali,

You did not understand what i am telling.

Same code work for testquestionblank. but not working testquestionshort .

If u observe clearly means u can identify the sql query format is same but name changed in short instead of blank. but i get different diagram in datamodel why?

Iftikar Hussain13y ago

you can't modify directly TestQuestionShort model. instead create your own a datamodel and inherit TestQuestionBlank

Regards,
Iftikar

13y ago

I am not sure because I'm not very familiar with your model.
If you want to try, just inherit TestQuestionBlank from TestQuestionShort otherwise create a new one.

vidhya13y ago

so only i told that some problem in model.

i replied before itself.

I need to display the TestQuestionShort data model like TestQuestionBlank. What i want to do?

if i changed datamodel like testquestionblank, error will be resolved.

13y ago

Hi Vidya,

TestQuestionBlank is inherited from TestQuestion that why the model has --> TestQuestion in the diagram. Because of the inheritance, the image or the model looks different but should be able to access all the properties from TestQuestion to TestQuestionBlank.

Properties Section:
All the properties of TestQuestion will be inherited to TestQuestionBlank. Parent class is TestQuestion and Child class TestQuestionBlank.

If you add properties to TestQuestionBlank that will not be available to TestQuestion.

Navigation Properties:
Navigation properties is used to navigate to parent collection by using navigation properites.
If you look at TestQuestionShort it has the navigation properties for TestQuestion. Based on the TestQuestionId you should be able to fetch all the TestQuestion.

Please let me know, if you're not clear.

Iftikar Hussain13y ago

you said in earlier post that

I need to display the TestQuestionShort data model like TestQuestionBlank

what exactly you want

Regards,
Iftikar

vidhya13y ago

I did not understand what you are saying.

Iftikar Hussain13y ago

how can you display TestQuestionShort without any attribute in your datamodel as it contain column

Regards,
Iftikar

vidhya13y ago

using this query

USE [Edu2]

GO

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestQuestionShort_TestQuestion]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestQuestionShort]'))

ALTER TABLE [dbo].[TestQuestionShort] DROP CONSTRAINT [FK_TestQuestionShort_TestQuestion]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionShort] Script Date: 07/30/2013 10:07:32 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestQuestionShort]') AND type in (N'U'))

DROP TABLE [dbo].[TestQuestionShort]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionShort] Script Date: 07/30/2013 10:07:47 ******/

SET ANSI_NULLS ON

GO

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

Iftikar Hussain13y ago

how did you create TestQuestionShort datamodel?

Regards,
Iftikar

vidhya13y ago

I need to display the TestQuestionShort data model like TestQuestionBlank. What i want to do?

If i get the solution for this problem, i can resolve the error.

vidhya13y ago

public class ShortAnswerQuestionModel : QuestionModel

{

public IList Answers { get; set; }

public override string QuestionTypeString

{

get

{

return "Short Answer";

}

///

/// Represents a view model for a short question ANSWER

///

public class ShortAnswerModel

{

public Guid TestQuestionShortAnswerId { get; set; }

public Guid TestQuestionId { get; set; }

[Display(Name = "Answer")]

[DataType(System.ComponentModel.DataAnnotations.DataType.Text)]

public string Answer { get; set; }

}

Iftikar Hussain13y ago

can you share this model (view)?

Regards,
Iftikar

vidhya13y ago

public class ShortAnswerQuestionModel : QuestionModel
{
}

It Represents a view model for a Short answer question.

Iftikar Hussain13y ago

I am not able to find ShortAnswerQuestionModel in your data model

Regards,
Iftikar

vidhya13y ago

This my sql query for TestQuestionBlank,TestQuestionShort

I created the table TestQuestionShort from TestQuestionBlank by changingshort instead of blank. thats it, but i get different diagram in datamodel.

USE [Edu2]

GO

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestQuestionShort_TestQuestion]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestQuestionShort]'))

ALTER TABLE [dbo].[TestQuestionShort] DROP CONSTRAINT [FK_TestQuestionShort_TestQuestion]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionShort] Script Date: 07/30/2013 10:07:32 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestQuestionShort]') AND type in (N'U'))

DROP TABLE [dbo].[TestQuestionShort]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionShort] Script Date: 07/30/2013 10:07:47 ******/

SET ANSI_NULLS ON

GO

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

IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TestQuestionBlank_TestQuestion]') AND parent_object_id = OBJECT_ID(N'[dbo].[TestQuestionBlank]'))

ALTER TABLE [dbo].[TestQuestionBlank] DROP CONSTRAINT [FK_TestQuestionBlank_TestQuestion]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionBlank] Script Date: 07/30/2013 10:08:57 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TestQuestionBlank]') AND type in (N'U'))

DROP TABLE [dbo].[TestQuestionBlank]

GO

USE [Edu2]

GO

/****** Object: Table [dbo].[TestQuestionBlank] Script Date: 07/30/2013 10:09:12 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[TestQuestionBlank](

[TestQuestionId] [uniqueidentifier] NOT NULL,

CONSTRAINT [PK_TestQuestionBlank] 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].[TestQuestionBlank] WITH CHECK ADD CONSTRAINT [FK_TestQuestionBlank_TestQuestion] FOREIGN KEY([TestQuestionId])

REFERENCES [dbo].[TestQuestion] ([TestQuestionId])

GO

ALTER TABLE [dbo].[TestQuestionBlank] CHECK CONSTRAINT [FK_TestQuestionBlank_TestQuestion]

GO

I need to display the TestQuestionShort table like TestQuestionBlank. What i want to do?

vidhya13y ago

Iftikar,
I have already posted the code. please refer the above or specify the line.

If i use this also
TestQuestion foo = new TestQuestion { TestId = Guid.NewGuid() };

I am getting the error.

Object reference not set to an instance of an object.

vidhya13y ago

Iftikar Hussain13y ago

can you share the code from where you are calling this data model object?

Regards,
Iftikar

13y ago

Try to change the extension to edmx to txt and rar /zip and upload.

vidhya13y ago

I cant able to upload the file, some issues in this website

13y ago

We need to see the class hierarchy and relationship.So that, we help you to fix the issue quicker.

13y ago

Is it possible for you to share the EDMX diagram / image instead of edmx file? I don't have visual studio also....

Iftikar Hussain13y ago

try like this

TestQuestion foo = new TestQuestion { TestId = Guid.NewGuid() };

Regards,
Iftikar

vidhya13y ago

I think there is some wrong in data model is it?

vidhya13y ago

If i change the code to "TestQuestion" it shows error

"Object reference not set to an instance of an object."

Line 450:                TestQuestionShortAnswer v = new TestQuestionShortAnswer { TestQuestionId = foo.TestQuestionId, TestQuestionShortAnswerId = Guid.NewGuid(), Answer = x.Answer }; Line 451: Line 452:                _testQuestionshorterRepo.AddShortAnswer(v);

vidhya13y ago

I have attached data model for your reference. Any wrong in that?

Iftikar Hussain13y ago

Hi,
Try like this

public bool QuestionCreateShortAnswerSaveView(ShortAnswerQuestionModel m)

{

if (_modelState.IsValid == false)

return false;

TestQuestion foo = new TestQuestion { TestQuestionId = Guid.NewGuid() };

CopyQuestionVmToEF(m, foo);

Regards,
Iftikar

13y ago

You need to change your code,because, your AddQuestion method expects parameter type of TestQuestion and you're passing TestQuestionShort.

vidhya13y ago

Is this correct r i need to change any?

13y ago

It looks like, in the following statement you're passing ("foo" object) which is a type of TestQuestionShort and not TestQuestion.

Please check it out once.

TestQuestionShort foo = new TestQuestionShort { TestQuestionId = Guid.NewGuid() };
_testQuestionRepo.AddQuestion(foo);

vidhya13y ago

public class ShortAnswerQuestionModel : QuestionModel

{

public IList Answers { get; set; }

public override string QuestionTypeString

{

get

{

return "Short Answer";

}

///

/// Represents a view model for a short question ANSWER

///

public class ShortAnswerModel

{

public Guid TestQuestionShortAnswerId { get; set; }

public Guid TestQuestionId { get; set; }

[Display(Name = "Answer")]

[DataType(System.ComponentModel.DataAnnotations.DataType.Text)]

public string Answer { get; set; }

}

vidhya13y ago

REPSITORY
public void AddQuestion(TestQuestion testToSave)

{

_context.TestQuestion.AddObject(testToSave);

_context.SaveChanges();

}

SERVICE

public ShortAnswerQuestionModel QuestionCreateShortAnswerBuildView(Guid testId)

{

ShortAnswerQuestionModel x = new ShortAnswerQuestionModel { TestId = testId };

x.ListNumber = _testRepo.GetQuestionNextListNumber(testId);

x.Answers = new List();

x.Answers.Add(new ShortAnswerQuestionModel.ShortAnswerModel { Answer = "" });

return x;

}

public bool QuestionCreateShortAnswerSaveView(ShortAnswerQuestionModel m)

{

if (_modelState.IsValid == false)

return false;

TestQuestionShort foo = new TestQuestionShort { TestQuestionId = Guid.NewGuid() };

CopyQuestionVmToEF(m, foo);

_testQuestionRepo.AddQuestion(foo);

if (m.Answers.Count == 0)

{

this._modelState.AddError("Question", "You must supply at least 1 answer");

return false;

}

foreach (ShortAnswerQuestionModel.ShortAnswerModel aa in m.Answers)

{

if (string.IsNullOrEmpty(aa.Answer) == true)

{

//TODO: fix this hack.

this._modelState.AddError("Question", "You must specify an answer");

return false;

}

//creating an special answers

foreach (ShortAnswerQuestionModel.ShortAnswerModel x in m.Answers)

{

TestQuestionShortAnswer v = new TestQuestionShortAnswer { TestQuestionId = foo.TestQuestionId, TestQuestionShortAnswerId = Guid.NewGuid(), Answer = x.Answer };

_testQuestionshorterRepo.AddShortAnswer(v);

}

_testRepo.UpdateTestDenormalizedData(m.TestId);

return true;

}

13y ago

It looks like, the entityset has TestQuestion, and you're passing TestQuestionShort. Please post your portion of your code to help you quickly.

error while adding values into database

The EntitySet, 'TestQuestion', from the entity's EntityKey does not match the entity's type, 'DataModels.TestQuestionShort'.
Parameter name: entity

47 Replies

Object reference not set to an instance of an object.

error while adding values into database

The EntitySet, 'TestQuestion', from the entity's EntityKey does not match the entity's type, 'DataModels.TestQuestionShort'.Parameter name: entity

Object reference not set to an instance of an object.

The EntitySet, 'TestQuestion', from the entity's EntityKey does not match the entity's type, 'DataModels.TestQuestionShort'.
Parameter name: entity