Database data encryption in MSSQL for web application

I am trying to saved the data in database table in encrypted format to hide the data store in the database table to be read by the user

Any advice how can i do this with out much effort on application level with less overhead on my application side