Hi ,
i have a method SaveRecord() in teh data access layer (DAL) that should return the status of the query execution to the Business Layer (BL)
There are three possible messages the DAL could return to BL:
1. Successfull Execution --> error NO: 1
2. Error: record already exist --> Error no:2
3. Error: SQL Errors while executing con.Open() or cmd.ExecuteNonQuery() --> Error No: 3
I'm planning to return error no to the business layer so that appropriate error message can be assignedd.
Is there any issue that my current technique might face becasue i'm not creating a seperate ErrorHandler class to assign those error numbers and error messages?
Should i create a seperate error handler class?
If i need to create a error handler class should i create it in the DAL or BL?
cheers