I have two tables in my database, one of departments and the other of employees, and an employee can only belong to one department so there is a departmentId in the employee that works as a foreign key of the department table referencing the id of that table, but when my api adds an employee when filling in departmentId, the value I filled in changes and the next value that has available in the id of the departments table is placed

the code i was using in the api was:

public async Task$>>$ CreateFuncionario$($Funcionario novoFuncionario$)$

$\{$

ServiceResponse$>$ serviceResponse $=$ new ServiceResponse$>()$;

try

$\{$

if $($novoFuncionario $==$ null$)$

$\{$

serviceResponse.Dados $=$ null;

serviceResponse.Mensagem $=$ "Informar Dados";

serviceResponse.Sucesso $=$ false;

return serviceResponse;

$\}$

$\_$context.Add$($novoFuncionario$)$;

await $\_$context.SaveChangesAsync$()$;

novoFuncionario $=$ await $\_$context.Funcionarios.FindAsync$($novoFuncionario$.$Id$)$;

serviceResponse.Dados $=\_$context.Funcionarios.ToList$()$;

$\}$

catch $($Exception ex$)$

$\{$

serviceResponse.Mensagem $=$ ex$.$Message;

serviceResponse.Sucesso $=$ false;

$\}$

return serviceResponse;

$\}$

i was inserting in api using:

$\{$

$"$id$"$: $0,$

"nome": $"$Jo$$o$",$

"foto": "string",

$"$rg$"$: $453454353,$

"departamentoId": $2,$

"departamento": $\{$

$"$id$"$: $0,$

"nome": "string",

"sigla": "string"

$\}$

$\}$

and the response was:

Response body

$\{$

"dados": $[$

$\{$

$"$id$"$: $1,$

"nome": $"$Jo$$o$",$

"foto": "string",

$"$rg$"$: $453454353,$

"departamentoId": $8,$

"departamento": $\{$

$"$id$"$: $8,$

"nome": "string",

"sigla": "string"

$\}$

$\}$

$],$

"mensagem": $"",$

"sucesso": true

$\}$