How to implement CRUD for the table with foreign key

Question

For example: I have 3 tables. 1) Table A ( AId AName ADescription ) 2) Table B (BId BName BDescription ) 3) Table C (CId AId BId CName CDescription ) I want to add record for Table C and how can I control for A and B? I am using entity framework and MVC5. Kindly let me know if anyone to implement CRUD for Table C. Thanks a lot for viewing my question.

Lida Weng · Answer

hi Not sure what you mean control for A and B but I hope the answer below covers your question: Add Just one record in C and auto-populate record on A and B: //AssumingEntityforTableAis:EntityA //AssumingEntityforTableBis:EntityB //AssumingEntityforTableCis:EntityC //AssumingDbContextiscalledDbContext EntityC cRecord= new EntityC(); //IassumeyourAIdBIdCIdareauto-incrementcolumnssuchasIdentityintcolumnsononeedofgivingavalue cRecord.EntityA= new EntityA { AName= MyNameforA  ADescription= DescriptionforA }; cRecord.EntityB= new EntityB { BName= MyNameforB  BDescription= DescriptionforB }; dbContext.TableC.Add(cRecord); dbContext.SaveChanges(); //becauseEntityAandEntityBareforeignkeysreferencedsoEntityFrameworkwillautomaticallypopulatethedataaslongasthecolumns&valuesarevalidforthosetables. The save action in the code last line will 1) populate EntityA in Table A 2) populate EntityB in Table B; then 3) populate EntityC in Table C the primary keys will be automatically populated as long as they are auto-incremental columns (such as Identity int column) Cheers.