DevForce Community Forum : Inserted Item not Updating

Inserted Item not Updating : Great info. Thanks for your replies!...

Tue, 25 Jan 2011 05:40:43 -700

Author: yimbot
Subject: 2454
Posted: 25-Jan-2011 at 5:40am

Great info. Thanks for your replies!

Inserted Item not Updating : I should have added that when...

Mon, 24 Jan 2011 12:34:02 -700

Author: kimj
Subject: 2454
Posted: 24-Jan-2011 at 12:34pm

I should have added that when QueryStrategy.Normal is used, if a query has been seen before DevForce will assume that the next time the query is run it can be satisfied entirely from cache. smi-mark is correct that to override this behavior you can use QueryStrategy.DataSourceOnly. Here's more information on the subject - http://drc.ideablade.com/xwiki/bin/view/Documentation/EntityCaching.

Inserted Item not Updating : If you always want to go back...

Sun, 23 Jan 2011 11:15:36 -700

Author: smi-mark
Subject: 2454
Posted: 23-Jan-2011 at 11:15am

If you always want to go back to the SQL Server for this query, try changing:

var query = Mgr.Widgets.Where(a => a.UserID == CurrentUserID);

to

var query = Mgr.Widgets.Where(a => a.UserID == CurrentUserID).With(QueryStrategy.DataSourceOnly);

Inserted Item not Updating : Hasthe em.DefaultQueryStrategy...

Sat, 22 Jan 2011 21:05:48 -700

Author: kimj
Subject: 2454
Posted: 22-Jan-2011 at 9:05pm

Has the em.DefaultQueryStrategy been set to CacheOnly?

Inserted Item not Updating : Any ideas or suggestions as to...

Sat, 22 Jan 2011 15:25:45 -700

Author: yimbot
Subject: 2454
Posted: 22-Jan-2011 at 3:25pm

Any ideas or suggestions as to where this might be failing?

Inserted Item not Updating : An interesting problem... When...

Thu, 20 Jan 2011 05:53:12 -700

Author: yimbot
Subject: 2454
Posted: 20-Jan-2011 at 5:53am

An interesting problem...

When first loading a page, I call the GetWidgets Method to and bind the reults as an item source of a combo box. Works fine.

If i then add a widget to the database by any method (even through SQL Management studio) and execute my query again, it does not find the new item added.

This is my GetWidgets Method

        public void GetWidgets()
        {
                IsBusy = true;
                WidgetsList.Clear();
                var query = Mgr.Widgets.Where(a => a.UserID == CurrentUserID);
                query.ExecuteAsync(op =>
                                       {
                                           if (op.HasError)
                                           {
                                               MessageBoxServiceProvider.ShowError("Unable to retrive your Widgets",
                                                                                   "Widget Error");
                                               op.MarkErrorAsHandled();
                                           }
                                           else
                                           {
                                               op.Results.ForEach(WidgetsList.Add);
                                           }
                                           IsBusy = false;
                                       });
            }