Shawn, they are not worth it. They are worth it only if you believe in a opy7Paste DAL and are not using some sort of code generator like codesmith.
Because: * If you use a smart DAL (like most O/R Mappers do) that is configured and not copied7pasted for every new class, then basically there is nothing to be gained by the DAAB. Our EntityBroker has exactly three classes dealing with all SQL for all business objects - not much that can be saved, and the DAAB is - as you said - a little "too smart" for it's own good. * If you use a generated DAL for somehting like codesmith, there is no need to have another external module of dubious quality. Only if you basically make the classical MS style DAL (which I call the stupic copy/paste style) is there something to be gained from the DAAB, but then the design decisions in it make it not too easy to deal with it at times. But it DOES cut down the LOC count you have to manually handle. Thomas Tomiczek THONA Software & Consulting Ltd. (Microsoft MVP C#/.NET) (CTO PowerNodes Ltd.) > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Shawn Wildermuth > Sent: Freitag, 1. Oktober 2004 15:33 > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] sqlDataReader and syntax error > in SQL state ment > > IMNSHO, the data access application block is more trouble > than it is worth. > It tries to be too sneaky for its own good and hide some of > the details. > This results in the type of problem you're having now. I > wish someone could convince me that they are worth the bits > they are written with. > > Thanks, > > Shawn Wildermuth > Sr. Consultant > Magenic Technology > http://www.magenic.com > http://adoguy.com > C# MVP, Author and Speaker > > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Joris Zwaenepoel > Sent: Friday, October 01, 2004 4:47 AM > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] sqlDataReader and syntax error > in SQL state ment > > You are correct, > > I am using the Microsoft Data Access Application Block. I > found that the exception was catched in the DAAB, to close > the database-connection, but then the error was not thrown > again. I have modified this and now it works as expected. > > Thanks a lot, > > Joris > > -----Original Message----- > From: Shawn Wildermuth [mailto:[EMAIL PROTECTED] > Sent: donderdag 30 september 2004 17:01 > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] sqlDataReader and syntax error > in SQL statement > > This isn't my experience. Though there are somethings that > work in QA that do not work right in the SQL Managed Provider > (though the reverse is odd). > Could you post the offending SQL? > > > > Thanks, > > Shawn Wildermuth > Sr. Consultant > Magenic Technology > http://www.magenic.com > http://adoguy.com > C# MVP, Author and Speaker > > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Joris Zwaenepoel > Sent: Thursday, September 30, 2004 10:48 AM > To: [EMAIL PROTECTED] > Subject: [ADVANCED-DOTNET] sqlDataReader and syntax error in > SQL statement > > Hi, > > I have noticed that when I have a syntax error (or incorrect > fieldname or tablename or ...) in an SQL statement, and then > try to get a datareader using that SQL statement, no > exception is thrown and ExecuteReader returns nothing. This > is not what I would expect. Is there a way to force ADO.NET > to throw an exception in this case, or another option to get > an error-message instead of just a Nothing? > > If I paste the SQL statement in SQL Query Analyser, then a > useful errormessage is displayed, so I would expect ADO.NET > to return the same error-message. > > Joris > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > Some .NET courses you may be interested in: > > Essential .NET: building applications and components with > CSharp August 30 - September 3, in Los Angeles > http://www.develop.com/courses/edotnet > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor(r) > http://www.develop.com Some .NET courses you may be interested in: > > Essential .NET: building applications and components with > CSharp August 30 - September 3, in Los Angeles > http://www.develop.com/courses/edotnet > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > Some .NET courses you may be interested in: > > Essential .NET: building applications and components with > CSharp August 30 - September 3, in Los Angeles > http://www.develop.com/courses/edotnet > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > Some .NET courses you may be interested in: > > Essential .NET: building applications and components with > CSharp August 30 - September 3, in Los Angeles > http://www.develop.com/courses/edotnet > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentor� http://www.develop.com Some .NET courses you may be interested in: Essential .NET: building applications and components with CSharp August 30 - September 3, in Los Angeles http://www.develop.com/courses/edotnet View archives and manage your subscription(s) at http://discuss.develop.com
