CleanArchitecture | Kotlin backend based on the Clean Architecture principles | GraphQL library

In the method GetNotificationCorrespondingToDomainEvent in https://github.com/jasontaylordev/CleanArchitecture/blob/main/src/Infrastructure/Services/DomainEventService.cs, it has the following method,

I have a project created using the clean architecture template.

If I want a domain event be raised when a new project is created, where do I add that?

If I have to raise an event whenever a new item be added to a project, I can accomplish that in the Project entity as shown here.

Similarly for MarkCompletion of a ToDoItem as done here.

But its not clear where do I put the code to raise an event when a new Project is created?

One option is doing something like the following in Create End Point here.

For references: https://github.com/ardalis/CleanArchitecture

The BaseEntity model contains a List. This list is being ignored in when doing EF Migrations.

I am working on a .NET 5 targeted ASP.NET API where I need to access three different SQL databases.

I am using AutoFac as my DI (disclaimer: I am new to AutoFac and have only used the ASP.NET Core build in DI in the past).

I am also using the CleanArchitecture framework from Steve Smith (https://github.com/ardalis/CleanArchitecture)

I am using generic repositories, one for each DbContext (representing the 3 different databases).

I have the following code in my startup project's Startup.cs --> ConfigureContainer method;

Unhandled exception rendering component:

Cannot provide a value for property _accountService on type Inventory_Management.Client.Pages.Authentication.Login. There are no registered service of type Inventory_Management.Shared.Services.AccountService.

AccountService.cs

I using CleanArchitecture solution. I have Data layer where ApplicationDbContext and UnitOfWork are located :

I am having trouble wiring up identity into Blazor server with ASP.NET Core identity. Specifically getting the correct logged in state in Blazor pages (while I am getting them from the Blazor pages).

I think it's related to some of the startup being initialized in another project - but not sure how to debug it or what the solution is to be able to get the logged in state correctly.

Reproduction steps and link to GH repo below as a POC.

Background

I'm porting over the clean-code project by JasonTaylor from Angular / ASP.NET Core to a Blazor server project with ASP.NET Core Identity.

Issue

The application runs up and I can browse the pages when I register I can see logged-in state in the identity-based default pages but in the Blazor pages that use the AuthorizeView (e.g. LoginDisplay.razor) it's not aware of being authorized.

Startup in the Blazor project:

What is the best way to call a SQL function / stored procedure when converting code to use the repository pattern? Specifically, I am interested in read/query capabilities.

Options

1. Add an ExecuteSqlQuery to IRepository
2. Add a new repository interface specific to the context (i.e. ILocationRepository) and add resource specific methods
3. Add a special "repository" for all the random stored procedures until they are all converted
4. Don't. Just convert the stored procedures to code and place the logic in the service layer

Option #4 does seem to be the best long term solution, but it's also going to take a lot more time and I was hoping to push this until a future phase.

Which option (above or otherwise) would be "best"?

NOTE: my architecture is based on ardalis/CleanArchitecture using ardalis/Specification, though I'm open to all suggestions.

I'm getting this error:

Database operation expected to affect 1 row(s) but actually affected 0 row(s)

when adding a new element to the entity's collection.

Base classes in Domain project: