更新时间:2022-10-14 23:09:31
错误发生的确切错误是什么?
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?