SQL Server Edition: 2008 Enterprise Visual Studio: 2010 with .NET 4.0
SSMS 2008 Addin - Data Scripter project source code on CodePlex links Microsoft.SqlServer.SqlTools.VSIntegration.dll
I referenced the DLL under
<<Microsoft SQL Server install location>>\100\Tools\Binn\VSShell\Common7\IDE
But here's the oddity. Microsoft.SqlServer.SqlTools.VSIntegration.dll contains a namespace Microsoft.SqlServer.Management.UI.VSIntegration, which, in turn, contains ServiceCache (public closure).
As soon as I add the link, ServiceCache will be highlighted (this means that there is no link) But the problem occurs when compiling the project, and VS 2010 causes an error that ServiceCache cannot find.
The name "ServiceCache" does not exist in the current context
Why is this ServiceCache not showing at compile time, but it seems to be available immediately after adding the assembly?
And Reflector shows that ServiceCache is part of the assembly referenced by the project, but Visual Studio intellisense does not display it.
Has anyone had such a problem?
[UPDATE] Some screenshots
Reflector clearly shows ServiceCache
But Visual Studio 2010 says otherwise ...
source
share