Need help using entities for ASP.NET MVC 2 framework

Question

I'm making a site in ASP.NET MVC 2 using C#. I designed a database with a bunch of tables that have many to many relationships, similar to the following:

GrandParent - many to many - Parent

and

Parent - many to many - Child

I used the Entity Framework to make all of the entities class and am now working on a function in a repository class which adds a GrandParent.

It tries to create Child, add it to a Parent, then add the parent to a GrandParent and then add the GrandParent to the database by using the command

entities.GrandParents.AddObject(newGrandParent);
entities.SaveChanges();

It crashes on the SaveChanges() line with the error:

Unable to update the EntitySet 'JunctionPartentsChilds' because it has a DefiningQuery and no element exists in the ModificationFunctionMapping element to support the current operation.

EDIT: I can fix that error by deleting all of the DefiningQuery elements in the auto generated code and now I'm getting an error on the same line that should be more descriptive but I'm still at a loss.

The error is: Invalid object name 'JunctionPartentsChilds' and it throws a UpdatingException.

Any ideas what's going wrong? Do you have to add to the database in a special order because of the many to many relationships?

Thanks!!

Sounds like a weird DB schema. Do all your tables have real PKs and FKs? Do you use any views or procs? You shouldn't get DefiningQuery with proper schemata. — Craig Stuntz
– Craig Stuntz, Commented Jul 22, 2010 at 17:18
Please add/elaborate on your DB schema and the relations between them. If your schema is correct then its the way you are adding thats incorrect. At the first guess it seems you are adding the object in the wrong order/way. — renegadeMind
– renegadeMind, Commented Jul 23, 2010 at 9:28

RyanHennig · Accepted Answer · 2010-08-19 00:27:31Z

1

If you copy/pasted this error: Invalid object name 'JunctionPartentsChilds'

Maybe the problem is the misspelling of "Parents" in the junction table name

answered Aug 19, 2010 at 0:27

RyanHennig

1,0729 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thomas Poth · Accepted Answer · 2010-07-22 15:56:13Z

0

Your description looks like to one to many relationsships. But anyway, please post your code fragment here, to see if there's an error in your statements. Bye Thomas P.S. Ther's a wonderful way to format your code like this

This is a line of code

if you klick the button with the 101

answered Jul 22, 2010 at 15:56

Thomas Poth

831 silver badge4 bronze badges

Comments

Rony · Accepted Answer · 2010-08-19 00:29:03Z

0

make sure that GrandParents table as a primarykey(identity) and rebuild the model

answered Aug 19, 2010 at 0:29

Rony

9,5392 gold badges24 silver badges22 bronze badges

Collectives™ on Stack Overflow

Need help using entities for ASP.NET MVC 2 framework

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related