C#•2w ago

Why isn't the blogposts tags being pulled?

So the first screenshot is of the index page, where I'm trying to display the tags. The second, third and fourth screenshots are of the Blogpost, Tag, and BlogpostTag models The next 3 images are of each of the databases, in the same order. finally, here is a screenshot of the webapp running. Why isn't it finding the tags when they exist in the DB?

30 Replies

Anton•2w ago

you didn't include the code that runs the query I assume you have an EF Core query you need to either project into a dto, or do an Include for the tags navigation and remove the check for null, do an assert instead

Angius•2w ago

gib query

jaddersOP•2w ago

sure, 2 secs

jaddersOP•2w ago

BlogpostsController

Angius•2w ago

Huh, seems fine Does the debugger also show that blogpost here doesn't contain tags? As a side note, you can just set the relationship between tags and blogposts directly, EF will figure out the pivot table

jaddersOP•2w ago

@Angius How would I set it directly, just like the new line I added?

Angius•2w ago

ye Just List<Tag> Tags on the blogpost, and List<Blogpost> Blogposts on the tag

jaddersOP•2w ago

Ahh, the guide I was using said to make a connector class?

Angius•2w ago

Wouldn't make them nullable either

jaddersOP•2w ago

That's basically an interface right, what my old code did?

Angius•2w ago

Well, the guide probably wasn't the freshest Your code does not contain any interfaces whatsoever Besides IActionResult I guess

jaddersOP•2w ago

ahh, so the connector class is pointless?

Angius•2w ago

It has its uses But you can always configure the relationship to use it While keeping the navigation between tags and posts direct

jaddersOP•2w ago

Angius•2w ago

Example from my project, configuration of Story

builder
    .HasMany(s => s.Tags)
    .WithMany(t => t.Stories)
    .UsingEntity<StoryTag>(
        st => st.HasOne(e => e.Tag)
            .WithMany()
            .HasForeignKey(e => e.TagId)
            .OnDelete(DeleteBehavior.Cascade),
        st => st.HasOne(e => e.Story)
            .WithMany()
            .HasForeignKey(e => e.StoryId)
            .OnDelete(DeleteBehavior.Cascade)

builder
    .HasMany(s => s.Tags)
    .WithMany(t => t.Stories)
    .UsingEntity<StoryTag>(
        st => st.HasOne(e => e.Tag)
            .WithMany()
            .HasForeignKey(e => e.TagId)
            .OnDelete(DeleteBehavior.Cascade),
        st => st.HasOne(e => e.Story)
            .WithMany()
            .HasForeignKey(e => e.StoryId)
            .OnDelete(DeleteBehavior.Cascade)

jaddersOP•2w ago

ohhhh

Angius•2w ago

Just set it to [] public List<Tag> Tags { get; set; } = [];

jaddersOP•2w ago

so do I just change this to now just: .Include(t => t.Tag) .FirstOrDefaultAsync(x => x.Id == id); as the Include doesn't need to include the blogpostTags @Angius it broke my context

Angius•2w ago

Yes, that's how you do it, just include the tags

jaddersOP•2w ago

Angius•2w ago

Broke the context how? Don't configure the BlogpostTags

jaddersOP•2w ago

Angius•2w ago

story config story tag config tag story tag

jaddersOP•2w ago

Every change I make is wrong xD Any chance you have 2 mins for a voice call to run through it quick and I'll share my screen??

Angius•2w ago

Not right now, sorry

jaddersOP•2w ago

Okay, no worries

Unknown User•2w ago

Message Not Public

jaddersOP•2w ago

I should have just posted the repo link xD Just need to check my gitignore worked properly will post it shortly Worked this out. I hadn't passed the BlogpostTags into the Index method in the controller before returning the View

Gaming

Programming

Why isn't the blogposts tags being pulled?

Did you find this page helpful?