We want to encrypt our entire database in SQL Server using RC4 algorithm.

We have achieved this database encryption .But we are facing a new problem.We want to use the database for insert ,update,delete operations .Also we want to use data via select queries etc.

But we do not want to use a middle tier which can exchange data between our application and the database.We also do not want to decrypt the database while modifying/using it because it will defeat the purpose of encryption.

We don't want to use views,stored procedures or application level code to decrypt the database records .

What shall we do to ensure usage of encryted database while not modifying either the front end application nor using a middle tier?

Can we go beyond the limits of SQL Server?