Licensing and Entity Framework 6 support for sybase.

[Former Member]

Hi,

SAP SQL Anywhere seems to contain an ADO .NET Sybase Provider which works with Entity Framework 6.

We are interested to use this provider in our web applications and desktop applications.

What license do we have to take if we want to use only this provider ?

What are the limitation of this provider (Sybase database version comptatibility, EF6 limitations ?)

Is there support regarding this provider ?

Where can i find differences between v12 and v16 ?

Thanks in advance for your replies.

Kind Regards

[jeff_albion · Accepted solution]

Hello Yassine,

What license do we have to take if we want to use only this provider ?

You will need a SQL Anywhere client license (a "seat") for each of your client deployments. You may want to talk to SAP Sales for further details about your exact requirements for your planned deployments.

What are the limitation of this provider (Sybase database version comptatibility, EF6 limitations ?)

See further details about EF6 support here:

http://sqlanywhere-forum.sap.com/questions/22161/entity-framework-6-provider

EF6 support was first released with CR #768717, in SQL Anywhere 12.0.1.4142 and 16.0.1993. There was an additional fix required for the design-first wizard in CR #770760 in 12.0.1.4162 and 16.0.2014.

Finally, there was an issue with Microsoft EFTools 6.1.1 and lower where the third-party provider would not be detected correctly until the project included the assembly reference in the app.config file and the project was built. In EFTools 6.1.2 and higher, only the app.config reference is required - building the project or cleaning the project should not affect this issue now.

Is there support regarding this provider ?

Yes, any issues with the provider can be reported as an incident to SQL Anywhere SAP Support via the component BC-SYB-SQA. You can also post issues to here or on our alternative forum: http://sqlanywhere-forum.sap.com/

Where can i find differences between v12 and v16 ?

The official documentation ( http://dcx.sap.com/ ) lists the changes between version 12.0.0 and 16.0:

• DocCommentXchange - What's new in 12.0.1
• DocCommentXchange - What's new in 16.0

Regards,

Jeff Albion

SAP Active Global Support