Thanks Tom... Don't you love "Editor Inheritance"?
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 Thomas Tomiczek Sent: Friday, October 01, 2004 9:39 AM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] sqlDataReader and syntax error in SQL state ment 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 =================================== 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
