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

Hello,

the problem with EF6 is solved for VS 2012 but still exists in VS 2013.

Everything is fine with SA 16.0.0.2052 and VS 2012 Update 4 now. Installed SA after VS, updated SA. Then:

  • add a Data Connection in the VS Server Explorer to the demo database
  • create a console app
  • install-package EntityFramework
  • add, new item, ADO.NET Entity Data Model, walk through assistent.

Works perfectly. No need to do anything fancy anymore.

Now the same in VS 2013 Update 3. This time, the assistant produces the well known error message "Your project references the latest version of Entity Framework; however ..." as described in this question.

The solution is to manually add the provider to the providers in the app.config (or web.config in web projects):

<provider invariantName="iAnywhere.Data.SQLAnywhere" type="iAnywhere.Data.SQLAnywhere.SAProviderServices, iAnywhere.Data.SQLAnywhere.EF6, Version=16.0.0.20524, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />

Make sure the version is the exact version of your assembly depending on your patch level. This fix was one of the steps of the workaround described in the question mentioned above and it is still necessary!

asked 02 Feb '15, 08:31

Michael%20Fischer's gravatar image

Michael Fischer
670111527
accept rate: 25%

In my understanding, Jeff's newer answer to the cited question and the cited CR #770760 description do tell that it is still necessary to add the provider to the according .config file (and they both tell that these are required steps, not workaorunds for older EBFs) so I would think the reported behaviour is still "as documented"... - though not what you are expecting, obviously.

(02 Feb '15, 08:42) Volker Barth
1

You're right, Volker, I just wanted to point to the fact that - in VS 2012 - it works without any additional steps now. Just like with MS SQL Server and just like you would expect it. (And that I would like to see the same behaviour in VS 2013, of course.)

(02 Feb '15, 09:26) Michael Fischer

Have you registered the provider using "SetupVSPackage.exe /i /v EF6"? Worked for me using For me using SA 16.0.0.2158.

(21 Mar '16, 19:03) rlenders
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×69

question asked: 02 Feb '15, 08:31

question was seen: 7,918 times

last updated: 21 Mar '16, 19:03