Using SQLAnywhere in PowerShell

[former_SQLA_member1694920]

How do I use SQLAnywhere in PowerShell? When I try to Add-Type -Path "./Sap.Data.SQLAnywhere.v4.5.dll" it tells me Could not load file or assembly 'EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.

[Vlad]

I guess your GAC doesn't have this assembly: https://www.nuget.org/packages/EntityFramework/5.0.0

[former_SQLA_member1694920]

Is there a portable solution that does not require tinkering with the GAC?

[former_SQLA_member1694920 · Accepted solution]

Found the answer:

When you install SQL Anywhere 17, the assemblies are automatically registered in the GAC. To load the assembly you need to do Add-Type -AssemblyName ("Sap.Data.SQLAnywhere.v4.5, Version=17.0.0.10624, Culture=neutral, PublicKeyToken=f222fc4333e0d400").