Is there an ORM tool to use with SQL Azure (SDS)?
None of the big names currently have support.
I have checked with LLBGEN and Telerik.

Views: 69

Reply to This

Replies to This Discussion

It's a tricky question to answer. SQL Azure is supposed to look just like SQL Server to software, the main difference is in the connection string--so it'sentirely possible that some tools for SQL Server will just work even though they weren't designed with SQL Azure in mind. Since the first public SQL Azure CTP is just now rolling out, we should soon start to find out what is and is not compatible with it.
I personally tested LLBLGen.
Inserting an Entity works and Linq queries as well.
Getting an entity, updating an entity and deleting an Entity does not.
(You can get an entity via a Linq query)
This is because when they execute the statement against sql Azure they use T-SQL statements which is not supported by sql Azure.
As you may know, sql Azure does not support certain properties of normal sql server.
eg. ANSI, nText, Text, Image etc.
Entity Framework works. I was able to get a Dynamic Data web application going using Entity Framework against SQL Azure.


Latest Activity

Profile IconKevin Rolnick, Tony Williams, Mark Sullivan and 48 more joined Azure User Groups
Sep 21, 2018
chandupatla joined Mike Holdorf's group

Dallas Azure User Group

Dallas Azure User Group - Meetings held at the Microsoft Technology Center in Las Colinas
Apr 20, 2017
Anthony.Tex.M posted a status
"We are ACTIVE on ... and open for new members!"
Feb 21, 2017
Ani Arth posted an event

Live! 360 Orlando at Loew's Royal Pacific Resort

November 17, 2014 to November 21, 2014
Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. These co-located events will incorporate knowledge transfer and networking, along with out-of-this-world education and training, as you create your own custom conference, mixing and matching sessions and workshops to best suit your needs. Whether you are a developer who uses Visual Studio, SQL Server, and SharePoint;…See More
Jun 6, 2014

© 2019   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service