且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

WCF数据服务 - 存储过程和复杂类型函数

更新时间: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?

 


相关阅读

技术问答最新文章