ef core angular - is there a way to get and display data from database in input box depends on another input box

Question

First Input Box will ask the user to enter employee number

Second Input Box (readOnly) - employee name will be display here automatic base on employee number

program will look for the employee name that have the same employee number that the user inputted.

Database used is SQL Server. Front-End: Angular Back-End: EF Core Linq