Search code examples
c#entity-frameworkasp.net-mvc-5

Many to Many Relationship Code First Identity


I'm trying to make a many to many relationship between a class and a User Identity, my code is as follows

Context:

public class ApplicationUser : IdentityUser
    {
        public virtual ICollection<Estacion> Estaciones { get; set; }
    }

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
{
    public ApplicationDbContext()
        : base("ApplicationDbContext")
    {            
    }
    public DbSet<Estacion> Estaciones { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Estacion>().HasMany(u => u.Usuarios).WithMany(e => e.Estaciones);
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
        base.OnModelCreating(modelBuilder);
    }
}
public class Estacion
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int NoEstacion { get; set; }
        public string Nombre { get; set; }
        public string RFC { get; set; }

        public virtual ICollection<ApplicationUser> Usuarios { get; set; }
    }

Controller

public ActionResult About()
        {
            //Busca la estacion con Id 12345
            using(ApplicationDbContext context = new ApplicationDbContext())
            {
                Estacion estacion = context.Estaciones.SingleOrDefault(e => e.NoEstacion == 12345);
                UserManager<ApplicationUser> UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new ApplicationDbContext()));
                var usuario = UserManager.FindByName("Ale");
                estacion.Usuarios = new List<ApplicationUser>() { usuario };
                context.SaveChanges();
                ViewBag.Message = "Datos guardados";
            }
            return View();
        }

Error:

Se produjo una excepción de tipo 'System.InvalidOperationException' en EntityFramework.dll pero no se controló en el código del usuario

Información adicional: No se puede definir la relación entre dos objetos porque están asociados a objetos ObjectContext diferentes.

The error says that they are in different contexts but only got one, what am I doing wrong?


Solution

  • "The error says that they are in different contexts but only got one"

    using(ApplicationDbContext context = new ApplicationDbContext())
    {
    
         UserManager<ApplicationUser> UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>
                  (new ApplicationDbContext()));
    }
    

    You have two instances of ApplicationDbContext here.

    Try

    public ActionResult About()
            {
                //Busca la estacion con Id 12345
                using(ApplicationDbContext context = new ApplicationDbContext())
                {
                    var estacion = context.Estaciones.SingleOrDefault(e => e.NoEstacion == 12345);
                    var userManager = new UserManager<ApplicationUser>
                           (new UserStore<ApplicationUser>(context));
                    var usuario = userManager.FindByName("Ale");
                    estacion.Usuarios = new List<ApplicationUser>() { usuario };
                    context.SaveChanges();
                    ViewBag.Message = "Datos guardados";
                }
                return View();
            }