Foreign Key Issues

Question

Hi Guys,

 

I am currently learning MVC/ Entity Framework. I getting an issue when I am trying to insert a Id to the database. Here are my models below including my controller/view

 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.ResturantReviews_dbo.Resturants_Resturant_Id". The conflict occurred in database "OdeToFoodDb", table "dbo.Resturants", column 'Id'.The statement has been terminated.

 

Model:

public class Resturant

{

public int Id { get; set; }

public string Name { get; set; }

public string City { get; set; }

public string Country { get; set; }

public virtual ICollection<ResturantReview> Reviews { get; set; }

}

 

public class ResturantReview

{

public int Id { get; set; }

public int Rating { get; set; }

public string Body { get; set; }

public string ReviewerName { get; set; }

public virtual int ResturantId { get; set; }

}

 

Controller:

OdeToFoodDb _db = new OdeToFoodDb();

public ActionResult Index(int id)

{

var restaurant = _db.Resturants.Find(id);

if (restaurant != null)

{

return View(restaurant);

}

return HttpNotFound();

}

[HttpGet]

public ActionResult Create(int restaurantId)

{

return View();

}

[HttpPost]

public ActionResult Create(ResturantReview review)

{

if (ModelState.IsValid)

{

_db.Reviews.Add(review);

_db.SaveChanges();

return RedirectToAction("Index", new { restaurantId = review.ResturantId });

}

return View(review);

}

protected override void Dispose(bool disposing)

{

_db.Dispose();

base.Dispose(disposing);

}