I have a ASP.NET MVC application and I have used Linq-to-SQL queries to get data from my SQL Server database. Now for security purposes I need to encrypt my database. How does Linq-to-SQL work with encrypted databases? ...
My question is a duplicate of - http://stackoverflow.com/questions/2230189/oracle-transparent-data-encryption-undecrypted-access - but for SQL Server 2008. Can I set up a SQL Server 2008 database in a way that all of the following statements are true? a) certain columns, potentially all columns are encrypted, so that direct file acce...