Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Which ORM to use with SQL Azure?

Tags:

Just wondering what everyones thoughts on what ORM to use for SQL Azure?

I'm fairly comfortable using LINQ-to-SQL and I believe it is possible to get it working with SQL Azure. However, from my understanding (correct me if I'm wrong), no further improvements will be made to Linq-to-SQL in future releases of the .NET framework?

Alternatively, there is the entity framework... and further afield from the Microsoft Camp is NHibernate.

Ideally, any additional suggestions made should be free or open source. I have seen Telerik's ORM but this of course, is a commercial product.

I can get the definitions/benefits of each ORM myself by doing a Google search, but I was just interested in peoples opinions as to which ORM seems to work best for them (even if it is none of the above)

like image 689
Jamie Chapman Avatar asked Mar 12 '10 09:03

Jamie Chapman


People also ask

What is ORM in Azure?

Object-Relational Mapping (ORM) with Azure Table Data Entities in Java.

What is the difference between Cosmos DB and Azure SQL?

Azure SQL is based on SQL Server engine, you can easily migrate applications and continue to use the tools, languages, and resources that you're familiar with. Azure Cosmos DB is used for web, mobile, gaming, and IoT application that needs to handle massive amounts of data, reads, and writes at a global scale.

What is the only prerequisite for connecting to a database in Azure SQL Database?

Get the connection information you need to connect to the database in Azure SQL Database. You'll need the fully qualified server name or host name, database name, and login information for the upcoming procedures. Sign in to the Azure portal.


1 Answers

DataObjects.Net supports SQL Azure. It's available under GPL (but not LGPL - i.e. if GPL is too strict for you, you must acquire a commercial license).

like image 105
Alex Yakunin Avatar answered Sep 19 '22 11:09

Alex Yakunin