SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint

[ezra89]

I have a problem and I don't know why am I getting this bug.

CREATE TABLE Course(
    IdCourse int IDENTITY (1,1) NOT NULL PRIMARY KEY,
    NameCourse nvarchar(50) NOT NULL,
    Description nvarchar(250) NOT NULL,
    Date datetime NOT NULL,
    Full BIT NULL DEFAULT 0
)
 
CREATE TABLE Application
(
    IdApplication int IDENTITY (1,1) NOT NULL PRIMARY KEY,
    Date datetime NOT NULL,
    Name nvarchar(25) NOT NULL,
    Surname nvarchar(25) NOT NULL,
    Adress nvarchar(50) NOT NULL,
    Email nvarchar(320) NOT NULL,
    Telephone varchar(15) NOT NULL,
    IdCourse int FOREIGN KEY REFERENCES Course(IdCourse),
    Status INT not nulL
)
 
 
public ActionResult Application(int id)
        {
            ViewBag.Course = (
                from c in db.Course
                where c.IdCourse == id
                select s.NameCourse).FirstOrDefault();
            Application application = new Application();
            return View(application);
        }
 
[HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Application([Bind(Include = "IdApplication,Name,Surname,Adress,Email,Telephone")] Application application)
        {
            Course course = new course();
            application.IdCourse = course.IdCourse;
            int applicationId = application.IdApplication;
 
            if (ModelState.IsValid)
            {
                db.Applications.Add(Application);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
 
            return View(application);
        }
 

My view

@model Aplikacija.Models.Applicaton
 
@{
    <strong>@ViewBag.Course</strong>
}
 
 
@using (Html.BeginForm())
{
    @Html.AntiForgeryToken()
 
    <div class="form-horizontal"> <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })
        @Html.HiddenFor(model => model.IdApplication)
 
        <div class="form-group">
            @Html.LabelFor(model => model.Name, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Name, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Name, "", new { @class = "text-danger" })
            </div> </div> <div class="form-group">
            @Html.LabelFor(model => model.Surname, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Surname, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Surname, "", new { @class = "text-danger" })
            </div> </div> <div class="form-group">
            @Html.LabelFor(model => model.Address, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Address, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Address, "", new { @class = "text-danger" })
            </div> </div> <div class="form-group">
            @Html.LabelFor(model => model.Email, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Email, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Email, "", new { @class = "text-danger" })
            </div> </div> <div class="form-group">
            @Html.LabelFor(model => model.Telephone, htmlAttributes: new { @class = "control-label col-md-2" })
            <div class="col-md-10">
                @Html.EditorFor(model => model.Telephone, new { htmlAttributes = new { @class = "form-control" } })
                @Html.ValidationMessageFor(model => model.Telephone, "", new { @class = "text-danger" })
            </div> </div> <div class="form-group"> <div class="col-md-offset-2 col-md-10"> <input type="submit" value="Save" class="btn btn-primary" /> </div> </div> </div>
}
 
<div>
    @Html.ActionLink("Back to List", "Index")
</div>
 
@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

[zmbd]

SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint

Is that the full error message?

Typically, this would indicate that you have a value in the column for the foreign key reference to another table that is not also in the primary key column of the referenced table.

Without the full error message that's about as far as we can offer...

[ezra89]

I changed my HttpPost and there is no exception anymore. It just gives me new id of the Course table and I don't want that. I need to place it in the row that I chose in ViewBag from GET.

[HttpPost]
        [ValidateAntiForgeryToken]
        public ActionResult Application(Application application)
        {
            application.Course = new Course();
            if (ModelState.IsValid)
            {
                db.Applications.Add(application);
                db.SaveChanges();
                return RedirectToAction("Index");
            }
 
            ViewBag.Course = new SelectList(db.Courses, "IdCourse", "NameCourse", application.IdCourse);
            return View(application);
        }

Thank you for your reply.