DevForce Community Forum : Devforce 2010 queries on SQL Azure database http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Devforce 2010 queries on SQL Azure database Tue, 12 May 2026 20:42:40 -700 Tue, 02 Jul 2013 22:18:58 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4195 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Devforce 2010 queries on SQL Azure database : Hi, Have got the issue resolved. Made... http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16519#16519 Author: monikapathak14
Subject: 4195
Posted: 02-Jul-2013 at 10:18pm

Hi,

Have got the issue resolved.
Made some changes in the web.config and the main problem was with the data that I migrated to sql azure. Copied some of it manually and it works fine now...

Still have some problems with sql azure migration...so ....nothing to do with devforce queries.

Thanks for your help.]]> Tue, 02 Jul 2013 22:18:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16519#16519 Devforce 2010 queries on SQL Azure database : Monika, I'm confused. Can... http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16518#16518 Author: sbelini
Subject: 4195
Posted: 02-Jul-2013 at 2:18pm

Monika,

I'm confused.
Can you confirm that you are getting:
   EntityQueryOperation.CompletedSuccessfully = true
and
   EntityQueryOperation.Results.Count() == 0]]> Tue, 02 Jul 2013 14:18:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16518#16518 Devforce 2010 queries on SQL Azure database : Yes the debug log contains correct... http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16493#16493 Author: monikapathak14
Subject: 4195
Posted: 27-Jun-2013 at 11:59pm

Yes the debug log contains correct queries which return correct results when run against the sql azure database using management studio.

Have also gone through the video that you have pointed to...It suggest suggests to change the connection string in the web.config file that I already did.

Also, I don't get any error while I debug my local code connecting to the sql azure database...The only problem is - the async queries that am running return empty resultsets when I check in the functions' callbacks..]]> Thu, 27 Jun 2013 23:59:28 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16493#16493 Devforce 2010 queries on SQL Azure database : Monika,Have you checked the server... http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16486#16486 Author: sbelini
Subject: 4195
Posted: 26-Jun-2013 at 10:06am

Monika,

Have you checked the server debug log for any relevant information?

Is it receiving the client's request?

Have you taken a look at the video at http://drc.ideablade.com/devforce-2012/bin/view/Documentation/Azure which talks deployement in Azure?
It might cover a step you missed.


]]> Wed, 26 Jun 2013 10:06:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16486#16486 Devforce 2010 queries on SQL Azure database : Hi, Have migrated my SQL database... http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16482#16482 Author: monikapathak14
Subject: 4195
Posted: 26-Jun-2013 at 3:07am

Hi,

Have migrated my SQL database to SQL Azure.
But as I run my asynchronous devforce queries(as its a Silverlight 4.0 project) on SQL Azure entities...though no error is being thrown, I always get a blank resultset.

Please help...and let me know if these two...devforce version 6 and sql azure are even compatible.]]> Wed, 26 Jun 2013 03:07:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4195&PID=16482#16482