Search database and display the results in textboxes

I recommend that you use the ViewModel here, which are basically generated by the Models from database. You can search for the entities from database and have them create a ViewModel, which can be used to render a complete View.

Read more about a ViewModel here, https://www.c-sharpcorner.com/article/managing-data-with-viewmodel-in-asp-net-mvc/, or here, https://docs.microsoft.com/en-us/aspnet/mvc/overview/older-versions/mvc-music-store/mvc-music-store-part-3

A ViewModel is a Model designed specially for a View which has all the data needed for a View to be rendered, you can use Models from database to prepare a normalized ViewModel. This will help you do that you want to do.