C# 7 and .NET Core 2.0 High Performance

Challenges in segregating tables or databases per service

Segregating tables or databases as per business capability or business domain is recommended to limit dependencies and keep it intact with the domain model. But it also comes with some challenges. For example, we have two services: a vendor service and an order service. The vendor service is used to create a vendor record in its own vendor database, and the order service to place orders for a particular vendor. The challenge comes when we need to return the aggregated record of both the vendor and their orders to the user. To solve this problem, we can use either of the following two approaches:

• API composition
• CQRS