DevForce Community Forum : Silverlight Stored Procedures http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Silverlight Stored Procedures Mon, 13 Apr 2026 16:47:39 -700 Thu, 15 Dec 2011 08:55:02 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3153 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Silverlight Stored Procedures : thanks Denis. the example code... http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12249#12249 Author: rickadams
Subject: 3153
Posted: 15-Dec-2011 at 8:55am

thanks Denis. the example code did the trick and I am now able to get my complex types returned correctly

Rick
]]> Thu, 15 Dec 2011 08:55:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12249#12249 Silverlight Stored Procedures : Hi rickadams;Sorry for the delayed... http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12239#12239 Author: DenisK
Subject: 3153
Posted: 14-Dec-2011 at 12:31pm

Hi rickadams;

Sorry for the delayed reply. Here's a sample in Silverlight showing a similar example using NorthwindIB on how to use StoredProcQuery returning a complex type with parallel coroutines.

uploads/912/SLStoredProcWithParallelCoroutine.zip
]]> Wed, 14 Dec 2011 12:31:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12239#12239 Silverlight Stored Procedures : I am having implementing a... http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12223#12223 Author: rickadams
Subject: 3153
Posted: 12-Dec-2011 at 2:25pm

I am having implementing a stored procedure and returning a complex type. Here is the stored proc
 
ALTER PROCEDURE [dbo].[PromoCatalogItem_TotalQuantity]
 
@promoCatalog_ID decimal(18,0),
@member_ID decimal(18,0)
AS
BEGIN
    SET NOCOUNT ON;
    SELECT PromoCatalog_Item_ID,
           SUM(T2.Promo.value('(DATACOUNT)[1]', 'decimal(18,6)')) AS TotalOnQuantity ,
           COUNT(*) as Times
    FROM Member_Promocatalog_Data
    CROSS APPLY ReportData1.nodes('/DATA/ONPROMO') T2(Promo)
    WHERE Member_PromoCatalog_ID = @promoCatalog_ID
    AND ReceiverID = @member_ID
    GROUP BY PromoCatalog_Item_ID
END
 
I wish to return a complex type which is the rows from the SELECT statement. I have created a FunctionImport defined for this stored proc but I am unable to return the results. I have verified that the correct paramters are passed to the SP and I have validated that the SP returns a result with this parameters using SQL Enterprise Manager. Here is the code I am using in Silverlight
 
        public INotifyCompleted load_PromoCatalogItemOrderLevels_Coroutine( Decimal promoCatalogID, Decimal memberID)
        {
            var q = mgrPromoCatalog.PromoCatalogItem_TotalQuantityQuery(memberID, promoCatalogID);
            return mgrPromoCatalog.ExecuteQueryAsync(q);
        } 
and I call this in a Coroutine using StartParallel. Here is the Completed handler ( I Have deleted other code to minimize the amount of text )
 
       public void load_MemberPromoCatalogEntities(Member_PromoCatalog memberPromoCatalog, Decimal memberID)
        {
            var coop = Coroutine.StartParallel(() => load_MemberPromoCatalogEntitiesCoroutine(memberPromoCatalog, memberID));
            coop.Completed += (sender, args) =>
            {
                if (args.CompletedSuccessfully)
                {
                    //get the results from our stored procedure call
                    var results = args.Notifications[5] 
                 }
                else
                {
                }
            };
        }
 
I see no errors in the results but I have not data returning. Any help would be appreciated
]]> Mon, 12 Dec 2011 14:25:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3153&PID=12223#12223