tag:blogger.com,1999:blog-8691068330397730091.post8756942130686000703..comments2010-02-23T21:47:51.103-05:00Jameshttp://www.blogger.com/profile/07743081202945582329noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8691068330397730091.post-74268153382466947782010-02-23T21:47:51.103-05:002010-02-23T21:47:51.103-05:00@throwawayjj<br /><br />The 9/10 factor was a ballpark estimate I made judging from the dozens of CRUD systems I designed from start to finish (plus other projects I&#39;ve assisted with) and is not backed by any critical research aside from the half second it took me to think of it. It might be closer to 4/5, but I even doubt that.<br /><br />It&#39;s not to say that some projects require some greater level of control than what this pattern has to offer. That&#39;s where the 1/10 (or whatever) comes in. In these cases, you may need to harness the power of the SQL namespace, or even better yet, a more appropriate software pattern. (Unit of Work?)<br /><br />Perhaps your experiences are different than mine, but I&#39;ve found that most reasons to go the way of SQL vs. a reusable software pattern are typically unfounded and reek of premature optimization syndrome.<br /><br />Code readability issues are real, and are a huge threat to productivity where I work.Jameshttp://www.blogger.com/profile/07743081202945582329noreply@blogger.comtag:blogger.com,1999:blog-8691068330397730091.post-50960290416558144322010-02-23T18:07:04.566-05:002010-02-23T18:07:04.566-05:00On how many database-driven applications have you personally worked? I&#39;m wondering how you arrive at the conclusion that 9 out of 10 would appreciably improve by using the &quot;Repository Pattern&quot;.<br /><br />There are many good reasons to use plain SQL / stored procedures instead of ORM. For complex queries, ORM simply adds an unnecessary and bulky layer of abstraction that would result in more code than if you used plain SQL -- something you misrepresent in this post.<br /><br />And if SQL statements are unreadable (that is, 0 readability), then how would increasing readability by 500% help?<br /><br />All of this is not to say that there is no place for ORM, only that you&#39;ve inflated the value and applicability of it.throwawayjjhttp://throwawayjj.livejournal.com/noreply@blogger.comtag:blogger.com,1999:blog-8691068330397730091.post-6678140072500968472010-02-21T12:25:46.580-05:002010-02-21T12:25:46.580-05:00What should I be linking to? Sorry for the delay. Yes, I am on vacation. :-PJameshttp://www.blogger.com/profile/07743081202945582329noreply@blogger.comtag:blogger.com,1999:blog-8691068330397730091.post-83727340911644882472010-02-19T13:50:42.250-05:002010-02-19T13:50:42.250-05:00Links? Don&#39;t make me google this crap :-PAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8691068330397730091.post-59998047671494158132010-02-19T13:08:02.222-05:002010-02-19T13:08:02.222-05:00Blogging on vacation?Anonymousnoreply@blogger.com