Hi, I've been using it in some applications. It's a great way to centralize some of the data access code, and the parameter caching can help app performance by reducing round trips to the db server. The second version cleaned up a bunch of stuff. Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
I've been using it for tons of my apps. It is a great helper utility in making db calls. I didn't even realise a new version was released recently. And support for typed datasets now. Woot! This app block is highly recommended! LH
And, best of all, you can use it with Option Strict On! Woohoo!
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
I am just curious that if it is so great and an example of MS programming pratices then why wasn't it used in any of the Starter Kits? Or is it not suited for that type of application? I am not trying to talk it down I am just curious why it never had much
attention before?
No Animals were harmed in the making of the Application
afaik, DataAccess Application Blocks are used in MS Starter Kits. Actually, I have discovered Data Access AB via a link in the source code of TimeTracker kit. I have been using a few other open source DAL's (even attemped to write my own), but imho this is
the best (or one of the best) solution available. (Also a good sample usage of Singleton design pattern)
The DAAB is also relatively new, so it will take time for them to use. The Starter Kits weren't developed by Microsoft but by independent devs, so it seems like they were on their own about whether to use the DAAB. But as the other post says, some use it. Don
Don Kiely, MCP, MCSD
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
I even didn't realize there is a special forum to discuss the DAAB. The following is the knowledge I knew about DAAB:
1. Two versions and their difference: It is a pretty new stuff, the DAAB
version 1.0 release on 4/23/2003, while the
version 2.0, dated on 6/27/2003. Version 2 of the DAABlock requires Visual Studio 2003, it doesn't compatible with or work for the current Visual Studio .NET.
2. Use of DAAB in Starter Kits: It is used by Time Tracker Starter Kit and Report Starter Kit. Some Starter Kits used it, some not. I guess it is not due to the time that if the DAAB is released, but due to the strategy the Starter Kit used itself. See
the release dates for some Starter Kits (from its white paper): Commerce Starter Kit: October 2002 Portal Starter Kit: November 2002 Report Starter Kit: November 2002 Time Tracker Starter Kit: November 2002 The strategy the different Sarter Kit used: Time
Tracker and Reports Starter Kits used the typical 3 tier strategy, that is the reason they used DAAB. Commerce, Portal and Store Starter Kits (including IBuySpy Portal and Store) used the 2 tier strategy, i.e. they mix the BBL within either UI or DAL. And
they didn't use DAAB. It might be reasonable, because the project is quite small, and don't have much business logic, without a clear 3 tier it even might make development easier. Community Starter Kit used a totally different strategy for its structure, it
build its pages on fly. But, actually, I don't understand why it didn't use DAAB. In its code, they use xxxUtility to handle the database access, they have at least 20 some xxxUtility, a tremendous code repeating. I believe, using DAAB should make its code
much simpler and more maintainable than what they have right now. 3. Is it great? Personally, I view it so great, it could be a universal tool in my or our program to handle the data access activities without any worry by ourselves. Even there were
some insufficient considerations in the current code, a team from Microsoft would do the backup. Image, can you do better job than the DAAB team? The only negative concern for me is its performance. But, I concluded it is not big deal. I would discuss this
issue in another thread at
Performance Or Me.
MCAD.NET (C#)
MCP on: SQL Server 2k Design&Iimplementation, Web Development (VI 6.0) and VB 5.0
By the way, there is a bug in DAAB's sample
version 1.0client testing code, it has been fixed with DAAB
version 2.0. The bug is when the client code uses SqlHelper.ExecuteReader to bring back a DataReader, it doesn't close the DataReader, which leads to a connection leaking. If you are interested, please see
231410, at the bottom.
MCAD.NET (C#)
MCP on: SQL Server 2k Design&Iimplementation, Web Development (VI 6.0) and VB 5.0
Hammer12
Member
655 Points
131 Posts
Is anyone using this?
Jul 16, 2003 04:41 PM|LINK
Hammer12
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: Is anyone using this?
Jul 16, 2003 05:41 PM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
LordHits
Member
520 Points
104 Posts
Re: Is anyone using this?
Jul 17, 2003 12:24 AM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: Is anyone using this?
Jul 17, 2003 03:22 AM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
Hammer12
Member
655 Points
131 Posts
Re: Is anyone using this?
Jul 17, 2003 11:05 AM|LINK
Hammer12
drZoode
Member
5 Points
1 Post
Re: Is anyone using this?
Jul 17, 2003 03:48 PM|LINK
donkiely
All-Star
15929 Points
2518 Posts
ASPInsiders
Moderator
MVP
Re: Is anyone using this?
Jul 18, 2003 01:38 AM|LINK
In the Last Frontier, Interior Alaska
Please post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem!
The Prodigy
Member
65 Points
13 Posts
Re: Is anyone using this?
Jul 28, 2003 11:28 PM|LINK
ghan
Participant
1440 Points
288 Posts
Re: Is anyone using this?
Jul 29, 2003 07:44 PM|LINK
MCP on: SQL Server 2k Design&Iimplementation, Web Development (VI 6.0) and VB 5.0
ghan
Participant
1440 Points
288 Posts
Re: Is anyone using this?
Jul 29, 2003 07:56 PM|LINK
MCP on: SQL Server 2k Design&Iimplementation, Web Development (VI 6.0) and VB 5.0