DAL-Example

  • Thread starter Thread starter Jonas Knaus
  • Start date Start date
J

Jonas Knaus

hello

until now i allways wrote all my sql-stuff in my presentation-layer.
i heard about that model of that presentation- / businesslogic- and data
access layer -model.
i found some example on the internet, but not very useful.
does anyone has some examples for this ???

i would by very happy !!!

thanks a lot !

jonas knaus

(e-mail address removed)
 
You can use RapTier to generate all DAOs (Data Access Objects) and VOs
(Value Objects) automatically for you.
 
hello

until now i allways wrote all my sql-stuff in my presentation-layer.
i heard about that model of that presentation- / businesslogic- and data
access layer -model.
i found some example on the internet, but not very useful.
does anyone has some examples for this ???

i would by very happy !!!

thanks a lot !
Click to expand...

See http://www.llblgen.com

FB
 
I read through some of this documentation and I have a question about
connections. Is it better to keep the connection completely inside the DAL
and rely on connection pooling or should the DAL provide a way to use an
existing open connection? It seems if I want to run a procedure which
requires database read/writes from multiple objects, it would be more
efficient to use one database connection than several. This is a
performance vs. design issue - at least I think so. Also, if connection
pooling does solve the performance issue, is it database dependent? Does
SQL Server do connection pooling with dotNet better than Oracle?
Has anyone actually tested or seen test results of this?

Thanks,
Steve
 
Back
Top