title: How the data will be encrypted Before passing into SQL server using .NET and decrypted to use in .NET applications
body: <p>i have a customer table like this</p>
  
  <pre><code>+----+----------+-----+-----------+----------+
  | ID | NAME     | AGE | ADDRESS   | SALARY   |
  +----+----------+-----+-----------+----------+
  |  1 | Ramesh   |  32 | Ahmedabad |  2000.00 |
  |  2 | Khilan   |  25 | Delhi     |  1500.00 |
  |  3 | kaushik  |  23 | Kota      |  2000.00 |
  |  4 | Chaitali |  25 | Mumbai    |  6500.00 |
  |  5 | Hardik   |  27 | Bhopal    |  8500.00 |
  |  6 | Komal    |  22 | MP        |  4500.00 |
  |  7 | Muffy    |  24 | Indore    | 10000.00 |
  +----+----------+-----+-----------+----------+
  </code></pre>
  
  <p>I need to encrypt the data before passing into SQL Server and decrypt the same data to use in the .NET developed applications say windows forms , Asp.Net or even MVC applications .</p>
  
  <p>i need  to transfer the data with encrypted fromat to and from my application and also in the database . I need to make the data secure both during the transfer and also while saving in the SQL server. </p>