How to Update Multiple tables

Question

1.00/5 (2 votes)

See more:

how to update multiple tables in Entity Framework
each tables contains more than 30 columns

i am using below code its not work

C#

DBEntity_context = new DBEntity()
  _context.ConfiguredProducts.AttachAsModified<configuredproduct>(configuredProduct);

throws error referential contraint
~~solve as soon as~~.

Posted 14-May-14 21:43pm

Member 10458902

Updated 14-May-14 23:16pm

_Zorro_

v3

Add a Solution

Comments

phil.o 15-May-14 5:15am

Without knowing a mnimum about the schema involving the ConfiguredProducts table, as well as which table(s) are involved with it in a referential constraint, there is a quite small chance that anybody can help you with that.
Moreover, please post the exact error message, alongside with stack trace so that it is easier to figure out what's happening and where (despite I suspect your problem is that the configuredProduct references a primary key in another table that you did not insert yet).
If you want the quickest and most accurate answer, you have to provide details, but not, in any way, to urge us with an ASAP notification.

Member 10458902 15-May-14 6:34am

sorry the error
A referential integrity constraint violation occurred: The property values that define the referential constraints are not consistent between principal and dependent objects in the relationship.
ConfiguredProducts relation with number of tables

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)