How to implement CRUD for the table with foreign key

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=newEntityC();
//IassumeyourAId,BId,CIdareauto-incrementcolumns,suchasIdentityintcolumnsononeedofgivingavalue
cRecord.EntityA=newEntityA
{
AName="MyNameforA",
ADescription="DescriptionforA"
};
cRecord.EntityB=newEntityB
{
BName="MyNameforB",
BDescription="DescriptionforB"
};
dbContext.TableC.Add(cRecord);
dbContext.SaveChanges();
//becauseEntityAandEntityBareforeignkeysreferenced,soEntityFrameworkwillautomaticallypopulatethedataaslongasthecolumns&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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.