SmartDataAccessLayer Ver 2

Rating: No reviews yet
Downloads: 19
Released: Aug 31, 2012
Updated: Sep 2, 2012 by SukeshMarla
Dev status: Alpha Help Icon

Recommended Download

Application SmartDataAccessLayer Ver 2 . DLL
application, 6K, uploaded Aug 31, 2012 - 6 downloads

Other Available Downloads

Example How To Use
example, 2K, uploaded Aug 31, 2012 - 13 downloads

Release Notes

Exception Handling feature is added

How to Handle Exception
You are not required to do anything unless and until you put Try catch explicitly in Store Procedure

Please follow following structure in case you want to put try catch explicitly in Stored procedure

Create PROCEDURE MyProcedure
//Parameter List
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY

//Queries
return 1
END TRY
BEGIN CATCH

SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() AS ErrorState,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage
return -1
END CATCH
END

Main Namespace changed to SmartLibraries from MarlaLibraries

Reviews for this release

No reviews yet for this release.