importing data fromforeign key table into primary table in c#

Asjad Butt 71

Hi so this is let me explain there is a registration method with the properties id name, password and also a type field now this type field while registring is necessary but the user can enter a type he has to choose from one of three types which are defined in another table and are used a foregin key in the primary table now i need help in creating this functionallity where one of the input feild is being accessed from another table using foreign keys

Asjad Butt 71 Reputation points

2022-09-27T12:50:49.783+00:00

can't enter a type up there
Zhi Lv - MSFT 32,016 Reputation points Microsoft Vendor

2022-09-28T05:15:41+00:00

Hi @Asjad Butt ,

How do you configure the relationship between tables, directly using the SQL commands in the database or using EF core? And when insert the new items, whether you are directly execute the SQL commands or manage the data via DBContext? Please explain more detail about it.

Generally, the main table will contains a column to store the foreign key (for example: type id), if you directly using ADO.NET command to insert new items, before insert the new value, you should query the Type table and find the special type based on the type name, then get the type id, after that you can insert the new item with the type id. If you are using EF core, you can insert the primary key via the navigation property. Refer to Relationships and Saving Related Data.

Best regards,
Dillion