Unable to install VSIX for ARM64

[itsmekoopa]

Unable to install VSIX for ARM64

[itsmekoopa]

Awesome! Version .233 installs and generates the DB models. I've used the 'Reverse engineer' option from context menu.

Want me to try the other options as well? I can do that next Monday.

[ErikEJ]

It is not Community vs other SKUs that is causing issues, it is ARM support that is not present.

Let me investigate if it it possible to bring back support , provided you can beta test for me.

[itsmekoopa]

That would be great! I'd love to beta test. Please let me know what I can do.

[ErikEJ]

When I have a build ready, exercise all the product features (all menu items)

[itsmekoopa]

Sure thing!

I've been using an older build of EF Core Power Tools (EF_Core_Power_Tools_v2.5.537.vsix from March 1, 2021). That version was working on my ARM machine until I updated Visual Studio today.

That's why I uninstalled the old EF CPT build: to try to reinstall the latest build. Uninstall went flawless, installing the new version however... not. ;-)

[ErikEJ]

Got it. I attempted ARM support (someone else did) but it was causing me support headaches.

[ErikEJ]

I implemented a fix for this in the latest daily build, would be grateful if you could try it out.

[itsmekoopa]

Great! Installer is running, but gives the following message:

I guess that's due to these pre requisites:

Is there a way to install these manually?

[ErikEJ]

I think it is the DGML component, I plan to add that as a pre-req in "EF Core Power Pack" instead.

Try build .132 (where I have removed it)

[itsmekoopa]

You mean this version (.232)?
https://www.vsixgallery.com/extension/f4c4712c-ceae-4803-8e52-0e2049d5de9f

Gives me the same error message.

[ErikEJ]

OK, looks like the VisualStudioData component was a mistake, I have tried picking another in the latest build, if that does not work I will try to remove it-.

[ErikEJ]

Build .233 coming up

[ErikEJ]

Can you test reverse engineer with a .dacpac?

And feel free to try the other options, less concerned about them tbh.

[ErikEJ]

@itsmekoopa Thank you som much for help with testing this - last attempt failed since there was not testing follow up.

[ErikEJ]

If you like my free tools, I would be very grateful for a rating or review on Visual Studio Marketplace or even a one-time or monthly sponsorship

[itsmekoopa]

Sure, I'll give it a shot next week. And thank you too, your tools make my daily job a lot easier.

I'll drop you a review and donation!

[itsmekoopa]

Reverse engineering a .dacpac file works. However, a particular error occurs. When generating from an SQL connection, it works.

Probleems seems to be caused by SPs with inner queries, querying a table more than once:

Resulting in this error:

Unable to get result set shape for dbo.jam_GetGroepByID
System.ArgumentException: An item with the same key has already been added. Key: rd
   at System.Collections.Generic.Dictionary`2.TryInsert(TKey key, TValue value, InsertionBehavior behavior)
   at System.Collections.Generic.Dictionary`2.Add(TKey key, TValue value)
   at SqlSharpener.AliasResolutionVisitor.Visit(NamedTableReference namedTableReference) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\SqlSharpener\AliasResolutionVisitor.cs:line 22
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(NamedTableReference node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.NamedTableReference.Accept(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.FromClause.AcceptChildren(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(FromClause node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.FromClause.Accept(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.AcceptChildren(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(QuerySpecification node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.ScalarSubquery.AcceptChildren(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(ScalarSubquery node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.ScalarSubquery.Accept(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.SelectScalarExpression.AcceptChildren(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(SelectScalarExpression node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.SelectScalarExpression.Accept(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.AcceptChildren(TSqlFragmentVisitor visitor)
   at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(QuerySpecification node)
   at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor)
   at SqlSharpener.Model.Select..ctor(QuerySpecification querySpecification, IDictionary`2 bodyColumnTypes) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\SqlSharpener\Model\Select.cs:line 38
   at SqlSharpener.Model.Procedure.<>c__DisplayClass0_0.<.ctor>b__7(QuerySpecification s) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\SqlSharpener\Model\Procedure.cs:line 54
   at System.Linq.Enumerable.SelectEnumerableIterator`2.ToList()
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at SqlSharpener.Model.Procedure..ctor(TSqlObject tSqlObject) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\SqlSharpener\Model\Procedure.cs:line 54
   at ErikEJ.EntityFrameworkCore.SqlServer.Scaffolding.SqlServerDacpacStoredProcedureModelFactory.GetStoredProcedureResultElements(TSqlProcedure proc) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\Scaffolding\SqlServerDacpacStoredProcedureModelFactory.cs:line 160
   at ErikEJ.EntityFrameworkCore.SqlServer.Scaffolding.SqlServerDacpacStoredProcedureModelFactory.GetStoredProcedures(String dacpacPath, ModuleModelFactoryOptions options, Boolean mergeDacpacs) in C:\Code\Github\EFCorePowerTools\src\Nupkg\ErikEJ.EntityFrameworkCore.SqlServer.Dacpac\Scaffolding\SqlServerDacpacStoredProcedureModelFactory.cs:line 65

[ErikEJ]

Ok, you would get that error anyway due to the shape of your stored procedure. Feel free to open a new issue with repro details if you want me to investigate. And thanks for testing

[itsmekoopa]

Hmm, ok. It seems to work when generating from an SQL connection. Was working in the older version of EF CPT as well. I'll try this out next week, when my project is building + running again. :-)

[itsmekoopa]

Difference between dacpac and SQL connection is that the latter IS generating the model files, while the former doesn't.

[ErikEJ]

Feel free to open an issue with repro details