Using Stored Proc in MVVM Light example : Yep that got it. Thanks

Sun, 28 Apr 2013 20:15:53 -700

Author: Delta_Rich
Subject: 4127
Posted: 28-Apr-2013 at 8:15pm

Yep that got it.
Thanks

Using Stored Proc in MVVM Light example : A StoredProcQuery when executed...

Fri, 26 Apr 2013 10:42:45 -700

Author: kimj
Subject: 4127
Posted: 26-Apr-2013 at 10:42am

A StoredProcQuery when executed returns an IEnumerable, so if you cast the op.Results to an IEnumerable this should work:

success(op.Results.Cast());

You'll need a using statement for System.Linq too.

Using Stored Proc in MVVM Light example : I have watched and followed the...

Thu, 25 Apr 2013 16:24:48 -700

Author: Delta_Rich
Subject: 4127
Posted: 25-Apr-2013 at 4:24pm

I have watched and followed the video "MVVM Light with DevForce (Silverlight)", which was a great help. Now I am stuck with how to utilise the "Function Import" of a stored procedure returning a list of Entities.

If for example (from the example above) I create a Stored Proc that retrieves Customers where Country = parameter 1 and Region = parameter 2
(obviously this could be done using Linq but I want to show this as an example of parametised sprocs).
eg SQL would "EXECUTE usp_CustomerCtyReg 'USA', 'OR'"

In my dataservice I would try it this way - varying from the video example by calling the LoadCustomersViaSPQuery:

public void LoadCustomersViaSPQuery( Action> success = null, Action fail = null)
{
     // Call the StoredProc for this
     Manager.RetrieveSPCustomersQuery(pCountry: "USA", pRegion: "OR")
          .ExecuteAsync(op =>
     {
          if (op.CompletedSuccessfully)
          {
               if (null != success)
               {
                    success(op.Results);
               }
          }
          else
          {
               if (null != fail)
               {
                    op.MarkErrorAsHandled();
                    fail(op.Error);
               }
          }
     });
}

However, the success(op.Results) is erroring - "Delegate .... has some missing arguments."

Once I sought that out I imagine (and probably incorrectly) the ViewModel should just follow the remainder of the example.

Anyhow, can someone please provide me with the "how to" based on the video example?

DevForce Community Forum : Using Stored Proc in MVVM Light example

Using Stored Proc in MVVM Light example : Yep that got it. Thanks

Using Stored Proc in MVVM Light example : A StoredProcQuery when executed...

Using Stored Proc in MVVM Light example : I have watched and followed the...