WCF数据服务 - 存储过程和复杂类型函数 [英] WCF Data service- Store Procedure and complex type function

问题描述

Follks，

我一直在努力从WCF数据服务执行存储过程。

存储过程脚本：

 

ALTER  procedure [dbo]。[Custom_UserAddressList] @UserGUID varchar（100） 

as

 

选择a.GUID作为ID，A.RecipientTitle  +''+ A.RecipientName作为收件人，  

A.Address1 +''+ A.Address2 as Address，A.CountryCode as Country

from SAMCommerce_UserAddress 内部联接 SAMCommerce_User
B A.UserGUID = b.GUID 

其中b.GUID =@UserGUID

 

我们在WCF数据服务上配置了商店流程实体，如下所示：

复杂类型名称：  ; Custom_UserAddressList_Result

存储过程实体名称：  Custom_UserAddressList

网络方法：

 

  ; [WebGet]

   &NBSP; &NBSP;   public IQueryable< Custom_UserAddressList_Result> GetUserAddress（string UserGUID）

   &NBSP; &NBSP;   {  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;&NBSP;&NBSP;&NBSP; &NBSP; &NBSP;   

   &NBSP; &NBSP; &NBSP; &NBSP;  尝试

   &NBSP; &NBSP; &NBSP; &NBSP;   {  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  

   &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   return this.CurrentDataSource.Custom_UserAddressList（UserGUID）.AsQueryable（）; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  

   &NBSP; &NBSP; &NBSP; &NBSP;  }

   &NBSP; &NBSP; &NBSP; &NBSP;   catch（DataServiceException ex）

   &NBSP; &NBSP; &NBSP; &NBSP;   {  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  

   &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   throw（ex）;

   &NBSP; &NBSP; &NBSP; &NBSP;  }

   &NBSP; &NBSP;  }

 

 

它触发错误:(我花了将近4天结果是什么 

感谢您的帮助

 

解决方案

错误发生的确切错误是什么？

 

Follks,

I have been struggling to execute the store procedure from WCF data services.

The store procedure script:

 

ALTER  procedure [dbo].[Custom_UserAddressList] @UserGUID varchar(100) 

as

 

select a.GUID as ID, A.RecipientTitle  +' '+ A.RecipientName as Recipient, 

A.Address1 +''+ A.Address2 as Address, A.CountryCode as Country

from SAMCommerce_UserAddress A inner join SAMCommerce_User B on A.UserGUID=b.GUID 

where b.GUID=@UserGUID

 

we configured store procedure entity on WCF data services as the following:

Complex type name: Custom_UserAddressList_Result

Store procedure entity name: Custom_UserAddressList

web method:

 

 [WebGet]

        public IQueryable<Custom_UserAddressList_Result> GetUserAddress(string UserGUID)

        {                          

            try

            {                

                return this.CurrentDataSource.Custom_UserAddressList(UserGUID).AsQueryable();                

            }

            catch (DataServiceException ex)

            {                

                throw (ex);

            }

        }

 

 

it triggered error :( I spent almost 4 days for it. the result is nothing 

appreciated your help

 

解决方案

What is the error exactly, where the error occurs?

 

这篇关于WCF数据服务 - 存储过程和复杂类型函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！