Exam AZ-203 topic 24 question 15 discussion

Actual exam question from Microsoft's AZ-203

Question #: 15
Topic #: 24

HOTSPOT -
You are working for a company that designs mobile applications. They maintain a server where player records are assigned to their different games. The tracking system is new and in development.
The application uses Entity Framework to connect to an Azure Database. The database holds a Player table and Game table.
When adding a player, the code should insert a new player record, and add a relationship between an existing game record and the new player record.
The application will call CreatePlayerWithGame with the correct gameIdand the playerId to start the process. (Line numbers are included for reference only.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer: Explanation
Many-to-many relationships without an entity class to represent the join table are not yet supported. However, you can represent a many-to-many relationship by including an entity class for the join table and mapping two separate one-to-many relationships. protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<PostTag>()
.HasKey(t => new { t.PostId, t.TagId });
modelBuilder.Entity<PostTag>()
.HasOne(pt => pt.Post)
.WithMany(p => p.PostTags)
.HasForeignKey(pt => pt.PostId);
modelBuilder.Entity<PostTag>()
.HasOne(pt => pt.Tag)
.WithMany(t => t.PostTags)
.HasForeignKey(pt => pt.TagId);
}
}

by Daltonic75 at March 12, 2020, 8:59 a.m.

Comments

Submit Cancel

Daltonic75

Highly Voted 5 years, 3 months ago

Repeated: https://www.examtopics.com/exams/microsoft/az-203/view/8/ Options: https://www.examtopics.com/assets/media/exam-media/02521/0004800001.jpg Check discussion answers in the first url.

upvoted 11 times

Raevex

4 years, 11 months ago

Correct Answer: Explanation Box 1: Yes - Box 2: No - Box 3: Yes - Box 4: No - Many-to-many relationships without an entity class to represent the join table are not yet supported. However, you can represent a many-to-many relationship by including an entity class for the join table and mapping two separate one-to-many relationships.

upvoted 5 times

...

sinh

Most Recent 4 years, 7 months ago

This is the same as Question No. 32.

upvoted 1 times

...

allzero

4 years, 10 months ago

correct is YES - YES - YES - YES

upvoted 3 times

...