1
Vote

Using Template gives error in VS2015

description

Hi,
using the template in VS2015 Professional Update 3 gives the following error message(s):

Severity Code Description Project File Line Suppression State
Error Compiling transformation: The type 'TSqlModel' exists in both 'Microsoft.SqlServer.Dac.Extensions, Version=12.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' and 'Microsoft.SqlServer.Dac.Extensions, Version=13.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' SOPLA C:\work\Aurora_Reporting\DEV-Branch\R2017-03-02-D (Artikelhistorie Rubikon)\SOPLA\T4_Templates\InMemoryDatabaseModelInclude.tt 41

Seems to be that it cannot resolve the assembly properly. One way to get this fixed was to change the reference as follows:
<#@ assembly name="$(MSBuildProgramFiles32)\Microsoft Visual Studio $(VisualStudioVersion)\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Microsoft.SqlServer.TransactSql.ScriptDom.dll" #> 
<#@ assembly name="$(MSBuildProgramFiles32)\Microsoft Visual Studio $(VisualStudioVersion)\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Microsoft.SqlServer.Dac.dll" #>
<#@ assembly name="$(MSBuildProgramFiles32)\Microsoft Visual Studio $(VisualStudioVersion)\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\Microsoft.SqlServer.Dac.Extensions.dll" #>
But I could not get this running with SQL Server 2014 (120)
Note: I'm not a C# developer

comments