Entity Framework 6.* provider

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[jeff_albion]

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.

[jeff_albion]

UPDATE: There was an additional problem with the EF6 design-first wizard found during further testing. This has now been fixed in 12.0.1.4162 and 16.0.0.2014, 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 12.0.1.4162 and 16.0.0.2014 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=16.0.0.20144, Culture=neutral, PublicKeyToken=f222fc4333e0d400"/> </providers>

• Build the Visual Studio project.

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

[Former Member]

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