In my microservices architecture using ASP.NET Core, I have two distinct microservices: Identity.API for user management and PersonalAccount.API for handling personal account-related functionalities. Each microservice operates with its own separate database. In PersonalAccount.API, I have a Project entity with a ManagerID field intended to reference a User entity from the Identity.API microservice.
Since Identity.API and PersonalAccount.API are separate projects and databases, there is no direct database-level foreign key constraint possible between them. This situation creates challenges in managing and validating the reference to a user across microservices. I’m seeking guidance on the best approach to handle such cross-service references, ensure data consistency, and maintain integrity between these microservices.
I attempted to use a foreign key approach between the ManagerID in the PersonalAccount.API and the User entity in the Identity.API. However, this approach is not feasible due to the microservices being in separate databases and not sharing a direct connection.
Instead, I considered having PersonalAccount.API make HTTP requests to Identity.API to validate the ManagerID. I expected that by implementing a service-to-service communication mechanism, I would be able to validate the ManagerID and ensure it references a valid User in Identity.API.
What actually resulted was a more complex implementation involving additional service calls and potential performance overhead. I am now looking for a more streamlined approach to manage this cross-microservice reference effectively.
Medina Abasova is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I can really recommend the whole microsoft learn course “.NET Microservices: Architecture for Containerized .NET Applications” at https://learn.microsoft.com/en-us/dotnet/architecture/microservices/ which is also available as a pdf download
More specifically, you asked about How to achieve consistency across multiple microservices and microsoft unmistakably says “No microservice should ever include tables/storage owned by another microservice in its own transactions, not even in direct queries”
That said I see two possible solutions:
- the synchronous pattern (that you already designed by making HTTP requests to Identity.API) guarantees consistency but has the overhead and may have performance implications
- the asynchronous way would be working with eventual consistency by using an event-based communication
Edit: You should also read Identify domain-model boundaries for each microservice on how to store and work with data owned by another microservice (bounded context)