Microsoft Data Access Application Block for .NET

[Nicholas Naddaf]

What do you think about using Microsoft Data Access Application Block for .NET in a n-tier application?

[Jorgen Sigvardsson]

No comment. -- Ich bin Joachim von Hassel, und ich bin Pilot der Bundeswehr. Welle: Erdball - F104-G Starfighter

[jspano]

I've found it's a good place to start with. Takes some work to get it up to speed though all the way. I usually put another tier over it when using it. One example is that it doesn't support typed datasets.

[mthead]

I think the new version supports typed dataset, but I have not tried it because for some reason we do not want to move our stuff to .NET framework 1.1.

[Andy Brummer]

I think it is a good place to start, it's best feature is that it abstracts away from using the connection directly so that you have the potential of using a different database system if you need to. On my latest project, I ended up using CodeSmith and generated typed functions matching my stored procedures so that I have intellisense for the parameters. It's made it extremely easy to add things like instrumentation through performance counters.

---

I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon