locked
The type or namespace name 'Microsoft.SqlServer.DacServices' could not be found (are you missing a using directive or an assembly reference RRS feed

  • Question

  • Microsoft.SqlServer.DacServices dll is referenced in a unit test project and the compiler is showing an error - The type or namespace name 'DacServices' could not be found. 

    Although I referenced the dll file in the project visual studio is still errors out as a missing library. I have also tried downloading the file which has the library from http://www.microsoft.com/en-us/download/details.aspx?id=40735

    by installing Microsoft Data-Tier Application Framework for SQl Server.

    Please shade light on this.

    Thanks,

    Manny

    Friday, July 25, 2014 8:36 PM

Answers

  • Hi Manny_R,

    According to your description and error message, before you installing Data-Teir Application Framework components, we need to verify if you choose the right version of Data-Tier Application Framework. For more information, see: http://alexw.co.uk/2013/05/cannot-find-dac-assembly-microsoft-sqlserver-dac-dll/

    In addition, Microsoft SQL Server  Data-Tier Application Framework requires Microsoft SQL Server System CLR Types, and Microsoft SQL Server Transact-SQL ScriptDom (SQLSysCLRTypes.msi and SQLDOM.msi). You need to install both SQLSysCLRTypes.msi and SQLDOM.msi.

    There is a detail about data-tier application (DAC) features in SQL Server 2012, you can review it.

    http://msdn.microsoft.com/en-us/library/cc879339(v=sql.110).aspx

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Monday, August 4, 2014 8:16 AM
    Tuesday, July 29, 2014 8:35 AM