I'd like to also thank Frans -- Interesting stuff. I want to ask/raise one question:
What's the counter argument to the concern that trying to abstract my traditional data access (T-SQL, or PLSQL, etc) behind a DB-independent grammar causes losses in performance and or inability to exploit of features of my specific database? I mean, if I'm going to pay the cash for SqlServer or Oracle, I'd better get every last drop of perf out of it, yes? I suspect an easy/quick answer is simply to say that your grammar is sufficiently robust and properly implemented to translate appropriately and efficiently to all the different native dialects of SQL. Also, I suppose another quick answer is that this is the trade-off one must choose in going with an O/R layer -- flexibility vs. performance. Anyway, since you were so generous to previously reply with such a verbose response, I was just hoping for another :) -Brock > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Roman Antchik > Sent: Thursday, October 07, 2004 7:04 PM > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] Abstracting SQL > > Thank you very much Frans! As they say, knowledge is one of > those things - > the more you give the more you have. It will take me some > time to fully > understand what you wrote. Really like the idea of > EntityField objects. I > will definitely make another post! > > Cheers, > Roman. > > =================================== > 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� 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
