我希望能在用户访问内容页面时更新UserContent表。我创建了一个控制器来尝试手动输入数据,但在实施此操作之前,我遇到了外键错误:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.UserContent_dbo.IdentityUser_ApplicationUserId". The conflict occurred in database "COMPILING_a6a38dac907c4816af896bbeb6cdaa55", table "dbo.IdentityUser", column 'Id'.
The statement has been terminated.
型号:
public class UserContent
{
public int ID { get; set; }
[Display(Name = "Times Visited")]
public int Visited { get; set; }
[Display(Name = "Rating")]
public byte Rating { get; set; }
[Display(Name = "Content Page")]
public int ContentID { get; set; }
[Display(Name = "User")]
public string ApplicationUserId { get; set; }
public virtual Content Content { get; set; }
public virtual ApplicationUser ApplicationUser { get; set; }
}
控制器:
private CompilingContext db = new CompilingContext();
private ApplicationDbContext db2 = new ApplicationDbContext();
public ActionResult Create([Bind(Include="ID,Visited,Rating,ContentID,ApplicationUserId")] UserContent usercontent)
{
if (ModelState.IsValid)
{
db.UserContent.Add(usercontent);
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.ApplicationUserId = new SelectList(db2.Users, "Id", "UserName", usercontent.ApplicationUserId);
ViewBag.ContentID = new SelectList(db.Contents, "ID", "Title", usercontent.ContentID);
return View(usercontent);
}