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,

Did anybody able to use the Entity framework v6.0.0.0 Alpha 3 with SQL Anywhere 12. I see that as per EF 6 forums, sybase needs to update their data provider in order to have it work with EF 6.

Do anyone from Sybase know when this data provider of sybase will be updated to work with the Entity Framework 6 ?

Below is the link given by microsoft on EF 6- https://entityframework.codeplex.com/wikipage?title=Rebuilding%20EF%20providers%20for%20EF6

Thanks, Praveen.

asked 15 Apr '13, 17:09

pravinady's gravatar image

pravinady
16112
accept rate: 0%

2

Hi,

Are there any news about Entity Framework 6 support for SQL Anywhere 12? Visual Studio 2013 and Entity Framework 6 are now RTM and we would like to use it as soon as possible.

Thanks, Stefan

(21 Oct '13, 11:41) Stefan
Replies hidden

Hi, As I kwnown, EF 6 is now released !

Version 6.1 is in beta

Any news on this updated provider ?

(20 Mar '14, 05:28) Eric

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:

  1. Install the Entity Framework 6 Tools for Visual Studio 2012 & 2013
  2. 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)
  3. Install Entity Framework NuGet Package for the Visual Studio project. In the package manager console, type: Install-Package EntityFramework
  4. 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>

  1. Build the Visual Studio project.

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

permanent link

answered 16 Apr '13, 11:05

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 13 Nov '14, 12:19

Thank you Jeff for the reply.

We will then wait for the EF6 final release to get the SQL Anywhere data provider updated.

(16 Apr '13, 12:02) pravinady

Hi,

are there any news about Entity Framework 6 support for SQL Anywhere 12? Visual Studio 2013 and Entity Framework 6 are now RTM and we would like to use it as soon as possible.

Thanks, Stefan

(05 Nov '13, 05:18) Stefan

We are now close to the end of 2014. Is there any progress with the release for support of EF6 with SQL Anywhere 12? I'm sure that others are waiting for something to happen

(07 Nov '14, 17:02) KGINOZZ
Replies hidden
2

I guess this other FAQ will answer your question - and according to that, EBFs with EF6 support have been released in September:

Entity Framework 6.* provider.

(08 Nov '14, 17:21) Volker Barth

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

(21 Mar '16, 19:02) rlenders
Your answer
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: 15 Apr '13, 17:09

question was seen: 8,308 times

last updated: 21 Mar '16, 19:02