SQL Server 2014 columns encryption
<p>I'm working on SQL server 2014 Enterprise edition and planning to implement encryption to a couple of columns. These columns are referring in ~30 stored procedures.
Not sure which method of encryption I should choose. I considering using column encryption, but from what I've read, this means I should replace these columns to be varbinary and need to modify all related SP. 
Any suggestions for more efficient process?  Is there a way to allow the application (C#) to be able to decrypt the data, or should it be done from the database side on each related stored procedure?</p>