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

Profile IconKevin Rolnick, Tony Williams, Mark Sullivan and 48 more joined Azure User Groups
Sep 21

© 2018   Created by Azure Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service