java - What should we do in cases where a new query is needed for the DTO class?

Question

For example, I have a bank application. And I have name, surname, citizenship number and address in my database table. That's why I will have these properties in my Entity Class. But in my DTO class, I have name, surname, citizenship number, address and tax number. And the property named tax number can be pulled from another table with the database function. But I can't add the property named tax ID to my real Entity Class because it comes from another table. So where can I call the database function that pulls the property named "tax number"? Is it at the service tier? Is it somewhere else? I hope you understand.

question from:https://stackoverflow.com/questions/65881888/what-should-we-do-in-cases-where-a-new-query-is-needed-for-the-dto-class

Answer 1

Waitting for answers