How to make general search in Dashboard

Question

I have Search input in my dashboard how to make search value to look up in all tables in the database to get related for this search value using SQL server asp.net core what is the faster way I know that can do easily to get each The Dbset in Dbcontext and search in it but I want the faster way.