Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 26th, 2009, 06:06 AM
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Best Practice : SP vs Inline Code

Hi,

Just wanted to say thanks for the great book. I have one question about your comments on page 35 with regards to using stored procedures .. namely the issues of having to remember to add the SPs appropriately for in the DataContext when the context is refreshed. This would lead me to believe that SPs will entail a higher maintenance effort and potentially higher risk of things going wrong when changes to the DB are made (and thus the Data Context refreshed? What are your recommendations.

Thanks for your feedback.

Regards
Don
 
Old June 28th, 2009, 09:39 PM
Wrox Author
 
Join Date: Jan 2009
Posts: 73
Thanks: 0
Thanked 7 Times in 7 Posts
Default

Yes, this is another area for much debate. Using inline SQL is easier to deploy but you can leave yourself open to SQL Injection attacks or other attacks if you don't format the SQL correctly. If you know your user base and know they have no idea what a SQL Injection attack is then inline SQL can be easier. You'll lose some performance using inline SQL also but again, it depends on what you're doing. If the site you develop is low volume than it probably doesn't make a difference.

Good luck




Similar Threads
Thread Thread Starter Forum Replies Last Post
exec sp within another sp collie SQL Server 2000 1 December 22nd, 2004 05:46 AM
Inline Code to Project rodmcleay VS.NET 2002/2003 1 December 14th, 2004 10:38 PM
error in inline code yoord BOOK: Beginning ASP.NET 1.0 1 November 1st, 2004 05:13 AM
Discussion: Code-Behind vs. Inline in ASP.Net planoie ASP.NET 1.x and 2.0 Application Design 3 September 20th, 2004 02:25 PM
Can a SP run another SP as sa? dbradley SQL Server 2000 0 July 17th, 2003 08:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.