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.

I am not sure if this is the right place to ask, but i was wondering if anyone has made any attempts to use the latest Entity Framework CTP with SQL Anywhere 11. We are moving from c++ and MFC to .NET and we would like to use an ORM tool, EF is looking promising, but since our databases are based on SA10 we would need to upgrade to SA11 first, which involves a good deal of money in upgrading our licenses or buying more, so i want to know how complete the support for EF is so we can make an informed decision. Has anyone tried making SA11 + EF4 CTP work?

asked 25 Nov '09, 14:37

Sergio's gravatar image

accept rate: 0%

edited 21 May '13, 14:45

Mark%20Culp's gravatar image

Mark Culp

SQL Anywhere 11.0.1 and the EF4 CTP do not work at this time (I tried it). You can code in straight ADO.NET with the .NET Framework 4.0, but you'll have to wait a little until we add support for EF4 in Visual Studio 2010.

permanent link

answered 27 Nov '09, 16:51

Jos%C3%A9%20Ramos's gravatar image

José Ramos
accept rate: 30%


Please note that starting with EBF #2427, SQL Anywhere 11.0.1 now fully supports Visual Studio 2010 and the .NET Framework 4, including the ADO.NET Entity Framework 4.0.

You can download EBFs for SQL Anywhere at

(17 May '10, 19:58) José Ramos

Sounds good. I've asked another question regarding whether this will work on the runtime edition:

(26 May '10, 04:19) Darren

Does SQL Anywhere 10 also support Visual Studio 2010? (Only ADO.NET integration, not EF4.)

(26 May '10, 11:48) Sergio

No it does not. You'll need to use SA11 to get the VS2010 support.

(26 May '10, 15:56) José Ramos

I don't have tested EF4 yet, but with EF1, SA11 is working fine.

permanent link

answered 25 Nov '09, 16:18

Zote's gravatar image

accept rate: 43%

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: 25 Nov '09, 14:37

question was seen: 4,357 times

last updated: 21 May '13, 14:45