SQL Anywhere and Entity Framework

[Former Member]

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?

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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 http://downloads.sybase.com/swd/base.do.

[Former Member · Accepted solution]

Sounds good. I've asked another question regarding whether this will work on the runtime edition: http://sqlanywhere-forum.sap.com/questions/730/entity-framework-4-on-sql-anywhere-runtime-edition

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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