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?
"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();
}