Dependancy Issues with Microsoft.Data.Tools.Schema.Sql about sqlsharpener HOT 6 OPEN

Do you have SSDT installed?

from sqlsharpener.

Yes I do and I reboot, neither seemed to make a difference.

Sent from my iPhone

On Jun 15, 2016, at 4:41 PM, Adam [email protected] wrote:

Do you have SSDT installed?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.

from sqlsharpener.

Is there a specific version right now I have 2016.

Sent from my iPhone

On Jun 15, 2016, at 4:41 PM, Adam [email protected] wrote:

Do you have SSDT installed?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or mute the thread.

from sqlsharpener.

This this project dead? Should we hard fork if we have PR's? @aeslinger0

from sqlsharpener.

I had this problem and determined that it was a version issue. This is what I did to fix this issue:

Copied the Microsoft.Data.Tools.Schema.Sql.dll from C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120 and placed that dll in my project.

Modified my T4 to include the following line:
<#@ assembly name="$(SolutionDir)\3rd Party Assemblies\Microsoft.Data.Tools.Schema.Sql.dll" #>

from sqlsharpener.

Hi,

I've been having some problems trying to scafflod views :

I could not find any ways to debug the template, having the same problem with Tools.Schema.SQL ....

Severity Code Description Project File Line Suppression State
Error Running transformation: System.InvalidOperationException: Sequence contains no elements
at System.Linq.Enumerable.First[TSource](IEnumerable1 source) at SqlSharpener.Model.Column..ctor(TSqlObject tSqlObject, TSqlObject tSqlTable, IEnumerable1 primaryKeys, IDictionary2 foreignKeys) at SqlSharpener.Model.View..ctor(TSqlObject tSqlObject, IEnumerable1 primaryKeys, IDictionary2 foreignKeys) at SqlSharpener.MetaBuilder.<>c__DisplayClass10.<LoadModel>b__9(TSqlObject sqlView) at System.Linq.Enumerable.WhereSelectEnumerableIterator2.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at SqlSharpener.MetaBuilder.LoadModel(TSqlModel model)
at SqlSharpener.MetaBuilder.LoadModel()
at SqlSharpener.MetaBuilder.get_Views()
at Microsoft.VisualStudio.TextTemplating227143E7CD567DF3423D572AA6919A52675E2DF41D43FC5C1EE7749C5BF314F9A1D27E4C1F83603B866F0B18121DBB56B10F598EAB5FC143EB7D173D5AF72C4F.GeneratedTextTransformation.TransformText() DOLayer C:\Users\cav001\Documents\GitHub\sqlsharpener\examples\SimpleExample\DOLayer\EFCodeFirstExample.tt 1

from sqlsharpener.