SaveChanges in Entity Framework causes error Validation failed for one or more entities. See 'EntityValidationErrors'

Question

I have added the patient and visit tables in reg_visit table in Entity Framework 6.1 code-first but when run the below code, I get this error:

Validation failed for one or more entities. See 'EntityValidationErrors' property for more details.

Code:

Models.VisitDoctotDb oVisitdb = new Models.VisitDoctotDb();
Models.RegVisit oReg_visit = new Models.RegVisit();

oReg_visit.Patient = oPatient;
oReg_visit.Visit = oVisit;

oVisitdb.Reg_visit.Add(Reg_visit); ===> error
oVisitdb.SaveChanges();

add the try catch in this [answer](http://stackoverflow.com/a/7798264/1498624) to your code, go from there and if you can't solve it add the output to the question so we could help you better — grabthefish, Dec 13 '14 at 11:01

score 0 · Answer 1 · answered Dec 14 '14 at 05:54

if (oPatient) was already added to the database, you mustn't add oReg_visit to DB because it is already attached.

Models.VisitDoctotDb oVisitdb = new Models.VisitDoctotDb();
Models.RegVisit oReg_visit = new Models.RegVisit();

oReg_visit.Patient = oPatient;
oReg_visit.Visit = oVisit;


oVisitdb.SaveChanges();

this code should save your object to database

score 0 · Answer 2 · edited May 23 '17 at 12:28

0

If you use Entity Framework you can have a look at my answer on Solution for “Validation failed for one or more entities. See 'EntityValidationErrors' property for more details. Hope this helps...

edited May 23 '17 at 12:28

Community

1
1

answered Mar 13 '15 at 12:18

Murat Yıldız

10,459
6
58
60

SaveChanges in Entity Framework causes error Validation failed for one or more entities. See 'EntityValidationErrors'

2 Answers2