EDIT: Support for Entity Framework 6 can now be found in 16.0.0.2014 (SP 19) and 12.0.1.4162 (SP 80) and above. See the other answer discussing this topic here.
How to build an Entity Framework 6 Project with SQL Anywhere 16.0.0.2014 / 12.0.1.4162 and above
After you install a Support Package that contains this update, 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).
ORIGINAL:
This is correct - there is no current support for Entity Framework 6 in the SQL Anywhere ADO.NET provider at the current time. I also don't believe EF6 has currently gone GA from Microsoft - from a SQL Anywhere perspective, we generally only support GA third-party OSes and software, typically due to commonly made statements like this about alpha/beta products:
The APIs and functionality included in
Alpha 3 are likely to change prior to
the final release of EF6.
The current provider support is for Entity Framework 5 / .NET 4.5 - see: CR 724639, which can be found in SQL Anywhere 12.0.1.3817, and 16.0 GA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.