Replicate / Copy elements from multiple tables

Question

Replicate / Copy elements from multiple tables

Navigation

#1 by (1 votes)

6

I have the following situation: The user has defined an establishment, where it has filled data in two tables, and wants to replicate / copy the data all the same, changing only the id of the establishment. I have the tables:

ThetableAcidImpureza_Tblidad_tblorAIHasIhaveintheproject,receivestheServicosIDfromtheServicostableasaforeignkey.

Inmyfunctiontoreplicate/copythedata,Igetanintegerthatcontainstheidoftheestablishment(idServicoIDSelected)thatIwillcopyandalistwiththeid'softheestablishments(listStab)tocopy:

[AcceptVerbs(HttpVerbs.Get)]publicJsonResultCriarCopiarEstab(List<int>listaEstab,intidServicoIDSelected,stringserie,intnumDoc){try{vardados=db.DadosComerciais.Where(d=>d.Serie==serie&&d.NumDoc==numDoc).FirstOrDefault();varservico=db.Servicos.Find(idServicoIDSelected);varaih=db.AIH.Where(a=>a.ServicosID==servico.ServicosID).ToList();foreach(variteminlistaEstab){varnewServico=newServicos();newServico=servico;newServico.DadosComerciais=db.DadosComerciais.Find(serie,numDoc);db.Servicos.Add(newServico);db.SaveChanges();varnewAih=newList<AIH>();foreach(varitem2inaih){varnewElementoAih=newAIH();newElementoAih.AcidezDesconto=item2.AcidezDesconto;newElementoAih.AcidezMax=item2.AcidezMax;newElementoAih.AcidezTaxaExtraEur=item2.AcidezTaxaExtraEur;//newElementoAih=item2;//TAMBEMJÁEXPERIMENTEIASSIMdb.AIH.Add(newElementoAih);db.SaveChanges();}}returnJson(JsonRequestBehavior.AllowGet);}catch(Exceptionex){returnJson(new{Result="ERROR", Message = ex.Message }, JsonRequestBehavior.AllowGet);
        }
    }

Where do I get the problem? I am not able to replicate the data, go get the servicosID corresponding to insert in the AIH table. If replicating only the Services table works fine, now if I start copying the lists I always get the error:

InvalidOperationException was caught The changes to the database were committed successfully, but an error occurred while updating the context object. The ObjectContext might be in an inconsistent state. Inner exception message: 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.

c# entity-framework asp.net-mvc

asked by anonymous 16.04.2014 / 11:03

1 answer

Spring MVC + Joda Time + @DateTimeFormat How to solve the medium trust problem in asp.net

score 1 · Answer 1

This setting:

var newServico = new Servicos();
newServico = servico;
newServico.DadosComerciais = db.DadosComerciais.Find(serie, numDoc);

You're wrong. You are defining two objects of type Servicos with the same ServicoID . The Entity Framework understands that they are two different objects, but SQL Server understands that the objects are the same.

I do not know how your bank schema is, but the code assuming the use of Identity in the ServicoID column is more or less like this:

var newServico = new Servicos();
newServico.NumDocumento = servico.NumDocumento;
newServico.Serie = servico.Serie;
newServico.DadosComerciais = db.DadosComerciais.Find(serie, numDoc);
// Preencha as demais properties manualmente. Não preencha ServicoID

db.Servicos.Add(newServico);
db.SaveChanges();