Question Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017) in Technology Q&A

SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

Former Member — Mon, 13 Mar 2017 11:23:33 GMT

When installing Visual Studio 2017, the SetupVSPackage of SQLAnywhere does not install the EF6 libraries into Visual Studio. Is there any way this can be implemented so that we can use EF with VS2017?

Thanks!

Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

Former Member — Mon, 13 Mar 2017 11:55:57 GMT

From my limited understanding, the SetupVSPackage needs to be built for each new Visual Studio release and since VS 2017 just released this month, it may be a little while before that happens on the supported branches.

Since SQL Anywhere 12 went past development support last December, if you absolutely must need to use Visual Studion 2017 for project work you will need to go to SQL Anywhere versions 16 or 17 when that support becomes available for those releases.

[Caveat this thread only applies to support for EF6 on VS2017 and should not be read as implying an announcement of or suggesting support for the newer EF-Core which remains to be undetermined at this time.]

Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

jack_schueler — Wed, 15 Mar 2017 10:35:56 GMT

I'll take a look at this. We will have to add VS integration for this new version.

Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

jack_schueler — Thu, 16 Mar 2017 17:23:32 GMT

Microsoft has radically changed the way things are set up with VS 2017. The registry structure is quite different (or gone entirely) so this will take some time.

https://developercommunity.visualstudio.com/content/problem/2813/cant-find-registry-entries-for-visual-studio-2017.html

Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

VolkerBarth — Fri, 17 Mar 2017 04:12:33 GMT

Microsoft has radically changed the way things are set up

Well, thanks to the Golden Watcom Rule, we would not expect that from you:)

Re: SQLAnywhere 12 EF6 does not work with VS15 (Visual Studio 2017)

Former Member — Tue, 16 May 2017 09:43:47 GMT

Prepare the comparison files "12.0.without.reg" and "12.0.wth.reg" (12.0 is for Visual Studio 2013, correct for your version of VS).
1. Prepare a snapshot of the registry without an installed SA provider.
  
  Cd C:\\Program Files\\SQL Anywhere 17\\Assembly\\V4
  
  SetupVSPackage.exe /u
  
  Export the HKEY LOCAL MACHINE\\SOFTWARE\\Microsoft\\VisualStudio\\12.0 branch to the file "12.0.without.reg"
2. Preparing the snapshot of the registry after connecting the SA provider.
  
  SetupVSPackage.exe / i / v EF6
  
  Export the HKEY LOCAL MACHINE\\SOFTWARE\\Microsoft\\VisualStudio\\12.0 branch to the file "12.0.with.reg"
3. Run WinDiff.exe(or another file comparison utility) and compare files.
  
  Save the difference to any file ("2017.05.16.reg", for instance).
4. Change the prefix HKEY LOCAL MACHINE\\SOFTWARE\\Microsoft\\VisualStudio\\12.0 to
  
  HKEY USERS\\VS2017PrivateRegistry\\Software\\Microsoft\\VisualStudio\\15.0 e014b343 Config inside this file.
Connect a hive.
1. Select the HKEY_USERS node in Regedit.
2. Connect hive from C:\\Users\\User\\AppData\\Local\\Microsoft\\VisualStudio\\15.0_e014b343\\privateregistry.bin. (value of literal "e014b343" may be different)
3. Assign an name to hive (VS2017PrivateRegistry, for instance).
Add "2017.05.15.reg" to the registry (just click on the file).
Unload the VS2017PrivateRegistry hive.