How do i write code to handle exceptions in the DAL if i use the designer to create DAL?

petre ricardo

hi,
It seems like i have to use the Designer to create DAL with Optimistic concurrency. Typically when i write DAL without Optimistic concurrecy i got the previledge to write code to handle exception such as errors in connecting to DB ..etc within the DAL. but now use of the designer to create DAL i dont get the chace to write code to handle exceptions. how do i implement exception handling in the DAL if i use the designer?
TY

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Accepted answer
Here is Example which you are looking for :)

Part 1

http://msdn.microsoft.com/en-us/magazine/cc163924.aspx

Part 2

http://msdn.microsoft.com/en-us/magazine/cc163908.aspx

Here are Some More Example

http://www.codeproject.com/KB/database/codesbart7.aspx
petre ricardo17y ago
hi,
Thanks for all your answers....
It seems like there any many way to create a DAL that haddle concurecny.... When i do research on the net most of the sample were created using the designer to handle concurrecny. I have seen the sub sonic that kirtan has pointed out, but i think it uses LINQ...Unfortunate teh compnay that i seek epmployement doesnt implemetn .NET 3.0 features yet...so i have to use the oldway of creating DAL... i was flunked afew times becuase i could implement Optimistic concurrency in my code....
Does any one know any article that was writen that shows the way how to handle optimistic concurrecy in code?
TY
Kirtan Patel17y ago
Because its totally Automated Process of Creating DataAccessLayer we cant handle those Exceptions by that method

you need to create Class based (Write your Own Class For DAL) DAL

that will be highly Customizable approach :)

and Also you can use Projects Like SubSonic that creates Zero Code DAL for you :)
Roei Bar17y ago
well my friend you cant handle it and you dont need to thats the idea,
you will wrap in the BL side the DataAccess Provider

i recommend you to read this

http://www.15seconds.com/issue/030317.htm