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? |
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. 1
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. 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 Does SQL Anywhere 10 also support Visual Studio 2010? (Only ADO.NET integration, not EF4.) No it does not. You'll need to use SA11 to get the VS2010 support. |
I don't have tested EF4 yet, but with EF1, SA11 is working fine. |