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: 64

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. http://www.mobiusdevelopment.com/dev/Blog.asp?ArticleID=39860391142...

RSS

Latest Activity

chandupatla joined Mike Holdorf's group
Thumbnail

Dallas Azure User Group

Dallas Azure User Group - Meetings held at the Microsoft Technology Center in Las Colinas
Apr 20, 2017
Ani Arth posted an event
Thumbnail

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
Ani Arth posted an event

Visual Studio Live! DC at Washington Marriott at Metro Center

October 6, 2014 to October 9, 2014
To Boldly Code where No Visual Studio Live! has ever Coded Before!That's right. We are transporting Visual Studio Live! to our nation's capital for the first time in 21 years. From Oct 6 – 9, 2014, developer, software architect, engineer and designer pioneers will gather in our country's headquarters for 4 days of cutting-edge education on the Microsoft Platform. Join us on this special journey to explore topics covering all-things WCF, ALM, Web Development, Data Management, Visual Studio and…See More
Mar 31, 2014
Ani Arth posted events
Jan 28, 2014

© 2018   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service