This post originated from an RSS feed registered with .NET Buzz
by Roy Osherove.
Original Post: Stuff to know about the Data Application Block
Feed Title: ISerializable
Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/rosherove/Rss.aspx
Feed Description: Roy Osherove's persistent thoughts
Version 3 of this block is out there, kicking some serious butt. This version has unit tests to go along with it and it fixes a bug that was found in version 2. Get version 3 from here. Find out about the bug here.
The new version adds support for some generic ADO.Net interfaces. This means you can use it with different DB providers while utilizing the same interface.
It's almost always OK to discover stored procedure parameters automatically. Underneath, the parameter discovery happens only once per stored procedure, and is then saved in a parameter cache object for future calls to that sproc. A single extra call for the added simplicity of coding against the block and saving many many lines of code filling parameter arrays.