thses are my database codes :

CREATE TABLE University( UniversityID int NOT NULL IDENTITY, UniversityName nvarchar(100) NOT NULL, PRIMARY KEY (UniversityID) )

CREATE TABLE Enstitute( EnstituteID int NOT NULL IDENTITY, UniversityID int NOT NULL, EnstituteName nvarchar(100), PRIMARY KEY (EnstituteID), FOREIGN KEY (UniversityID) REFERENCES University(UniversityID) )

My problem when i add data that user inputs, i write same university name but in the database records same university names saved with different UniversityID . 1 enstitute have 1 university and 1 university have more than one enstitute. When i select a university , if university is selected before, i want save to same UniversityID (foreign key) to Enstitute table , not new Foreign key ID. Can someone help me?

en. EnstituteName = enstituteBox.Text; //entitute name input uni.UniversityName = universityBox. Text; //university name input 1 Results i Messages UniversityID UniversityName 1 Maltepe Universitesi 2 Boazii niversitesi 3 Maltepe niversitesi 2 3 db.Enstitute.Add(en); db. University.Add(uni); db.SaveChanges(); //execute Enstituteld UniversityID 1 1 1 Enstitute Name Fen bilimleri Ankara ehir hastanesi Tip fakltesi 2 2 2 3 3 3