Bulk Insert IList<Entity> problems

???? Question : Why I can`t use BulkInsert method to insert all IList entities in my table but if I use Update method I can insert these entities with success ???? ----------------------------------------------------------------------------- Problem is : I try to insert a IList of Entities using the following method: 1) first way but without success: public bool InsertTubesList(IList tubesList, Sn_comenzi comanda, out string nrcda) { IDbTransaction trans = null; nrcda = string.Empty; if (tubesList.Count == 0) return false; trans = UnitOfWorkHolder.StartTransaction(); //Begin transaction nrcda = (String.IsNullOrEmpty(comanda.Nrcda)) ? (comanda.Nrcda = new Sn_comenzi_Controller().GetNrDoc(2, true)) : comanda.Nrcda; int counter = 0; for (int i = 0; i .Nrcda = nrcda; tubesList.Nrcrt = paddedValue; try { tubesList.BulkInsert(false); //OLD WAY --- CAN`T INSERT } catch { UnitOfWorkHolder.RollbackTransaction(trans); //Rollback transaction return false; } } try { UnitOfWork.SaveChanges() ; //OLD WAY --- CAN`T INSERT } catch { UnitOfWorkHolder.RollbackTransaction(trans); //Rollback transaction return false; } //Save command record try { comanda.Update(); } catch { UnitOfWorkHolder.RollbackTransaction(trans); //Rollback transaction return false; } UnitOfWorkHolder.CommitTransaction(trans); return true; } ...AND this did NOT save anything in Sn_cda_tuburi table from database. ...AND below I have bulk insert method: public void BulkInsert(bool Save) { if (Save) { UnitOfWork.SaveChanges(); return; } if (ValidateItem()) { if (this != null) { UnitOfWork.Add(this); } } } Using this way as before I don`t see any change in Sn_cda_tuburi table . there are NO new rows inserted in Sn_cda_tuburi table. ....................................................................... 2) second way WITH success IF I use the same method but with the following changes I can insert new rows in Sn_cda_tuburi table. there are new rows in this table. public bool InsertTubesList(IList tubesList, Sn_comenzi comanda, out string nrcda) { IDbTransaction trans = null; nrcda = string.Empty; if (tubesList.Count == 0) return false; trans = UnitOfWorkHolder.StartTransaction(); //Begin transaction nrcda = (String.IsNullOrEmpty(comanda.Nrcda)) ? (comanda.Nrcda = new Sn_comenzi_Controller().GetNrDoc(2, true)) : comanda.Nrcda; int counter = 0; for (int i = 0; i .Nrcda = nrcda; tubesList.Nrcrt = paddedValue; try { tubesList.Update(); //NEW WAY with SUCCESSFULLY INSERTED ROWS } catch { UnitOfWorkHolder.RollbackTransaction(trans); //Rollback transaction return false; } } //Save command record try { comanda.Update(); } catch { UnitOfWorkHolder.RollbackTransaction(trans); //Rollback transaction return false; } UnitOfWorkHolder.CommitTransaction(trans); return true; } My update method is: public void Update() { if (ValidateItem()) { if (this.EntityState == EntityState.New) { UnitOfWork.Add(this); } UnitOfWork.SaveChanges(); } } ... when I do not use BulkInsert but I use Update method I can save all my entities from IList in Sn_cda_tuburi table. private bool ValidateItem() { if (this.IsValid == true) { return true; } else { RaiseEventValidationEntered(); return false; } }

It looks like the BulkInsert method is not adding the entities to the unit of work (or at least not until *after* you call SaveChanges).  SaveChanges will only save entities that are part of the UOW, which requires one of the following:

* The entity was originally loaded from the database through the UOW

* The entity is a new entity and you have called IUnitOfWork.Add(entity) for it

* The entity is a new entity and it has been associated with another entity that is part of the UOW, for example by being added to a children collection

* The entity came from another UOW (e.g. in a previous Web request) and you have called IUnitOfWork.Attach(entity) to associate it with the current UOW.

Try changing your BulkInsert method to look something like this:

public void BulkInsert(IList entities)
{
  foreach (Entity entity in entities)
    UnitOfWork.Add(entity);
  UnitOfWork.SaveChanges();
}

Or just add each entity to the UOW as you create it.

Just to add the the above... if you stick with a BulkInsert method as opposed to adding as you go, and your list contains a mix of new and existing entities, then you will need to add an if (entity.EntityState == EntityState.New) guard clause around UnitOfWork.Add, just as in your Update method.