Full Search in Dynamically Created Website.

Hello.
I just joined the c-sharpcorner and I need help for a project. I use c# as prograaming language and sql server as database.

I built a small cms and most of my webpages are developed dynamically with the data which are stored in db.

I would like to develop search function for entire website however I am not sure how to do it.

I had a look in sql full-text catalog, however I noticed that I have to create an sql for each table that I have. I'm quite confused

If anyone now what steps I have to follow in order to develop this search please let me know................


Thanks for your help in advance.