Entity Framework 4 on SQL Anywhere Runtime Edition

[Former Member]

According to a comment on this question:

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

Does anyone know whether Entity Framework 4.0 would run on the Runtime Edition of SQL Anywhere?

Reason for asking is that we have an old Delphi application running against SQL Anywhere v8 Runtime Edition, and are looking to re-write it in C#. I want to investigate whether we could replace the old application piecemeal, by porting parts to C#/EF4.0 and turning off the old Delphi bits.

Thanks, Darren.

[Former Member · Accepted solution]

Yes, the EF4 works with the Runtime Edition of SQL Anywhere, but please note that you must use version 11.0.1 with EBF #2427 or later, otherwise you will not get the Visual Studio 2010 integration component required to generate the EDM.

All you need to do is ensure that you are using rteng11.exe to start the database, either through ODBC or in your connect string.

As Zote mentioned, you will need to upgrade your database because SA11 cannot read database files created with SA9 or earlier. Hope this helps!

[Former Member · Accepted solution]

Great to know, thanks!

[Former Member]

I don't know how "Runtime Edition" works, but I believe that will work fine. But you should upgrade your database (db, server and clients) to SA11 version.