The TDE is a bit misleading. You might take a look at http://msdn.microsoft.com/en-us/library/ms179331(v=SQL.100).aspx

The way we do it is:

1) create certificates/keys (only needs done once)

2) open key

3) EncryptByKey