Geeks With Blogs

News

This blog has moved to ericnelson.wordpress.com

 Subscribe in a reader

Add to Google Reader or Homepage


Links
View my teams slideshare
These postings are provided "AS IS" with no warranties, and confer no rights.



IUpdateable has moved to ericnelson.wordpress.com Please visit http://ericnelson.wordpress.com

short answer: Quite probably, as SQL Azure is very similar to SQL Server

longer answer: Object Relational Mappers (ORMs) that work with SQL Server are likely but not guaranteed to work with SQL Azure. The differences between the RDBMS versions are small – but may cause problems, for example in tools used to create the mapping between objects and tables or in generated SQL from the ORM which expects “certain things” :-)

More specifically:

  • ADO.NET Entity Framework / LINQ to Entities can be used with SQL Azure, but the Visual Studio designer does not currently work. You will need to point the designer at a version of your database running of SQL Server to create the mapping, then change the connection details to run against SQL Azure.
  • LINQ to SQL has similar issues to ADO.NET Entity Framework above
  • NHibernate can be used against SQL Azure
  • DevExpress XPO supports SQL Azure from version 9.3
  • DataObjects.Net supports SQL Azure
  • Open Access from Telerik works “seamlessly”  - their words not mine :-)

The list above is by no means comprehensive – please leave a comment with details of other ORMs that work (or do not work) with SQL Azure.

Related Links:

Posted on Monday, June 7, 2010 4:05 PM .NET 3.5 , .NET 4.0 , Entity Framework , ORM , Cloud Computing | Back to top


Comments on this post: Q&A: Will my favourite ORM Foo work with SQL Azure?

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Eric Nelson | Powered by: GeeksWithBlogs.net