Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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?


asked 13 Mar '17, 11:23

pkeuter's gravatar image

accept rate: 0%

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.]

permanent link

answered 13 Mar '17, 11:55

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%


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

(15 Mar '17, 10:35) JBSchueler

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.

(16 Mar '17, 17:23) JBSchueler
Replies hidden

Microsoft has radically changed the way things are set up

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

(17 Mar '17, 04:12) Volker Barth
  • 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.
permanent link

answered 16 May '17, 09:43

Oleg45ver2's gravatar image

accept rate: 0%

edited 16 May '17, 09:48

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 13 Mar '17, 11:23

question was seen: 4,008 times

last updated: 16 May '17, 09:48