DevForce Community Forum : Query Strategy Not working?? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Query Strategy Not working?? Sun, 12 Apr 2026 17:32:52 -700 Wed, 09 Feb 2011 17:10:49 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2493 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Query Strategy Not working?? : Hi jipock, I tried reproducing... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9912#9912 Author: sbelini
Subject: 2493
Posted: 09-Feb-2011 at 5:10pm

Hi jipock,
 
I tried reproducing your issue, but was not able to.
 
As smi-mark mentioned, it might be that you are using a different EM. (Are you working with multiple Ems?)
 
If that's not the case, can you provide a reproducible test sample?
 
Silvio.
]]> Wed, 09 Feb 2011 17:10:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9912#9912 Query Strategy Not working?? : Is DataStore.Instance.Entities... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9899#9899 Author: smi-mark
Subject: 2493
Posted: 08-Feb-2011 at 4:49pm

Is DataStore.Instance.Entities always pointing to MyEntityManager?The only reason I could think of it not working would be a different EntityManager. You could test this by doing:

MyEntityManager.MyObjects.Where(qu => qu.Id = x).With(QueryStrategy.DataSourceOnly);


If this still returns the cached copy, then there is an issue somewhere
]]> Tue, 08 Feb 2011 16:49:05 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9899#9899 Query Strategy Not working?? : A fair question. Essentially... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9895#9895 Author: jipock
Subject: 2493
Posted: 08-Feb-2011 at 1:41pm

A fair question.

Essentially it works like this:
 
1) User clicks a button.
2) ChildWindow opens up.
3) I have a query (var q = MyEntityManager.MyObjects.Where(qu => qu.Id = x); ) is executed. An ObservableCollection is populated based upon the results of the query and put into a list.
4) User updates the list.
5) User clicks Save.
6) MyEntityManager.SaveChangesAsync() is fired.
7) When step 6 is finished, the Child Window closes.
8) I use a SQL Statement in Management studio to update a value in MyObjects table where qu.Id = x. The value is different than that which was entered in step 4.
8) User Repeats step 1. Steps 2 and 3 run.
9) The list reflects the value that the user originally put in, NOt the value manually added in the database.
 
Note, this appears to be sporatic - I didn't experience this, this AM.
]]> Tue, 08 Feb 2011 13:41:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9895#9895 Query Strategy Not working?? : Even though you are specifying... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9888#9888 Author: smi-mark
Subject: 2493
Posted: 07-Feb-2011 at 2:07pm

Even though you are specifying a query strategy, do you have some mechanism in the client to actually refresh the data? Otherwise how does it know that there is new data available?

What I mean by this is, even though you have the query strategy set, that doesn't stop DevForce from caching. Until you actually execute the query again, it will used what was cached.


Edited by smi-mark - 07-Feb-2011 at 5:15pm]]> Mon, 07 Feb 2011 14:07:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9888#9888 Query Strategy Not working?? : A quick note - When User A exits... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9887#9887 Author: jipock
Subject: 2493
Posted: 07-Feb-2011 at 1:06pm

A quick note - When User A exits the app and re-starts the app, I see all of the changes.
 
 
]]> Mon, 07 Feb 2011 13:06:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9887#9887 Query Strategy Not working?? : Good Afternoon, I'm experiencing... http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9886#9886 Author: jipock
Subject: 2493
Posted: 07-Feb-2011 at 1:05pm

Good Afternoon,
 
I'm experiencing an issue regarding saving and retrieving values from a database. Please note, I don't really want ANY caching involved: I want this app to only look at the database.. Nothing else.. (Caching I'll implement later)
 
I have my application built up and I have two users running simultaneously. I'm seeing that some User A's Changes are not being seen by User B's changes at all...  "This.. Is bad.."
 
My first thought was, "My Query Strategy isn't right." But, it seems right to me...
 
My Entity Manager has the following:

DataStore.Instance.Entities.DefaultQueryStrategy = new QueryStrategy(FetchStrategy.DataSourceOnly, MergeStrategy.OverwriteChanges);

I don't specify (to my knowledge) anything special in my Entities.SaveChangesAsync() calls.
 
Is there something else I need to do?
 
-Jason
]]> Mon, 07 Feb 2011 13:05:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2493&PID=9886#9886