Error while Inserting data in loop pne by one using Entity Framework

Question

while inserting records in a loop The property "id" is part of the object's key information and cannot be modified

 secProductionRepository.Add(tblSecProduction);
 this.SaveChanges();

CODE

Controller : This is the Controller code from where i am calling method of Repository . Adding data into repository and calling function to insert. i think i have to initialize it every time with new keyword. But where should i do that.

SingleMaster objGetXMLData = _iSingleService.GetXMLData();
if (objGetXMLData._tblSecDoorXMLData != null)
{
    for (int totalCount = 0; totalCount < objGetXMLData._tblSecDoorXMLData.Count; totalCount++)
    {
        _tblSecDoorsProduction.txtTongue = singleDoorModel.txtTongue;
        _tblSecDoorsProduction.numFibMesh = Convert.ToInt32(singleDoorModel.chkBoxFibreMesh);
        _tblSecDoorsProduction.dteDesDate = DateTime.Now;
        _iSingleDoorService.UpdatetblSecDoorsProduction(_tblSecDoorsProduction, "Insert");
    }
}

Repository : Here i am inserting new row into the table

public void UpdatetblSecDoorsProduction(tblSecDoorsProduction  tblSecDoorsProduction, string Message)
{
    var secDoorsProductionRepository =   Nuow.Repository<tblSecDoorsProduction>();
    tblSecDoorsProduction alreadyAttached = null;
    if (Message == "Insert")
    {
        secDoorsProductionRepository.Add(tblSecDoorsProduction);
        Nuow.SaveChanges();
    }
}

var secDoorsProductionRepository = Nuow.Repository<tblSecDoorsProduction>(); secDoorsProductionRepository.Add(tblSecDoorsProduction); Nuow.SaveChanges(); — Jasbeer Singh
– Jasbeer Singh, Commented Jan 18, 2016 at 12:38
Could you show the whole code, as dawidr already mentioned? Where is the Loop? Are you creating a new repository in the Loop? We can't see anything :-D — Marc
– Marc, Commented Jan 18, 2016 at 12:41
After insering one record, When it comes to next it throws error Something Like this — Jasbeer Singh
– Jasbeer Singh, Commented Jan 18, 2016 at 12:42

Dawid Rutkowski · Accepted Answer · 2016-01-18 13:39:05Z

1

Create new object each time in the loop. Updated code here:

for (int totalCount = 0; totalCount < objGetXMLData._tblSecDoorXMLData.Count; totalCount++)
{
    tblSecDoorsProduction _tblSecDoorsProduction = new tblSecDoorsProduction();
    _tblSecDoorsProduction.txtTongue = singleDoorModel.txtTongue;
    _tblSecDoorsProduction.numFibMesh = Convert.ToInt32(singleDoorModel.chkBoxFibreMesh);
    _tblSecDoorsProduction.dteDesDate = DateTime.Now;
    _iSingleDoorService.UpdatetblSecDoorsProduction(_tblSecDoorsProduction, "Insert");
}

answered Jan 18, 2016 at 13:39

Dawid Rutkowski

2,7561 gold badge30 silver badges41 bronze badges

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

1 Comment

Jasbeer Singh Over a year ago

Thanks dawidr .. worked for me. I had created object outside loop.

Collectives™ on Stack Overflow

Error while Inserting data in loop pne by one using Entity Framework

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related