Steel Posts - Answer Overflow

Steel

•Created by Steel on 10/10/2024 in #help

Many To Many relationship with cascading for both entities

Hello, I'm wanting my many to many relationship to cascade delete when either entity is deleted. My issue is I can only set one to DeleteBehaviour.Cascade at a time without it erroring. If I set both to cascade, it tells me an entity can't have multiple cascade paths. I'd like to be able to delete either Application or User and it auto delete their Followers relationship. Here is my code:

builder.Entity<Application>(ent =>
{
    ent.HasMany(u => u.Followers)
        .WithMany(a => a.Following)
        .UsingEntity<Dictionary<string, object>>("ApplicationFollowers",
            j => j
                .HasOne<User>()
                .WithMany()
                .HasForeignKey("UserId")
                .IsRequired()
                .OnDelete(DeleteBehavior.Cascade),
            j => j
                .HasOne<Application>()
                .WithMany()
                .HasForeignKey("ApplicationId")
                .IsRequired()
                .OnDelete(DeleteBehavior.Cascade) // if set to cascade, it errors, otherwise I can't delete applications without deleting the following first
        );
});

// Application.cs
public class Application
{
    public Guid Id { get; set; } = Guid.Empty;

    public ICollection<User> Followers { get; set; } = new List<User>();
}

// User.cs
public class User : IdentityUser<Guid>
{
    public ICollection<Application> Following { get; set; } = new List<Application>();
}

builder.Entity<Application>(ent =>
{
    ent.HasMany(u => u.Followers)
        .WithMany(a => a.Following)
        .UsingEntity<Dictionary<string, object>>("ApplicationFollowers",
            j => j
                .HasOne<User>()
                .WithMany()
                .HasForeignKey("UserId")
                .IsRequired()
                .OnDelete(DeleteBehavior.Cascade),
            j => j
                .HasOne<Application>()
                .WithMany()
                .HasForeignKey("ApplicationId")
                .IsRequired()
                .OnDelete(DeleteBehavior.Cascade) // if set to cascade, it errors, otherwise I can't delete applications without deleting the following first
        );
});

// Application.cs
public class Application
{
    public Guid Id { get; set; } = Guid.Empty;

    public ICollection<User> Followers { get; set; } = new List<User>();
}

// User.cs
public class User : IdentityUser<Guid>
{
    public ICollection<Application> Following { get; set; } = new List<Application>();
}

Let me know if you need any more code. Any help is appreciated. Thanks

2 replies

CC#

•Created by Steel on 9/11/2024 in #help

SignalR Groups not working

Nothing special, just trying to use groups in SignalR and it's just not working. Am I doing something wrong, and if not, anyone see this issue before? .NET 8 Works

await _hubContext.Clients.All.SendAsync("Test");

await _hubContext.Clients.All.SendAsync("Test");

Doesn't work

await _hubContext.Groups.AddToGroupAsync(HttpContext.Connection.Id, "Pizza");
await _hubContext.Clients.Group("Pizza").SendAsync("Test");

await _hubContext.Groups.AddToGroupAsync(HttpContext.Connection.Id, "Pizza");
await _hubContext.Clients.Group("Pizza").SendAsync("Test");

32 replies

Gaming

Programming