Why is this? Let's first look at the term 'inline'. Taken literally I'll agree with you about the nightmare, because the SQL is just splashed around in whatever code sections need it, but if I can use the term 'coded' SQL to mean SQL statements written in, say, C#, I will argue that the nightmare isn't always implied.
If each SQL operation is well thought out, and coded according to certain quality standards, there is very little different to using stored procs. The Create method that takes a business object as a parameter, and calls a stored procedure, and the Create method that takes the same parameter and builds a SQL statement appear exactly the same to my client code, and once developed and tested, can be trusted the same by my client code. > -----Original Message----- > From: Discussion of advanced .NET topics. [mailto:ADVANCED- > [EMAIL PROTECTED] On Behalf Of Gyorgy Bozoki > Sent: 16 November 2006 05:55 PM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] Data Structures in .Net? > > I fully agree with you stored procedures - using inline SQL turns code > into > a nightmare very quickly. Been there, done that (although I opposed > doing > it.) > > > -----Original Message----- > > From: Discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Chris Wuestefeld > > Sent: Thursday, November 16, 2006 09:41 > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > > Subject: Re: [ADVANCED-DOTNET] Data Structures in .Net? > > > > There are some who disagree with my stance on SPs (i.e., > > they're required in all cases), but if you're working on my > > team, I wouldn't let you do your inline SQL, either. It's > > more maintenance headaches, it blurs the architectural lines, > > and it's difficult to avoid vulnerabilities to injection attacks. > > =================================== > This list is hosted by DevelopMentor. http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
