"From the Coal Face" - 1 - What ILDASM can reveal!

Posted by TATWORTH on Geeks with Blogs See other posts from Geeks with Blogs or by TATWORTH
Published on Wed, 21 Apr 2010 20:06:22 GMT Indexed on 2010/04/21 21:24 UTC
Read the original article Hit count: 227

Filed under:

In a place far, far away, there was a project where the Architect decided on using embedded TSQL in a Dot Net application, rather than use stored procedures.

I located ILDASM.EXE (my Framework 3.5 version lives at C:\Program Files\Microsoft SDKs\Windows\v7.0A\bin on my home development PC) and created a shortcut to it in the SendTo folder. Now I could set about doing a simple demonstration to the Architect by taking one of the Dot Net EXE's with the embedded TSQL and sending it to ILDASM.  Since I had written most of the embedded TSQL, it was a matter of seconds before I located the embedded TSQL within the Exe. The TSQL that was supposed to be safely hidden within the EXE was easily located and and copied.

(It should also be noted that we could have encrypted the stored procedures on loading them to the database.)

© Geeks with Blogs or respective owner