Hopefully a quick question.
I have a SQL Server 2010 (standard) database and am experimenting with column encryption.
All going well, excpet that I don't appear to be able to retrieve the data back out of the table using a stored procedure from an ASP.Net web site.
The stored procedure is called and the SELECT statement is issued and a DataTable is returned. On attempting to retrieve the data from the column, the ASP.Net code thinks that the data is NULL.
I can get the INSERTS and SELECTS working fine in SQL Server studio to show me the data.
The SELECT part (excerpt) of the statement looks like this
CAST(DecryptByKey(FirstName) AS varchar(50)) As FirstName
and on returning to the code I can see (whilst debugging) that the column exists in the DataTable but with no data in it.
Can anyone help, I'm running out of ideas and, as ever, timescales are short.... :)