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屋!