title: Editing SQL in .NET executables
body: <p>I am developing a Winforms application compiled for the .NET 4 framework. The application accesses SQL Server using typed Datasets and an encrypted connection string. </p>
  
  <p>Out of curiosity, I open the executable file in a binary editor and noticed that I was able to view the SQL queries from the datasets as plain text. I am concerned that this opens up a security issue - for example, someone changes "select * from mytable" to "delete from mytable". </p>
  
  <p>What is the best way of preventing this? The general consensus on obfuscation seems to be "don't bother", but surely this is a security nightmare just waiting to happen? Are there any best practices or tools that anyone can recommend?</p>