Computed columns in SQLCLR project in Visual Studio 2010

Question

It appears that MS has a bug when dealing with VS 2010 SQL CLR project and computed columns. I am using Pre/PostDeployScript.sql to drop/add the computed column. However, if I try to deploy from VS2010 it, I get dependency errors. The same project works 100% in Vs2008. I am wondering what my options are in terms of deploying to work around the problem? I am also in contact with MS, but they haven't found a workaround/solution as of yet.

Answer 1

You need to install .Net 3.5 and select it inside the project. It will work.