Getting error from store procedure ????

[Guest]

Dear all,

I am building a multi tiers application based on .-NET 2.0 and SQL server 2005
WHast is the best way to return data access error from the datalayer to
layer above...??

How to return erro to client call from strore procedure ?

Thnaks for help
regard
serge

 

[PlatinumBay]

calderara,

Why not throw an exception, and catch it above?


Steve

 

[Guest]

I was thinking of it but was wondering if it was the common and best way to
do it in a distributed environement ..
is it the case ?

regards
serge

 

[PlatinumBay]

calderara,

I would use custom exceptions and make them serializeable so that the
exception can also used in an distributed environment, like webservices or
remoting.

Hope this helps,


Steve