Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

It has been a long time since Entity Framework 6 has been released. Any ideas on when we will finally get a working EF6 Provider? Having to wait for such a trivial thing like porting a working EF5 provider to EF6.* for over half a year is really disappointing.

asked 16 Jun '14, 05:09

codeworx's gravatar image

accept rate: 0%


We are currently working on EF6 support for SQLA. Don't have a timeframe yet, but hopefully soon. For the benefit of others, I'll reply to this thread when our EF6 support is available.

(16 Jun '14, 10:48) José Ramos

Come on guys. It has been 10 Month now since EF6 was released. If you don’t want to support EF6.* just say it.

“Planning” to support it for over 10 Month is ridiculous, especially when you see other companies updating their provider within weeks.

(06 Aug '14, 04:59) codeworx

We are very close to completing our support for EF6. Once this is done, I will post a message in the forum indicating its availability. Thanks for your patience.

(07 Aug '14, 14:27) José Ramos

The SAP developer site provides a download for EBF 4134 ... How can we get our hands on EBF 4142?

(16 Sep '14, 17:42) sbhyde
Replies hidden
Comment Text Removed
Comment Text Removed

Hello sbhyde,

For information about how to obtain current Support Packages for SQL Anywhere, see my answer here. If you don't have an older Sybase support agreement to access the older Sybase EBF site, you will need to have a current SAP support agreement in order to obtain access.

(20 Sep '14, 11:19) Jeff Albion

UPDATE: There was an additional problem with the EF6 design-first wizard found during further testing. This has now been fixed in and, see CR #770760. Code-first projects should still work with the current support.

Windows x86/x64 Support Packages (12.0.1 SP 80 and above, 16.0 SP 19 and above) have been released with this update.

How to build an Entity Framework 6 Project with SQL Anywhere and and above

In order to build an Entity Framework 6 project with SQL Anywhere:

  • Install the Entity Framework 6 Tools for Visual Studio 2012 & 2013
  • Run SetupVSPackage.exe with the newly added “/v 6” option to register the Entity Framework 6 Provider (in machine.config). (Note: This replaces the current 'iAnywhere.Data.SQLAnywhere' invariant to use an EF6-compatible provider)
  • Install Entity Framework NuGet Package for the Visual Studio project. In the package manager console, type:

Install-Package EntityFramework

  • Modify the project app.config file to include the SQL Anywhere Entity Framework 6 provider. Here’s an example:

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

  • Build the Visual Studio project.

  • Run Entity Data Model Wizard (Add -> New Item -> ADO.NET Entity Data Model).
permanent link

answered 19 Sep '14, 15:07

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

edited 14 Apr '15, 10:19

For me "/v 6" didn't work. I had to use "/v EF6". I'm using SA

(21 Mar '16, 19:04) rlenders

FWIW, Windows 12.0.1 and 16.0 EBFs containing the EF6 provider seem to be available for some weeks: - cf. this CR note.

  • has been published on 2014-08-13
  • has been published on 2014-09-06

  • has been published on 2014-09-05

Note: I do not use EF, so I can't tell whether they work as expected, I just noticed the section in the EBF Readme...

 ================(Build #4142  - Engineering Case #768717)================

    The ADO.NET provider now supports Entity Framework 6. A new dll (iAnywhere.Data.SQLAnywhere.EF6.dll) 
    has been added to %SQLANY%\Assembly\V4.5 directory. SetupVSPackage still 
    registers the v4.5 dll. To use the new Entity Framework 6 provider, register 
    it in app.config or web.config.
permanent link

answered 09 Sep '14, 05:38

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 09 Sep '14, 05:43


Thanks Volker for highlighting this support. Yes, we do officially now support Entity Framework 6.0.x now with the above CRs and builds.

However, there is one known issue with this support. When using the Model-first designer in EFTools 6.0, it is possible to encounter the following message:

alt text

This is a known bug in EF6: "EF Designer cannot load 3rd party provider if a project has not been built"

Building the project for the first time while the EF6 assemblies are present and referenced will resolve the issue, as mentioned in the article above.

(16 Sep '14, 16:25) Jeff Albion
Replies hidden

FYI: This particular issue has been resolved in EFTools 6.1.2 and higher. See:

Now having a clean build should no longer result in the inability to find the provider and the build step listed in my other answer is not required.

(23 Jan '15, 10:33) Jeff Albion

I performed all the steps in the above message and STILL had the problem. I finally stumbled on the following fix on another forum (stackoverflow) and wanted to add the fix to this posting in the hope I save some poor soul the the lost time I experienced.

Note: This fix is for version 17. The fix for 12 or 16 would be the same with appropriate references changed.

You must replace the entity framework section in app.config (web.config) with the following (remove blank lines)...



  <clear />

  <add name="SQL Anywhere 17 Data Provider" invariant="Sap.Data.SQLAnywhere" description=".Net Framework Data Provider for SQL Anywhere 17" type="Sap.Data.SQLAnywhere.SAFactory, Sap.Data.SQLAnywhere.EF6, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />




<defaultConnectionFactory type="Sap.Data.SQLAnywhere.SAConnectionFactory, Sap.Data.SQLAnywhere.EF6, Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400">



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



permanent link

answered 11 Jun '20, 12:32

justnobody's gravatar image

accept rate: 0%

edited 11 Jun '20, 12:36

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: 16 Jun '14, 05:09

question was seen: 13,087 times

last updated: 11 Jun '20, 12:36