C#•3y ago

❔ How i can solve that in entityframworkcore

Unhandled exception. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Employees_Departments_DepartmentID". The conflict occurred in database "secondbase", table "dbo.Departments", column 'DepartmentID'.

hh1.86KB

JakenVeina•10/3/23, 11:59 PM

the error indicates that you are inserting an emplyoee for a department that doesn't exist

JJakenVeina the error indicates that you are inserting an emplyoee for a department that doe...

eidOP•10/4/23, 12:10 AM

sorry, i can't understand what do u mean, the code is:
using (mydbcontext context=new mydbcontext())//using()block for disbosing(removing unmanged resource)
{
Department dp1=new Department(){name="engineering"};
Department dp2=new Department(){name="Hr"};

Employee emp=new Employee(){fname="ahmed",lastname="eid",address="alex"};

context.Departments.Add(dp1);//or
context.Add(dp2);
context.Add(course);
context.Employees.Add(emp);
context.SaveChanges();

JakenVeina•10/4/23, 12:11 AM

yes, you posted that

JakenVeina•10/4/23, 12:12 AM

where does the exception throw?