I have a problem with the solution of the error Collection was modified, enumeration operation may not execute. It occurs when "author" and "z" suggests the same element.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.Entity;
namespace ConsoleApplication1
{
public class Nation
{
public int ID { get; set; }
public int name { get; set; }
public virtual ICollection<NationAlly> NationAllys { get; set; }
}
public class NationAlly
{
public int ID { get; set; }
public int level { get; set; }
public Nation Natio { get; set; }
}
public class NationsContext : DbContext
{
public DbSet<Nation> Nations { get; set; }
public DbSet<NationAlly> NationAllys { get; set; }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Nation>()
.HasMany(n => n.NationAllys)
.WithRequired()
.Map(conf => conf.MapKey("OwnerID"))
.WillCascadeOnDelete(false);
modelBuilder.Entity<NationAlly>()
.HasRequired(a => a.Natio)
.WithMany()
.Map(conf => conf.MapKey("UserID"))
.WillCascadeOnDelete(false);
}
}
class Program
{
static void Main(string[] args)
{
using (var context = new NationsContext())
{
// We have three Nations and two Allies
Nation nation1 = new Nation()
{
name = 1
};
Nation nation2 = new Nation()
{
name = 2
};
Nation nation3 = new Nation()
{
name = 3
};
context.Nations.Add(nation1);
context.Nations.Add(nation2);
context.Nations.Add(nation3);
context.SaveChanges();
}
using (var context = new NationsContext())
{
Nation z = (from x in context.Nations
where x.name == 1
select x).FirstOrDefault();
Nation author = (from x in context.Nations
where x.name == 1
select x).ToList().FirstOrDefault();
NationAlly ally1 = new NationAlly()
{
Natio = author
};
// toNation of ally1 refers to Nation2
// ally1.User = author;
if (z.NationAllys != null)
{
z.NationAllys.Add(ally1);
}
else
{
z.NationAllys = new List<NationAlly>();
z.NationAllys.Add(ally1);
}
context.SaveChanges();
}
}
}
}
I tested the code on Entity Framework 4.1 and 5
It works if you add the ally1
to the context immedately after you've created it:
//...
NationAlly ally1 = new NationAlly()
{
Natio = author
};
context.NationAllys.Add(ally1);
//...
The problem has to do with the circular reference you have in your special case...
z -> z.NationAllys contains ally1 -> ally1 refers to author = z
...and is likely related to this one:
EF 4.1 and "Collection was modified; enumeration operation may not execute." exception
I can't really explain it, but it looks like an EF bug to me as your code should work without problems.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With